HOSP
Tables (5)
appointments
- appointment_id — INT
- patient_id — INT
- doctor_id — INT
- appointment_date — DATETIME
- status — ENUM('Scheduled', 'Completed', 'Cancelled')
- reason — TEXT
billing
- bill_id — INT
- patient_id — INT
- appointment_id — INT
- total_amount — DECIMAL(10,2)
- paid_amount — DECIMAL(10,2)
- payment_status — ENUM('Pending', 'Partial', 'Paid')
- bill_date — TIMESTAMP
doctors
- doctor_id — INT
- first_name — VARCHAR(50) — NOT NULL
- last_name — VARCHAR(50) — NOT NULL
- specialization — VARCHAR(100)
- dept_id — INT
- phone — VARCHAR(15)
- email — VARCHAR(100)
- salary — DECIMAL(10,2)
- hire_date — DATE
medical_records
- record_id — INT
- patient_id — INT
- doctor_id — INT
- diagnosis — TEXT
- prescription — TEXT
- visit_date — DATE
- follow_up_date — DATE
patients
- patient_id — INT
- first_name — VARCHAR(50) — NOT NULL
- last_name — VARCHAR(50) — NOT NULL
- date_of_birth — DATE
- gender — ENUM('M', 'F', 'Other')
- phone — VARCHAR(15)
- email — VARCHAR(100)
- address — TEXT
- blood_group — VARCHAR(5)
- registration_date — TIMESTAMP