SHOW CREATE TABLE dis_locatable_entity_states
SHOW CREATE TABLE dis_locatable_entity_states
┌─statement──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┐
│ CREATE TABLE db.dis_locatable_entity_states (`timestamp` DateTime, `location_online_status` LowCardinality(String), `cur_patient_state` LowCardinality(String), `cur_patient_timestamp` DateTime, `prev_patient_state` LowCardinality(String), `prev_patient_timestamp` DateTime, `loc_room_id` UUID, `loc_ward_id` UUID, `loc_floor_id` UUID, `loc_building_id` UUID, `loc_campus_id` UUID, `loc_campus_org_code` LowCardinality(String), `loc_timestamp` DateTime, `site_id` UUID, `site_type` LowCardinality(String), `site_name` String, `entity_id` UUID, `entity_org_code` LowCardinality(String), `entity_type` LowCardinality(String), `entity_sub_type` LowCardinality(String), `entity_name` String, `cur_clean_state` LowCardinality(String), `cur_clean_timestamp` DateTime, `prev_clean_state` LowCardinality(String), `prev_clean_timestamp` DateTime, `cur_broken_state` LowCardinality(String), `cur_broken_timestamp` DateTime, `prev_broken_state` LowCardinality(String), `prev_broken_timestamp` DateTime, `cur_in_use_state` LowCardinality(String), `cur_in_use_timestamp` DateTime, `prev_in_use_state` LowCardinality(String), `prev_in_use_timestamp` DateTime, `user` String, `group` String, `prev_user` String, `prev_group` String, `event_type` LowCardinality(String), `deleted_at` Nullable(DateTime)) ENGINE = Distributed(default, db, locatable_entity_states, rand())
