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