Structure DB tables (1 Viewer)

hasan_3

New member
Local time
Today, 09:44
Joined
Apr 9, 2020
Messages
3
What is the best way to structure DB tables for the attached picture?
 

Attachments

  • 111.jpg
    111.jpg
    506.2 KB · Views: 116

Ranman256

Well-known member
Local time
Today, 02:44
Joined
Apr 9, 2015
Messages
4,339
Like:

TSymptoms table
1 ,Fever
2 shortness of breath


TMedNotes tbl
PatientID,medNoteNum, Date,DayPer,Result
123, 1, 1/1/2020, Evening,0

TMedExam tbl
PatientID,Date,Comordities,covid,....etc


TPatient tbl
PatientID,FirstN,LastN,address,...etc.
 

hasan_3

New member
Local time
Today, 09:44
Joined
Apr 9, 2020
Messages
3
Thanks for your help

I didn't get the Result field in TMedNotes tbl

I need to collect data for 3 days only for 3 periods each day
 

onur_can

Active member
Local time
Yesterday, 23:44
Joined
Oct 4, 2015
Messages
180
Use at least 3 tables for the image, using the best way to configure DB tables.
1-Staff Information
2-Symptoms
3-days
Your staff master table will be associated with your main table in rechargeable tables.
 

mike60smart

Registered User.
Local time
Today, 06:44
Joined
Aug 6, 2017
Messages
1,899
Hi Hasan

here is one way of approaching this.
 

Attachments

  • Covid.zip
    41.7 KB · Views: 99

Users who are viewing this thread

Top Bottom