Pay
Hospital System

Hospital System

Patient

SS

DoctorDSS

Name

Insurance

DateAdmitted

DateCheckedOut

integer(10)

integer(10)

varchar(255)

varchar(255)

date

date

Test

ID

DoctorDSS

PatientSS

Name

TestDate

TestTime

Result

integer(10)

integer(10)

integer(10)

varchar(255)

date

timestamp

varchar(255)

Doctor

DSS

Name

Specialization

integer(10)

varchar(255)

varchar(255)

Hospital System

46
0
3
publish time: 2020-10-12
Charlotte

This is an E-R diagram (ERD) example for a hospital with a set of patients and a set of medical doctors. Each patient is associated with a log of the various tests and examinations conducted.

See More Related Templates