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