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)