gumi

Tables (17)

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 — divas.equipment
  • code — varchar(10) — NOT NULL — divas.equipment
  • 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 — divas.equipment
  • value — int4 — 수위
  • date — timestamptz — NOT NULL — 측정
  • reg_date — timestamptz — NOT NULL — DB

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) — Eld

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 — 수정

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 — Divas
  • 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 — 수정