hospital
Tables (5)
Doctor (doctor)
- Key (doctor_id) — int — Primary key — NOT NULL
- Key (department_id) — int — Foreign key → part.Key — NOT NULL
- Field (doname) — string
- Field (year) — int
Patient (patient)
- Key (patient_id) — int — Primary key — NOT NULL
- Field (age) — int
- Field2 (gender) — enum
Untitled (Reservation)
- Key (reservation_id) — int — Primary key — NOT NULL
- Key (doctor_id) — int — Foreign key → Doctor.Key — NOT NULL
- Key (patient_id) — int — Foreign key → Patient.Key — NOT NULL
- Field (price) — int
- Field (time) — datetime
hospital
- Key (hospital_id) — int — Primary key — NOT NULL
- Field (hname) — string
- Field (address) — string
part
- Key (department_id) — int — Primary key — NOT NULL
- Key (hospital_id) — int — Foreign key → hospital.Key — NOT NULL
- Field (dname) — string