db

Tables (9)

doctor (Untitled)

  • doctor_id (Key) — Primary key — NOT NULL
  • name (Field)
  • address (Field2)
  • phone_number (Field3)
  • password (Field4)
  • department_id (Key2) — Foreign key → medical_department.department_id — NOT NULL

examination (Untitled8)

  • Key — Primary key — NOT NULL
  • examination_datetime (Field)
  • examination_details (Field2)
  • doctor_id (Key2) — Foreign key → doctor.doctor_id — NOT NULL
  • patient_id (Key3) — Foreign key → patient.patient_id — NOT NULL

inpatient (Untitled6)

  • Key — Primary key — NOT NULL
  • room_information (Field)
  • admission_datetime (Field2)
  • discharge_datetime (Field3)
  • patient_id (Key2) — Foreign key → patient.patient_id — NOT NULL

medical_department (Untitled5)

  • department_id (Key) — Primary key — NOT NULL

medical_speciality (Untitled4)

  • department_id (Key) — Foreign key → medical_department.department_id — NOT NULL
  • department_name (Field)
  • department_phone_number (Field2)

nurse (Untitled2)

  • nurse_id (Key) — Primary key — NOT NULL
  • name (Field)
  • address (Field2)
  • phone_number (Field3)
  • password (Field4)
  • department_id (Key2) — Foreign key → medical_department.department_id — NOT NULL

patient (Untitled3)

  • patient_id (Key) — Primary key — NOT NULL
  • name (Field)
  • ssn (Field2)
  • gender (Field3)
  • address (Field4)
  • blood_type (Field5)
  • height (Field6)
  • weight (Field7)
  • phone_number (Field8)
  • password (Field9)
  • nurse_id (Key2) — Foreign key → nurse.nurse_id — NOT NULL
  • doctor_id (Key3) — Foreign key → doctor.doctor_id — NOT NULL

reservation (Untitled7)

  • reservation_number (Key) — Primary key — NOT NULL
  • reservation_datetime (Field)
  • patient_id (Key2) — Foreign key → patient.patient_id — NOT NULL
  • department_id (Key3) — Foreign key → medical_speciality.department_id — NOT NULL

treatment (Untitled9)

  • Key — Primary key — NOT NULL
  • treatment_datetime (Field)
  • treatment_details (Field2)
  • nurse_id (Key2) — Foreign key → nurse.nurse_id — NOT NULL
  • patient_id (Key3) — Foreign key → patient.patient_id — NOT NULL