Hospital Management

Tables (10)

DOC_ON_CALL (CopyOfUntitled2)

  • ID (Key3) — Foreign key → Doctors.ID — NOT NULL
  • Name (Key2) — Foreign key → Doctors.Name — NOT NULL
  • name (Field)
  • qualification (Field2)

DOC_REG (Untitled2)

  • ID (Key3) — Foreign key → Doctors.ID — NOT NULL
  • Name (Key2) — Foreign key → Doctors.Name — NOT NULL
  • name (Field)
  • qualification (Field2)

Department (Untitled)

  • Name (Key) — Primary key — NOT NULL
  • Location (Field2)
  • facilities ava (Field3)

Diagnosis (Untitled8)

  • ID (Key) — Foreign key → Doctors.ID — NOT NULL
  • Name (Key2) — Foreign key → Doctors.Name — NOT NULL
  • PT num (Key3) — Foreign key → PATIENTS.PT num — NOT NULL

Doctors (CopyOfUntitled)

  • ID (Key) — Primary key — NOT NULL
  • Name (Key2) — Foreign key → Department.Name — NOT NULL

PATIENTS (Untitled3)

  • PT num (Key) — Primary key — NOT NULL
  • SEX (Field)

PAT_ADMIT (Untitled4)

    PAT_OPR (Untitled7)

    • PT num (Key) — Foreign key → PATIENTS.PT num — NOT NULL

    PAT_REG (Untitled6)

    • PT num (Key) — Foreign key → PATIENTS.PT num — NOT NULL

    ROOM_DETAILS (Untitled5)

    • Room number (Key) — Primary key — NOT NULL