DoctorSchedules
ScheduleID char Doctors
* 0..1 0..1
ClinicalRoom DoctorID char DoctorID char
0..1 *
ClinicalRoomID char ClinicalRoomID char Qualifications varchar
RoomCode char Date date Specialist varchar
RoomName varchar StartTime time
Floor int EndTime time
Note varchar Note varchar
Prescriptions
1
PrescriptionID char
*
MedicalRecords DoctorID char
0..1 1
MedicalRecID char MedicalRecID char
AppointmentID char PrescriptionDate smalldatetime
Diagnosis text
MedicalRecordDate smalldatetime
TestResults
TestRequests TestResultsID char
0..1 1
LabTests TestRequestID char TestRequestID char
0..1 *
LabID char LabID char ResultData text
*
Name varchar MedicalRecID char ResultDate smalldatetime
Price money RequestDate smalldatetime Note varchar
Status enum
Admissions
0..1
AdmissionID char
InpatientMedications
InpatientRoom PatientID char
DetailID char
0..1 *
InpatientRoomID char InpatientRoomID char
*
AdmissionID char
RoomName varchar AdmissionDate smalldatetime
*
MedicineID char
RoomType varchar DischargeDate smalldatetime
DateAdministered smalldatetime
PricePerDay money Status enum
Quantity int
Capacity int
Note varchar
Inventories
PrescriptionDetails
InventoryID char Medicines *
PrescriptionID char
0..1
* 0..1
MedicineID char MedicineID char 1 *
MedicineID char
QuantityInStock int MedicineName varchar
Quantity int
BranchID char Unit varchar
ActiveIngredient text
MedicineSupplies Price money
0..1 *
SupplierID char SupplierID char
SupplierName varchar BatchNumber varchar
PhoneNumber varchar ExpiryDate date
Address varchar ImportDate date
StorageLocation varchar
DoctorSchedules
ScheduleID char Doctors
* 0..1 0..1
ClinicalRoom DoctorID char DoctorID char
0..1 *
ClinicalRoomID char ClinicalRoomID char Qualifications varchar
RoomCode char Date date Specialist varchar
RoomName varchar StartTime time
Floor int EndTime time
Note varchar Note varchar
Prescriptions
1
PrescriptionID char
*
MedicalRecords DoctorID char
0..1 1
MedicalRecID char MedicalRecID char
AppointmentID char PrescriptionDate smalldatetime
Diagnosis text
MedicalRecordDate smalldatetime
TestResults
TestRequests TestResultsID char
0..1 1
LabTests TestRequestID char TestRequestID char
0..1 *
LabID char LabID char ResultData text
*
Name varchar MedicalRecID char ResultDate smalldatetime
Price money RequestDate smalldatetime Note varchar
Status enum
Admissions
0..1
AdmissionID char
InpatientMedications
InpatientRoom PatientID char
DetailID char
0..1 *
InpatientRoomID char InpatientRoomID char
*
AdmissionID char
RoomName varchar AdmissionDate smalldatetime
*
MedicineID char
RoomType varchar DischargeDate smalldatetime
DateAdministered smalldatetime
PricePerDay money Status enum
Quantity int
Capacity int
Note varchar
Inventories
PrescriptionDetails
InventoryID char Medicines *
PrescriptionID char
0..1
* 0..1
MedicineID char MedicineID char 1 *
MedicineID char
QuantityInStock int MedicineName varchar
Quantity int
BranchID char Unit varchar
ActiveIngredient text
MedicineSupplies Price money
0..1 *
SupplierID char SupplierID char
SupplierName varchar BatchNumber varchar
PhoneNumber varchar ExpiryDate date
Address varchar ImportDate date
StorageLocation varchar