Hospital
Tables (7)
Appointment (Untitled3)
- appointment_id (Key) — int — Primary key — NOT NULL
- patient_id (Key2) — int — Foreign key → Patient.patient_id — NOT NULL
Appointmented_Department (Untitled6)
- id (Key) — int — Primary key — NOT NULL
- appointment_id (Key2) — int — Foreign key → Appointment.appointment_id — NOT NULL
- department_id (Key3) — int — Foreign key → Department.department_id — NOT NULL
Appointmented_Doctor (Untitled7)
- id (Key) — int — Primary key — NOT NULL
- appointment_id (Key2) — int — Foreign key → Appointment.appointment_id — NOT NULL
- doctor_id (Key3) — int — Foreign key → Doctor.Key — NOT NULL
Department (Untitled4)
- department_id (Key) — int — Primary key — NOT NULL
- name (Field) — varchar(20)
- contact_number (Field2) — varchar(20)
- hospital_id (Key2) — int — Foreign key → Hospital.hospital_id — NOT NULL
Doctor (Untitled2)
- Key — Primary key — NOT NULL
- name (Field) — varchar(10)
- belonging_hospital (Field2) — varchar(10)
- department_name (Field3) — varchar(20)
- experience (Field4) — int
- phone_number (Field5) — varchar(20)
- department_id (Key2) — int — Foreign key → Department.department_id — NOT NULL
Hospital (Untitled5)
- hospital_id (Key) — int — Primary key — NOT NULL
- name (Field) — varchar(20)
- address (Field2) — varchar(20)
Patient (Untitled)
- patient_id (Key) — int — Primary key — NOT NULL
- age (Field) — int
- gender (Field2)
- name (Field3) — varchar(10)
- phone_number (Field4) — varchar(20)