정보분석
테이블 (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