Hospital
Tables (4)
Clinic (ClinicModel)
- Clinic ID (id) — int — Primary key — NOT NULL
- Position (position) — string
- Clinic date (date)
- Clinic time (time)
- Disease (disease) — string
- Prescription ID (prescription_id) — string
Doctor (DoctorModel)
- Doctor ID (id) — int — Primary key — NOT NULL
- Name (name) — string
- Rank (rank) — string
- Department (dept) — string
Patient (PatientModel)
- Patient ID (id) — int — Primary key — NOT NULL
- Name (name) — string
- Gender (gender) — string
- Birthday (birth)
Record (RecordModel)
- Doctor ID (doctor_id) — int — Foreign key → Doctor.Doctor ID — NOT NULL
- Patient ID (patient_id) — int — Foreign key → Patient.Patient ID — NOT NULL
- Clinic ID (clinic_id) — int — Foreign key → Clinic.Clinic ID — NOT NULL