hospital

Tables (5)

chart (Untitled5)

  • chart_num (Key) — Primary key — NOT NULL
  • t_date (Field2) — Foreign key → treatment.t_date
  • t_num (Key5) — Foreign key → treatment.t_num — NOT NULL
  • doctor_opinion (Field)

doctor (Untitled)

  • doctor_id (Key) — int — Primary key — NOT NULL
  • d_subject (Field)
  • d_name (Field2)
  • d_gender (Field3)
  • d_phone (Field4)
  • d_email (Field5)
  • d_position (Field6)

nurse (Untitled2)

  • nurse_id (Key) — Primary key — NOT NULL
  • n_work (Field)
  • n_gender (Field2)
  • n_phone (Field3)
  • n_email (Field4)
  • n_position (Field5)

patient (Untitled3)

  • petient_id (Key) — Primary key — NOT NULL
  • p_doctor (Field)
  • p_nurse (Field2)
  • p_name (Field3)
  • p_number (Field4)
  • p_gender (Field5)
  • p_address (Field6)
  • p_email (Field7)
  • p_job (Field8)
  • doctor_id (Key2) — int — Foreign key → doctor.doctor_id — NOT NULL

treatment (Untitled4)

  • t_date (Field) — Primary key
  • t_num (Key) — Primary key — NOT NULL
  • petient_id (Key3) — Foreign key → patient.petient_id — NOT NULL
  • nurse_id (Key4) — Foreign key → nurse.nurse_id — NOT NULL
  • t_treat (Field2)