정보분석

테이블 (8)

tb_analysis

  • id — bigserial — 기본 키 — NOT NULL
  • user_id — varchar(20)
  • title — varchar(100)
  • condition_json — jsonb
  • condition_hash — varchar(64)
  • cache_key — varchar(64)
  • reg_dt — timestamp
  • traffic_rgn_id — uuid — 관제구역
  • dynamic_yn — varchar

tb_analysis_cache_detail

  • id — bigserial — 기본 키 — NOT NULL
  • cache_key — varchar(64) — NOT NULL
  • obj_id — int4
  • obj_cd_large — varchar
  • obj_dtt_time — timestamp
  • lat — float8
  • lon — float8
  • geom — public.geometry(point, 4326)
  • obj_cd_mid — varchar
  • obj_cd_sm — varchar

tb_analysis_cache_summary

  • cache_key — varchar(64) — 기본 키 — NOT NULL
  • object_count — int4
  • unique_object_count — int4
  • reg_dt — timestamp
  • last_data_time — timestamp

tb_dynamic_data

  • id — uuid — 기본 키 — NOT NULL — 동적데이터
  • name — varchar — NOT NULL — 동적데이터
  • transfer_cycle — varchar — NOT NULL — 전송
  • analysis_result — varchar — 분석
  • analysis_date — timestamp — 분석
  • last_transfer_date — timestamp — 마지막
  • reg_dt — timestamp — NOT NULL — 생성
  • rgtr_id — varchar — 생성자
  • is_active — varchar — 사용여부
  • analysis_id — int4
  • transfer_cycle_option — varchar
  • collection_date — int4

tb_transfer_connect

  • id — uuid — 외래 키 → tb_dynamic_data.id — NOT NULL — 동적데이터
  • t_id — uuid — 외래 키 → tb_transfer_target.t_id — NOT NULL — 전송기관

tb_transfer_log

  • id — uuid — 외래 키 → tb_dynamic_data.id — NOT NULL — 동적데이터
  • t_id — uuid — 외래 키 → tb_transfer_target.t_id — NOT NULL — 전송기관
  • transfer_dt — timestamp — NOT NULL — 전송

tb_transfer_target

  • t_id — uuid — 기본 키 — NOT NULL — 전송기관
  • t_name — varchar — NOT NULL — 전송기관
  • url — varchar — ip주소
  • port — varchar — 포트번호
  • is_active — varchar — 사용여부
  • reg_dt — timestamp
  • update_dt — timestamp

temp_analysis_result

  • id — bigserial — 기본 키 — NOT NULL
  • session_id — uuid — NOT NULL
  • cacheable — bool
  • obj_id — int4
  • obj_cd_large — varchar
  • obj_dtt_time — timestamp
  • lat — float8
  • lon — float8
  • geom — public.geometry(point, 4326)
  • reg_dt — timestamp
  • obj_cd_mid — varchar
  • obj_cd_sm — varchar