assignment

Tables (9)

admission_category (Untitled)

  • id (Key) — Primary key — NOT NULL
  • Field

assignment_admission_category

  • id — bigint
  • hospital_id — char(5) — NOT NULL
  • name — varchar(64) — NOT NULL
  • display_order — integer — NOT NULL
  • created_by — varchar(10) — NOT NULL
  • created_date_time — timestamp — NOT NULL
  • updated_by — varchar(10) — NOT NULL
  • updated_date_time — timestamp — NOT NULL

assignment_admission_room

  • id — bigint
  • category_id — bigint — NOT NULL
  • name — varchar(64) — NOT NULL
  • status — varchar(16) — NOT NULL
  • grid_row — integer — NOT NULL
  • grid_col — integer — NOT NULL
  • created_by — varchar(10) — NOT NULL
  • created_date_time — timestamp — NOT NULL
  • updated_by — varchar(10) — NOT NULL
  • updated_date_time — timestamp — NOT NULL

assignment_allocation

  • id — bigint
  • hospital_id — char(5) — NOT NULL
  • room_id — bigint — NOT NULL
  • customer_number — varchar(32)
  • customer_name — varchar(64)
  • doctor_staff_id — bigint
  • consultant_staff_id — bigint
  • assistant_staff_id — bigint
  • assigned_at — timestamp
  • completed_at — timestamp
  • status — varchar(16) — NOT NULL
  • created_by — varchar(10) — NOT NULL
  • created_date_time — timestamp — NOT NULL
  • updated_by — varchar(10) — NOT NULL
  • updated_date_time — timestamp — NOT NULL

assignment_allocation_history

  • id — bigint
  • allocation_id — bigint — NOT NULL
  • hospital_id — char(5) — NOT NULL
  • room_id — bigint — NOT NULL
  • customer_number — varchar(32)
  • customer_name — varchar(64)
  • doctor_staff_id — bigint
  • consultant_staff_id — bigint
  • assistant_staff_id — bigint
  • assigned_at — timestamp
  • completed_at — timestamp
  • status — varchar(16) — NOT NULL
  • created_by — varchar(10) — NOT NULL
  • created_date_time — timestamp — NOT NULL
  • updated_by — varchar(10) — NOT NULL
  • updated_date_time — timestamp — NOT NULL

assignment_event_log

  • id — bigint
  • event_type — varchar(64) — NOT NULL
  • payload — text — NOT NULL
  • created_at — timestamp — NOT NULL
  • created_by — varchar(10) — NOT NULL
  • created_date_time — timestamp — NOT NULL
  • updated_by — varchar(10) — NOT NULL
  • updated_date_time — timestamp — NOT NULL

assignment_staff

  • id — bigint
  • hospital_id — char(5) — NOT NULL
  • staff_id — varchar(32)
  • staff_name — varchar(64) — NOT NULL
  • staff_type — varchar(32) — NOT NULL
  • created_by — varchar(10) — NOT NULL
  • created_date_time — timestamp — NOT NULL
  • updated_by — varchar(10) — NOT NULL
  • updated_date_time — timestamp — NOT NULL

room_status_history

  • id — bigint
  • room_id — bigint — NOT NULL
  • old_status — varchar(16)
  • new_status — varchar(16) — NOT NULL
  • changed_at — timestamp — NOT NULL
  • changed_by — varchar(10) — NOT NULL
  • created_by — varchar(10) — NOT NULL
  • created_date_time — timestamp — NOT NULL
  • updated_by — varchar(10) — NOT NULL
  • updated_date_time — timestamp — NOT NULL

users

  • hospital_id — varchar(8) — Primary key — NOT NULL
  • user_id — varchar(10) — Primary key — NOT NULL
  • created_by — varchar(10) — NOT NULL
  • created_date_time — timestamp — NOT NULL
  • updated_by — varchar(10) — NOT NULL
  • updated_date_time — timestamp — NOT NULL
  • last_login_date_time — timestamp — NOT NULL
  • last_login_ip_address — varchar(39) — NOT NULL