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)