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_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