hospital

Tables (5)

Doctor (doctor)

  • Key (doctor_id) — int — Primary key — NOT NULL
  • Key (department_id) — int — Foreign key → part.Key — NOT NULL
  • Field (doname) — string
  • Field (year) — int

Patient (patient)

  • Key (patient_id) — int — Primary key — NOT NULL
  • Field (age) — int
  • Field2 (gender) — enum

Untitled (Reservation)

  • Key (reservation_id) — int — Primary key — NOT NULL
  • Key (doctor_id) — int — Foreign key → Doctor.Key — NOT NULL
  • Key (patient_id) — int — Foreign key → Patient.Key — NOT NULL
  • Field (price) — int
  • Field (time) — datetime

hospital

  • Key (hospital_id) — int — Primary key — NOT NULL
  • Field (hname) — string
  • Field (address) — string

part

  • Key (department_id) — int — Primary key — NOT NULL
  • Key (hospital_id) — int — Foreign key → hospital.Key — NOT NULL
  • Field (dname) — string