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