doctorreserve

Tables (3)

doctor (Untitled)

  • Key (doctor_id) — int — Primary key — NOT NULL
  • (doctor_name) — varchar(10)
  • (doctor_photo) — varchar(10)

doctor_workdays (Untitled2)

  • Key (doctor_workdays_id) — int — Primary key — NOT NULL
  • Key (doctor_id2) — int — Foreign key → doctor.Key — NOT NULL
  • (day of week)
  • Field (start_time)
  • Field (end_time)

reserve (Untitled3)

  • Key (reserve_id) — Primary key — NOT NULL
  • Key (doctor_workdays_id) — int — Foreign key → doctor_workdays.Key — NOT NULL
  • Key (doctor_id2) — int — Foreign key → doctor_workdays.Key — NOT NULL
  • Field (user_id)
  • Field (res_date)
  • Field (rest_time)
  • Field (writeday)