e-medo - Laravel Schema Designer

lab_tests

id increments
timestamps timestamps
softDeletes softDeletes
test_name string
payment_type enum
price decimal (10,2)
status enum

lab_requests

id increments
timestamps timestamps
softDeletes softDeletes
lab_test_id ^FK bigInteger
status enum

departments

id increments
timestamps timestamps
softDeletes softDeletes
name string
gender_type enum

wards

id increments
timestamps timestamps
softDeletes softDeletes
gender_type enum
department_id ^FK bigInteger
name string

beds

id increments
timestamps timestamps
softDeletes softDeletes
name string
ward_id ^FK bigInteger
gender_type enum
status enum

medicines

id increments
timestamps timestamps
softDeletes softDeletes
name string
price decimal
cost_type enum
quantity integer
status enum
formulation string

equipments

id increments
timestamps timestamps
softDeletes softDeletes
name string
identifier string
state enum

diagnoses

id increments
timestamps timestamps
softDeletes softDeletes
name string
icd_code string

prescriptions

id increments
timestamps timestamps
patient_id ^FK bigInteger
clinician_id ^FK bigInteger
medicine_id ^FK bigInteger
dose string
route string
status enum
prescription_status string
prescription_type enum
opd_ipd_id bigInteger

opd_procedures

id increments
timestamps timestamps
softDeletes softDeletes
name string
price decimal
cost_type enum
staus enum

consultations

id increments
timestamps timestamps
softDeletes softDeletes
patient_id ^FK bigInteger
procedure_type ^FK bigInteger
department_id ^FK bigInteger

surgery_types

id increments
timestamps timestamps
softDeletes softDeletes
name string
staus enum
price decimal
cost_type enum

surgeries

id increments
timestamps timestamps
patient_id ^FK bigInteger
clinician_id ^FK bigInteger
surgery_type_id ^FK bigInteger
notes mediumText
status enum
date date
start_time timestamp
end_time timestamp
pre_op_diagnosis string
post_op_diagnosis string

patient_bills

id increments
timestamps timestamps
softDeletes softDeletes
patient_id ^FK bigInteger
bill_type enum
amount decimal
date_time timestamp

patient_transfers

id increments
timestamps timestamps
softDeletes softDeletes
patient_id ^FK bigInteger
from_ward_id ^FK bigInteger
to_ward_id ^FK bigInteger
staus enum
transfered_by bigInteger

clinicians

id increments
timestamps timestamps
softDeletes softDeletes
name string
username string
password string
clinician_type string
email string
phone_number string

patients

id increments
timestamps timestamps
softDeletes softDeletes
name string
gender enum
patient_type enum
insurance_type string
insurance_number string
date_of_birth date
is_pregnant enum
phone_number string
address text
contact_person string
contact_person_phone_number string

discharges

id increments
timestamps timestamps
softDeletes softDeletes
patient_id ^FK bigInteger
staus enum
ward_id ^FK bigInteger
clinician_id ^FK bigInteger
outcome string
follow_up_date date

deaths

id increments
timestamps timestamps
softDeletes softDeletes
patient_id ^FK bigInteger
transed_out enum
ward_id ^FK bigInteger
clinician_id ^FK bigInteger
autopsy enum
time_of_death datetime
death_type enum
opd_ipd_id bigInteger

transfusions

id increments
timestamps timestamps
softDeletes softDeletes
patient_id ^FK bigInteger
clinician_id ^FK bigInteger
volume integer
transfusion_product string
diagnoses_id string
haemoglobin decimal (2,1)
blood_group string

admissions

id increments
timestamps timestamps
softDeletes softDeletes
patient_id ^FK bigInteger
clinician_id ^FK bigInteger
ward_id ^FK bigInteger
bed_id ^FK bigInteger
status enum

employees

id increments
timestamps timestamps
softDeletes softDeletes

vitals

id increments
timestamps timestamps
softDeletes softDeletes
patient_id ^FK bigInteger
clinician_id ^FK bigInteger
pulse smallInteger
temperature double (3,1)

opd_entries

id increments
timestamps timestamps
softDeletes softDeletes
clinician_id ^FK bigInteger
patient_id ^FK bigInteger
main_diagnosis_id ^FK bigInteger
other_diagnosis string
presenting_complaints text
history_of_presenting_complaints mediumText

patient_diagnosis

id increments
timestamps timestamps
softDeletes softDeletes
patient_id ^FK bigInteger
clinician_id ^FK bigInteger
diagnoses_id ^FK bigInteger
diagnosis_type enum

ipd_entries

id increments
timestamps timestamps
softDeletes softDeletes
clinician_id ^FK bigInteger
patient_id ^FK bigInteger
admission_id ^FK bigInteger
treatment_notes longText

fluids

id increments
timestamps timestamps
softDeletes softDeletes
patient_id ^FK bigInteger
clinician_id ^FK bigInteger
admission_id ^FK bigInteger
date date
time time
intravenous smallInteger
oral_fluid smallInteger
output smallInteger