Hospital

Tables (4)

Clinic (ClinicModel)

  • Clinic ID (id) — int — Primary key — NOT NULL
  • Position (position) — string
  • Clinic date (date)
  • Clinic time (time)
  • Disease (disease) — string
  • Prescription ID (prescription_id) — string

Doctor (DoctorModel)

  • Doctor ID (id) — int — Primary key — NOT NULL
  • Name (name) — string
  • Rank (rank) — string
  • Department (dept) — string

Patient (PatientModel)

  • Patient ID (id) — int — Primary key — NOT NULL
  • Name (name) — string
  • Gender (gender) — string
  • Birthday (birth)

Record (RecordModel)

  • Doctor ID (doctor_id) — int — Foreign key → Doctor.Doctor ID — NOT NULL
  • Patient ID (patient_id) — int — Foreign key → Patient.Patient ID — NOT NULL
  • Clinic ID (clinic_id) — int — Foreign key → Clinic.Clinic ID — NOT NULL