liver function test
Tables (6)
clinical
- patient_id — bigint — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
- birth_date — date — NOT NULL
- sex — varchar(6) — NOT NULL
- vital_status — varchar(15) — NOT NULL
- address — varchar(255)
- height — decimal(5,2)
- weight — decimal(5,2)
- user_id — varchar(150) — NOT NULL
- password — varchar(128) — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- is_active — tinyint(1)
- is_staff — tinyint(1)
- is_superuser — tinyint(1)
- last_login — datetime(6)
- residunt_number — int
dbr_appointments
- appointment_id — int — Primary key — NOT NULL
- appointment_date — date — NOT NULL
- appointment_time — time(6)
- hospital — varchar(100) — NOT NULL
- appointment_type — varchar(20) — NOT NULL
- details — longtext
- status — varchar(10) — NOT NULL
- reminder_enabled — tinyint(1) — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- patient_id — char(36) — Foreign key → clinical.patient_id — NOT NULL
dbr_blood_results
- blood_result_id — int — Primary key — NOT NULL
- ast — decimal(6,2)
- alt — decimal(6,2)
- alp — decimal(6,2)
- ggt — decimal(6,2)
- bilirubin — decimal(6,2)
- albumin — decimal(6,2)
- inr — decimal(6,2)
- platelet — decimal(6,2)
- afp — decimal(6,2)
- albi — decimal(6,2)
- taken_at — date — NOT NULL
- created_at — datetime(6) — NOT NULL
- patient_id — char(36) — Foreign key → clinical.patient_id — NOT NULL
- albi_grade — varchar(7)
- pt — decimal(6,2)
- r_gtp — decimal(6,2)
- risk_level — varchar(7)
- total_protein — decimal(6,2)
dbr_blood_test_references
- reference_id — int — Primary key — NOT NULL
- name — varchar(50) — NOT NULL
- normal_range_min — decimal(7,2)
- normal_range_max — decimal(7,2)
- unit — varchar(20)
- description — longtext
dbr_medical_facilities
- facility_id — int — Primary key — NOT NULL
- name — varchar(200) — NOT NULL
- type — varchar(50) — NOT NULL
- address — varchar(500) — NOT NULL
- phone — varchar(20) — NOT NULL
- latitude — decimal(9,6) — NOT NULL
- longitude — decimal(9,6) — NOT NULL
- rating — decimal(2,1)
- created_at — datetime(6) — NOT NULL
dbr_medications
- medication_id — int — Primary key — NOT NULL
- medication_name — varchar(200) — NOT NULL
- dosage — varchar(100) — NOT NULL
- frequency — varchar(100) — NOT NULL
- timing — varchar(100) — NOT NULL
- start_date — date — NOT NULL
- end_date — date
- is_active — tinyint(1) — NOT NULL
- created_at — datetime(6) — NOT NULL
- patient_id — char(32) — Foreign key → clinical.patient_id — NOT NULL