Сколько coulmns я могу создать в базе данных SQL server
I'm a beginner in databases, but i got a project for a clinic. I'm working on C#, and MS SQL Server 2008 R2(SP2). Problem is: Patients data are huge and it must be safe for years (new recordes will be saved every day) Every patient record must contains about 60 medical data fields Is that right to make the patient table contains 60 coulmns or what i should do?
Что я уже пробовал:
Patients table will be like this: Name Age Sex Address Phone X 27 Male there 01234 X2 32 Female next to X 56789 X3 18 Male next to X2 10453 and a lot other columns about 60 column, can i just create 60 columns in the same table? or create more than one table like six tables and distribute every patient data on these table like one table for every 10 columns and link all with ID?