assignment1
Tables (18)
AdmissionRecord
- AdmissionID — INT
- DateOfAdmission — DATE
- DischargeDate — DATE
- PatientID — INT
- HospitalName — VARCHAR(100)
Department
- DepartmentID — INT
- DepartmentName — VARCHAR(100)
- PatientCapacity — INT
Disease
- DiseaseID — INT
- Name — VARCHAR(100)
- Category — VARCHAR(50)
Dosage
- DosageID — INT
- PrescriptionID — INT
- DrugID — INT
Drug
- DrugID — INT
- Name — VARCHAR(100)
- Type — VARCHAR(50)
- Manufacturer — VARCHAR(100)
Employee
- PersonID — INT
- Role — VARCHAR(50)
EmployeeDepartmentRelationship
- EmployeeID — INT
- DepartmentID — INT
Hospital
- HospitalName — VARCHAR(100)
- Address — VARCHAR(200)
HospitalDepartmentRelationship
- HospitalName — VARCHAR(100)
- DepartmentID — INT
ICUAdmissionRecordRelationship
- ICUEntryDate — DATE
- ICUExitDate — DATE
- AdmissionID — INT
ICUHospitalRelationship
- ICUTypeName — VARCHAR(50)
- HospitalName — VARCHAR(100)
ICUType
- ICUTypeName — VARCHAR(50)
- Capacity — INT
LabRecord
- LabRecordID — INT
- PatientID — INT
MedicalTest
- TestID — INT
- Type — VARCHAR(50)
- Name — VARCHAR(100)
- UniqueIdentifier — VARCHAR(50)
Patient
- PersonID — INT
- DateOfDeath — DATE
Person
- PersonID — INT
- Age — INT
- Gender — VARCHAR(10)
- Ethnicity — VARCHAR(50)
- PhoneNumber — VARCHAR(15)
Prescription
- RXNumber — INT
- StartDate — DATE
- EndDate — DATE
- AdmissionID — INT
TestResult
- TestResultID — INT
- TestDate — DATE
- TestValue — VARCHAR(50)
- Outcome — VARCHAR(10)
- LabRecordID — INT
- TestID — INT