What is the best way to structure DB tables for the attached picture?
H hasan_3 New member Local time Today, 09:44 Joined Apr 9, 2020 Messages 3 Jul 3, 2020 #1 What is the best way to structure DB tables for the attached picture? Attachments 111.jpg 506.2 KB · Views: 116
Ranman256 Well-known member Local time Today, 02:44 Joined Apr 9, 2015 Messages 4,339 Jul 3, 2020 #2 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.
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.
H hasan_3 New member Local time Today, 09:44 Joined Apr 9, 2020 Messages 3 Jul 3, 2020 #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
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
Ranman256 Well-known member Local time Today, 02:44 Joined Apr 9, 2015 Messages 4,339 Jul 3, 2020 #4 The value you enter on the paper.
onur_can Active member Local time Yesterday, 23:44 Joined Oct 4, 2015 Messages 180 Jul 3, 2020 #5 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.
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.
jdraw Super Moderator Staff member Local time Today, 02:44 Joined Jan 23, 2006 Messages 15,364 Jul 3, 2020 #6 Cross-posted at UA with responses.
mike60smart Registered User. Local time Today, 06:44 Joined Aug 6, 2017 Messages 1,899 Jul 3, 2020 #7 Hi Hasan here is one way of approaching this. Attachments Covid.zip 41.7 KB · Views: 99
H hasan_3 New member Local time Today, 09:44 Joined Apr 9, 2020 Messages 3 Jul 3, 2020 #8 Thank for your help Special thanks to @mike60smart and @Ranman256