I have a table consisting of patient information I have a separate table with the patient contact in case of emergency names I have a third table called telephone which is set up like this:
phoneID is the PK for tbltelephone
patientID is the PK for tblPatient and FK for tblcontact and tbltelephone
contactID is the Pk for tblContacts and FK for tbltelephones.
I was wondering if in someone's opinion there is a better way to structure these tables.
phoneID is the PK for tbltelephone
patientID is the PK for tblPatient and FK for tblcontact and tbltelephone
contactID is the Pk for tblContacts and FK for tbltelephones.
I was wondering if in someone's opinion there is a better way to structure these tables.