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