sws
Tables (3)
scheduler_preference
- hospital_id (hospital_id2) — char(5) — Foreign key → scheduler_user.hospital_id — NOT NULL
- user_id (user_id2) — varchar(10) — Foreign key → scheduler_user.user_id — NOT NULL
- reservation_interval_in_minute (reservation_gap) — int — NOT NULL
- last_selected_dept_code — varchar(10) — NOT NULL
- last_selected_dept_user_id — varchar(10) — NOT NULL
scheduler_user (CopyOfscheduler_preference)
- hospital_id — char(5) — Primary key — NOT NULL
- user_id — varchar(10) — Primary key — NOT NULL
- last_login (reservation_gap) — DATETIME — NOT NULL
selected_department_preference
- dept_user_id — varchar(10) — Primary key — NOT NULL
- dept_code — varchar(10) — Primary key — NOT NULL
- hospital_id (hospital_id22) — char(5) — Foreign key → scheduler_preference.hospital_id — NOT NULL
- user_id (user_id22) — varchar(10) — Foreign key → scheduler_preference.user_id — NOT NULL
- is_active (Field) — Boolean — NOT NULL