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