test
Tables (22)
ims_msg_hub_result_log
- tx_id — varchar(60) — Primary key — NOT NULL
- dest_id — varchar(64) — Primary key — NOT NULL
- status_cd — bpchar(1) — NOT NULL
- msg_rcv_dt — bpchar(17)
- err_cnt — int4
- err_msg — bytea
- msg_size — int4
- retry_cnt — int4
seq_report_no
- last_value — int8 — NOT NULL
- log_cnt — int8 — NOT NULL
- is_called — bool — NOT NULL
seq_report_type_no
- last_value — int8 — NOT NULL
- log_cnt — int8 — NOT NULL
- is_called — bool — NOT NULL
spatial_ref_sys
- srid — int4 — Primary key — NOT NULL
- auth_name — varchar(256)
- auth_srid — int4
- srtext — varchar(2048)
- proj4text — varchar(2048)
tb_ids_camera_info
- camera_id — varchar(40) — Primary key — NOT NULL
- camera_view_id — varchar(40)
- equip_id — varchar(40) — NOT NULL
- rtsp_url — varchar(100)
- name — varchar(20)
- link_code — varchar(20) — NOT NULL
- position — float4 — NOT NULL
- inst_type — varchar(20)
- inst_height — int4
- bracket_type — varchar(20)
- resolution — varchar(10)
- camera_index — int4
- rtsp_alias — varchar(20)
- camera_device_type — varchar(20)
- camera_type — varchar(20)
- direction — bpchar(1)
- section — varchar(100)
- view_position — float4
- yugo_detector_yn — varchar(1)
- radar_cctv_yn — varchar(1)
tb_ids_equip
- equip_id — varchar(40) — Primary key — NOT NULL
- equip_view_id — varchar(40)
- tech — varchar(20)
- mnf — varchar(20)
- inst_year — varchar(4)
- model — varchar(20)
- camera_count — int4
- detect_begin_milestone — varchar(10)
- detect_end_milestone — varchar(10)
- begin_lane_direction — varchar(10)
- begin_lane_index — int4
- end_lane_direction — varchar(10)
- end_lane_index — int4
- detect_v_distance — int4
- detect_h_distance — int4
- equip_name — varchar(60)
- road — varchar(40)
- direction — bpchar(1)
- connect_ip — varchar(16)
- connect_port — varchar(5)
- inst_location — varchar(20)
- position — float4
- tunnel_class — bpchar(1)
- link_code — varchar(20)
- section — varchar(50)
tb_ids_equip_state
- id — varchar(40) — Primary key — NOT NULL
- state — varchar(1)
- type — varchar(10)
- detect_time — timestamp
tb_ids_equip_traffic_info
- id — varchar(40) — Primary key — NOT NULL
- type — varchar(10)
- detect_time — timestamp
- avr_speed — float4 — NOT NULL
- vehicle_count — int4
tb_ids_event
- no — bigserial — NOT NULL
- occur_time — timestamp — NOT NULL
- camera_id — varchar(40) — NOT NULL
- d_event_type — int4 — NOT NULL
- rec_video_url — varchar(150) — NOT NULL
- rec_image_url — varchar(150)
- e_longitude — float4
- e_latitude — float4
- position — float4
- elevation — int4
- distance — int4
- link_code — varchar(20)
- confirm_id — varchar(20)
- confirmed — bool
- r_event_type — int4
- confirm_type — int4
- memo — varchar(1000)
- alert_level — int4
- alert_description — varchar(2000)
- vehicle_count — int4
- equip_id — varchar(50)
- created_at — timestamp
tb_ids_link_code
- link_code — varchar(20) — Primary key — NOT NULL
- road — varchar(50) — NOT NULL
- location — varchar(50) — NOT NULL
- bound — int4
- direction — varchar(20) — NOT NULL
- organization — varchar(20) — NOT NULL
- headquater — varchar(20) — NOT NULL
- branch — varchar(20) — NOT NULL
- location_type — varchar(20)
- length — varchar(20)
- length_level — varchar(20)
- road_id — varchar(50)
- lane_cnt — int4
- tunnel_order — int4
tb_ids_login_log
- no — int4 — Primary key — NOT NULL
- login_id — varchar(20) — NOT NULL
- login_ip — varchar(16)
- login_date — timestamp — NOT NULL
tb_ids_real_vehicle
- vehicle_time — varchar(17) — NOT NULL
- bound — varchar(1) — NOT NULL
- vehicle_data — text
tb_ids_real_vehicle_data
- no — bigserial — NOT NULL
- bound — varchar
- vehicle_data — text
- vehicle_time — timestamp
- created_at — timestamp
- port — varchar
- start_num — int8
tb_ids_relay
- no — serial4 — Primary key — NOT NULL
- link_code — varchar(20)
- ip — varchar(16)
- port — int4
- start_position — numeric(6, 3)
- end_position — numeric(6, 3)
- reconnectsec — int4
- taskcount — int2
- bound — int2
- sort — int4
tb_ids_report
- no — int4 — Primary key — NOT NULL
- type — int4
- title — varchar(100)
- content — varchar(200)
- file_path — varchar(60)
- file_real_path — varchar(60)
- reg_id — varchar(20)
- reg_date — timestamp
- mod_date — timestamp
tb_ids_report_type
- no — int4 — Primary key — NOT NULL
- name — varchar(50)
- file_path — varchar(60)
- file_real_path — varchar(60)
- mod_id — varchar(20)
- mod_date — timestamp
tb_ids_schedule
- no — int4 — Primary key — NOT NULL
- start_position — bpchar(5) — NOT NULL
- end_position — bpchar(5) — NOT NULL
- start_date — bpchar(10) — NOT NULL
- end_date — bpchar(10) — NOT NULL
- start_time — bpchar(5)
- end_time — bpchar(5)
- reg_id — varchar(20)
- reg_name — varchar(20)
- road — varchar(50)
- bound — bpchar(1)
- schedule_name — varchar(60) — NOT NULL
- link_code — varchar(20) — NOT NULL
tb_ids_site_info
- site_id — varchar(20) — Primary key — NOT NULL
- site_nm — varchar(50) — NOT NULL
- event_list — varchar(200) — NOT NULL
- radar_detector_yn — varchar(1) — NOT NULL
- sound_detector_yn — varchar(1) — NOT NULL
- yugo_detector_yn — varchar(1) — NOT NULL
- port_list — varchar(50)
tb_ids_systemlog
- log_id — bigserial — Primary key — NOT NULL
- user_id — bpchar(12) — 사용자
- user_name — varchar(50) — 사용자
- access_type — varchar(50) — 접근구분
- access_ip — varchar(200) — 접근IP
- api_route — varchar(200) — API
- error_yn — bpchar(1) — 오류
- access_dt — varchar(17) — 접근일시
tb_ids_traffic_info
- no — serial4 — NOT NULL
- link_code — varchar(20) — NOT NULL
- detect_time — timestamp — NOT NULL
- avr_speed — float4 — NOT NULL
- vehicle_count — int4
tb_ids_user
- user_id — varchar(20) — Primary key — NOT NULL
- password — varchar(100) — NOT NULL
- user_name — varchar(10)
- tel_num — varchar(15)
- extension — varchar(10)
- reg_date — timestamp
- user_auth — bpchar(1)
- branch_code — varchar(20)
- failcnt — int4
- fir — varchar
- modification_date — timestamp
- speed_color — varchar(50)
- event_popup_timer — int4
- auto_list — varchar(200)
- popup_cancle_list — varchar(200)
- user_email — varchar(200)
- auth_code — varchar(50)
- check_auth_code_yn — varchar(1)
- expire_date — timestamp
- last_login_date — timestamp
tb_vds_traffic
- no — bigserial — Primary key — NOT NULL
- detect_time — timestamp
- link_code — varchar(20)
- period — bpchar(8)
- lane — int4
- count — int4
- speed — float4
- occupancy — float4
- length — float4
- id — varchar(40)
- position — float4