test
Tables (21)
disaster_history
- id — serial4 — Primary key — NOT NULL
- dev_serial — int4 — NOT NULL
- level — int4 — NOT NULL
- uid — varchar(50) — NOT NULL
- reg_date — timestamptz
- upd_date — timestamptz
disaster_level
- level — int4 — NOT NULL
- name — varchar(20) — NOT NULL
disaster_opmode
- opmode — int4 — NOT NULL
- name — varchar(20) — NOT NULL
divas_equipment
- id — varchar(100) — Primary key — NOT NULL
- code — varchar(10) — NOT NULL
- name — varchar(100) — NOT NULL
- level1 — int4
- level2 — int4
- level3 — int4
- level4 — int4
- reg_date — timestamptz — NOT NULL
- upd_date — timestamptz
divas_flood
- code — varchar(10) — NOT NULL
- value — int4
- date — timestamptz — NOT NULL
- reg_date — timestamptz — NOT NULL
eld_history
- id — serial4 — Primary key — NOT NULL
- dev_serial — int4 — NOT NULL
- send_time — timestamp — NOT NULL
- msg_no — int4
- message — text
- status — int4 — NOT NULL
- reg_date — timestamptz — NOT NULL
- upd_date — timestamptz
- eld_id — varchar(20)
error_history
- id — serial4 — Primary key — NOT NULL
- dev_serial — int4
- device_info — varchar(50)
- error_time — timestamptz — NOT NULL
- code — int4 — NOT NULL
- error_message — text
- recovery_time — timestamptz
- reg_date — timestamptz — NOT NULL
- upd_date — timestamptz
error_type
- code — serial4 — Primary key — NOT NULL
- error_type — varchar(30) — NOT NULL
gate_history
- id — serial4 — Primary key — NOT NULL
- dev_serial — int4 — NOT NULL
- send_time — timestamp — NOT NULL
- dch_ch — int4
- command — varchar
- reg_date — timestamptz — NOT NULL
- upd_date — timestamptz
layer_doonchi
- uid — uuid — Primary key — NOT NULL
- area — varchar(20)
- name — varchar(100)
- asset_type — varchar(100)
- geom — public.geometry(geometry, 4326)
- install_date — varchar(50)
- asset_id — varchar(100)
- address — varchar(250)
- model — varchar(100)
- state — public."state"
- sublayer_id — varchar(64)
- dev_serial — int4
- disaster_opmode — int4
- disaster_level — int4
- cctv_list — varchar(1000)
- reg_date — timestamptz
- upd_date — timestamptz
layer_doonchi_eld
- uid — uuid — Primary key — NOT NULL
- area — varchar(20)
- name — varchar(100)
- asset_type — varchar(100)
- geom — public.geometry(geometry, 4326)
- install_date — varchar(50)
- asset_id — varchar(100)
- address — varchar(250)
- model — varchar(100)
- state — public."state"
- sublayer_id — varchar(64)
- dev_serial — int4
- eld_id — varchar(20)
- eld_state — varchar(20)
- reg_date — timestamptz
- upd_date — timestamptz
layer_doonchi_gate
- uid — uuid — Primary key — NOT NULL
- area — varchar(20)
- name — varchar(100)
- asset_type — varchar(100)
- geom — public.geometry(geometry, 4326)
- install_date — varchar(50)
- asset_id — varchar(100)
- address — varchar(250)
- model — varchar(100)
- state — public."state"
- sublayer_id — varchar(64)
- dev_serial — int4
- dch_ch — int4
- gate_state — varchar(20)
- lpr_state — varchar(20)
- ch_id — int4
- ch_type — int4
- gate_type — varchar(20)
- cctv_list — varchar(1000)
- use_gate_control — bool
- reg_date — timestamptz
- upd_date — timestamptz
layer_doonchi_speaker
- uid — uuid — Primary key — NOT NULL
- area — varchar(20)
- name — varchar(100)
- asset_type — varchar(100)
- geom — public.geometry(geometry, 4326)
- install_date — varchar(50)
- asset_id — varchar(100)
- address — varchar(250)
- model — varchar(100)
- state — public."state"
- sublayer_id — varchar(64)
- dev_serial — int4
- speaker_id — int4
- speaker_ip — varchar(20)
- speaker_port — int4
- speaker_state — varchar(20)
- id — varchar(100)
- pass — varchar(1000)
- reg_date — timestamptz
- upd_date — timestamptz
- speaker_state_code — int4 — NOT NULL
opmode_history
- id — serial4 — Primary key — NOT NULL
- dev_serial — int4 — NOT NULL
- opmode — int4 — NOT NULL
- uid — varchar(50) — NOT NULL
- reg_date — timestamptz — NOT NULL
- upd_date — timestamptz
ref_doonchi_divas
- dev_serial — int4 — NOT NULL
- divas_code — varchar(10) — NOT NULL
- reg_date — timestamptz — NOT NULL
- upd_date — timestamptz
setup_eld
- dev_serial — int4 — NOT NULL
- level — int4 — NOT NULL
- msg_no — int4
- reg_date — timestamptz — NOT NULL
- upd_date — timestamptz
setup_gate
- dev_serial — int4 — NOT NULL
- dch_ch — int4 — NOT NULL
- action_normal — varchar
- action_disaster — varchar
- reg_date — timestamptz — NOT NULL
- upd_date — timestamptz
setup_sms
- dev_serial — int4 — NOT NULL
- level — int4 — NOT NULL
- msg — varchar
- reg_date — timestamptz — NOT NULL
- upd_date — timestamptz
setup_speaker
- dev_serial — int4 — NOT NULL
- speaker_id — int4 — NOT NULL
- level — int4 — NOT NULL
- location — varchar
- repeat — int4
- reg_date — timestamptz — NOT NULL
- upd_date — timestamptz
- track_name — varchar(255) — NOT NULL
sms_history
- id — serial4 — Primary key — NOT NULL
- entry_id — varchar
- plate_number — varchar(20)
- phone_number — varchar(256)
- message — text — NOT NULL
- send_date — timestamptz — NOT NULL
- status — int4 — NOT NULL
- reg_date — timestamptz — NOT NULL
- upd_date — timestamptz
- dev_serial — int4
- request_id — int4
- msg_id — int4
speaker_history
- id — serial4 — Primary key — NOT NULL
- dev_serial — int4 — NOT NULL
- send_time — timestamp — NOT NULL
- speaker_id — int4
- track_name — text
- status — int4 — NOT NULL
- reg_date — timestamptz — NOT NULL
- upd_date — timestamptz