Hospital
Tables (5)
DEPARTMENT (Untitled4)
- DEPARTMENT_NAME (Key) — Primary key — NOT NULL
- NUMBER (Field2)
- HOSPITAL_ID (Key2) — Foreign key → HOSPITAL.HOSPITAL_ID — NOT NULL
DOCTOR (Untitled2)
- DOCTOR_ID (Key) — Primary key — NOT NULL
- NAME (.)
- HOSPITAL (Field)
- NAME (Field2)
- DEPARTMENT (Field3)
- HISTORY (Field4)
- DEPARTMENT_NAME (Key2) — Foreign key → DEPARTMENT.DEPARTMENT_NAME — NOT NULL
HOSPITAL (Untitled3)
- HOSPITAL_ID (Key) — Primary key — NOT NULL
- NAME (Field)
- ADDRESS (Field2)
PATIENT
- PATIENT_ID (Key) — Primary key — NOT NULL
- AGE (NAME)
- Field
RESERVATION (Untitled)
- RESERVATION_ID (Key) — Primary key — NOT NULL
- TIME (Field)
- BILL (Field2)
- DIAGNOSIS (Field3)
- DOCTOR_ID (Key2) — Foreign key → DOCTOR.DOCTOR_ID — NOT NULL
- DEPARTMENT_NAME (Key3) — Foreign key → DEPARTMENT.DEPARTMENT_NAME — NOT NULL
- HOSPITAL_ID (Key4) — Foreign key → HOSPITAL.HOSPITAL_ID — NOT NULL
- PATIENT_ID (Key5) — Foreign key → PATIENT.PATIENT_ID — NOT NULL