Hospital ER Diagram: Patient, Doctor, Associates, Tests & Examinations

ER Diagram for Hospital

[Patient]

- PatientID (Primary Key)

- FirstName

- LastName

- Age

- Address

- PhoneNumber

- InsuranceProvider

[MedicalDoctor]

- DoctorID (Primary Key)

- FirstName

- LastName

- Specialty

[Associate]

- AssociateID (Primary Key)

- FirstName

- LastName

- Department

[Test]

- TestID (Primary Key)

- TestName

- Description

[Examination]

- ExaminationID (Primary Key)

- PatientID (Foreign Key References Patient.PatientID)

- DoctorID (Foreign Key References MedicalDoctor.DoctorID)

- AssociateID (Foreign Key References Associate.AssociateID)

- TestID (Foreign Key References Test.TestID)

- Date

- Result

[Log]

- LogID (Primary Key)

- PatientID (Foreign Key References Patient.PatientID)

- DoctorID (Foreign Key References MedicalDoctor.DoctorID)

- AssociateID (Foreign Key References Associate.AssociateID)

- ExaminationID (Foreign Key References Examination.ExaminationID)

- Date

- Notes