도시침수
테이블 (54)
fldm_105
- gid — varchar(15) — 기본 키 — NOT NULL
- id — float8
- gridcode — float8
- bname — varchar(254)
- geom — public.geometry(multipolygon, 5181)
fldm_117
- gid — varchar(15) — 기본 키 — NOT NULL
- objectid — float8
- id — float8
- gridcode — float8
- shape_leng — numeric
- shape_area — numeric
- geom — public.geometry(multipolygon, 5181)
fldm_coast_100y
- gid — varchar(15) — 기본 키 — NOT NULL
- z_value — varchar(254)
- name — varchar(254)
- layer — varchar(254)
- geom — public.geometry(multipolygonzm, 5179)
fldm_river
- gid — varchar(15) — 기본 키 — NOT NULL
- layer — varchar(254)
- geom — public.geometry(multipolygon, 102082)
hjd_rain_expect_layer
- gid — PK — 기본 키 — NOT NULL
- adm_dr_cd — varchar(7)
- adm_dr_nm — varchar(50)
- emd_bjd_cd — varchar(254)
- nx — varchar(254)
- ny — varchar(254)
- geom — public.geometry(multipolygon, 5179)
- adm_gu_nm — varchar(20)
sensor_mast (CopyOfCopyOfsensor_mast4)
- sensor_cd — varchar(15) — 기본 키 — NOT NULL
- sensor_name — varchar(120)
- area_cd — varchar(12)
- lat — varchar(20)
- lon — varchar(20)
- gbcd — varchar(8)
- reg_dt — varchar(20)
- update_dt — varchar(20)
- ico_url — varchar(150)
- map_top — varchar(20)
- map_left — varchar(20)
- etc1 — varchar(12)
- line — varchar(7)
- use_yn — varchar
- order — int4
sensor_mast (CopyOfsensor_mast4)
- sensor_cd — varchar(15) — 기본 키 — NOT NULL
- sensor_name — varchar(120)
- area_cd — varchar(12)
- lat — varchar(20)
- lon — varchar(20)
- gbcd — varchar(8)
- reg_dt — varchar(20)
- update_dt — varchar(20)
- ico_url — varchar(150)
- map_top — varchar(20)
- map_left — varchar(20)
- etc1 — varchar(12)
- line — varchar(7)
- use_yn — varchar
- order — int4
sensor_mast (CopyOfCopyOfsensor_mast3)
- sensor_cd — varchar(15) — 기본 키 — NOT NULL
- sensor_name — varchar(120)
- area_cd — varchar(12)
- lat — varchar(20)
- lon — varchar(20)
- gbcd — varchar(8)
- reg_dt — varchar(20)
- update_dt — varchar(20)
- ico_url — varchar(150)
- map_top — varchar(20)
- map_left — varchar(20)
- etc1 — varchar(12)
- line — varchar(7)
- use_yn — varchar
- order — int4
sensor_mast (CopyOfsensor_mast3)
- sensor_cd — varchar(15) — 기본 키 — NOT NULL
- sensor_name — varchar(120)
- area_cd — varchar(12)
- lat — varchar(20)
- lon — varchar(20)
- gbcd — varchar(8)
- reg_dt — varchar(20)
- update_dt — varchar(20)
- ico_url — varchar(150)
- map_top — varchar(20)
- map_left — varchar(20)
- etc1 — varchar(12)
- line — varchar(7)
- use_yn — varchar
- order — int4
sensor_mast (CopyOfsensor_mast2)
- sensor_cd — varchar(15) — 기본 키 — NOT NULL
- sensor_name — varchar(120)
- area_cd — varchar(12)
- lat — varchar(20)
- lon — varchar(20)
- gbcd — varchar(8)
- reg_dt — varchar(20)
- update_dt — varchar(20)
- ico_url — varchar(150)
- map_top — varchar(20)
- map_left — varchar(20)
- etc1 — varchar(12)
- line — varchar(7)
- use_yn — varchar
- order — int4
sensor_mast (CopyOfsensor_mast)
- sensor_cd — varchar(15) — 기본 키 — NOT NULL
- sensor_name — varchar(120)
- area_cd — varchar(12)
- lat — varchar(20)
- lon — varchar(20)
- gbcd — varchar(8)
- reg_dt — varchar(20)
- update_dt — varchar(20)
- ico_url — varchar(150)
- map_top — varchar(20)
- map_left — varchar(20)
- etc1 — varchar(12)
- line — varchar(7)
- use_yn — varchar
- order — int4
sensor_mast
- sensor_cd — varchar(15) — 기본 키 — NOT NULL
- sensor_name — varchar(120)
- area_cd — varchar(12)
- lat — varchar(20)
- lon — varchar(20)
- gbcd — varchar(8)
- reg_dt — varchar(20)
- update_dt — varchar(20)
- ico_url — varchar(150)
- map_top — varchar(20)
- map_left — varchar(20)
- etc1 — varchar(12)
- line — varchar(7)
- use_yn — varchar
- order — int4
set_sensor_cd
- sensor_cd — varchar(15)
sig_layer
- gid — varchar(15) — 기본 키 — NOT NULL
- sig_cd — varchar(5)
- sig_eng_nm — varchar(40)
- sig_kor_nm — varchar(40)
- geom — public.geometry(multipolygon, 5179)
spatial_ref_sys
- srid — varchar(15) — 기본 키 — NOT NULL
- auth_name — varchar(256)
- auth_srid — int4
- srtext — varchar(2048)
- proj4text — varchar(2048)
tbl_alarm_base
- sensor_cd — varchar(15) — 외래 키 → sensor_mast.sensor_cd — NOT NULL
- use_yn — bpchar(2) — NOT NULL
- safety — float8
- warning — float8
- caution — float8
- danger — float8
- sensor_gbcd — bpchar(6)
- warning2 — float8
- danger2 — float8
- warning3 — float8
- danger3 — float8
tbl_alarm_info
- sensor_cd — varchar(15) — 외래 키 → sensor_mast.sensor_cd — NOT NULL
- river_nm — varchar(50)
- ref_level1 — float8
- ref_level2 — float8
- ref_level3 — float8
- ref_level4 — float8
- reg_dt — timestamp
- update_dt — timestamp
tbl_cctv_info
- cctv_cd — varchar(15) — 기본 키 — NOT NULL
- server_name — varchar(50) — NOT NULL
- address — varchar(100)
- on_offline — bool
- ntv_uid — varchar(12)
- purpose — varchar(12)
- type1 — varchar(12)
- type2 — varchar(12)
- lat — varchar(20)
- lon — varchar(20)
- ico_url — varchar(150)
- reg_dt — timestamp
- update_dt — timestamp
- gbcd — varchar(8)
- use_yn — varchar(1)
tbl_data_flvl
- ymdhm — varchar(15) — 기본 키 — NOT NULL
- sensor_cd — varchar(15) — 외래 키 → sensor_mast.sensor_cd — NOT NULL
- flvl — float8
- seq — int8
- reg_dt — timestamp
- se_code — varchar
tbl_data_flvl_icity
- ymdhm — varchar(15) — 기본 키 — NOT NULL
- sensor_cd — varchar(15) — 외래 키 → sensor_mast.sensor_cd — NOT NULL
- flvl — float8
- line — varchar(30)
- alarm_lvl — int4
- batt_pt — int4
- signal_pw — int4
- reg_dt — timestamp
tbl_data_flvl_icity_last
- sensor_cd — varchar(15) — 외래 키 → sensor_mast.sensor_cd — NOT NULL
- ymdhm — varchar(12) — NOT NULL
- flvl — float8
- line — varchar(30)
- alarm_lvl — int4
- batt_pt — int4
- signal_pw — int4
- reg_dt — timestamp
tbl_data_flvl_last
- ymdhm — varchar(15) — 기본 키 — NOT NULL
- sensor_cd — varchar(15) — 외래 키 → sensor_mast.sensor_cd — NOT NULL
- flvl — float8
- seq — int8
- reg_dt — timestamp
tbl_data_rain
- ymdhm — varchar(15) — 기본 키 — NOT NULL
- sensor_cd — varchar(15) — 외래 키 → sensor_mast.sensor_cd — NOT NULL
- rain_val — float8
- seq — int4 — NOT NULL
- reg_dt — timestamp
- update_dt — timestamp
- se_code — varchar
- mi_code — varchar
tbl_data_rain_1h
- ymd — varchar(15) — 기본 키 — NOT NULL
- sensor_cd — varchar(15) — 외래 키 → sensor_mast.sensor_cd — NOT NULL
- h01 — float8
- h02 — float8
- h03 — float8
- h04 — float8
- h05 — float8
- h06 — float8
- h07 — float8
- h08 — float8
- h09 — float8
- h10 — float8
- h11 — float8
- h12 — float8
- h13 — float8
- h14 — float8
- h15 — float8
- h16 — float8
- h17 — float8
- h18 — float8
- h19 — float8
- h20 — float8
- h21 — float8
- h22 — float8
- h23 — float8
- h24 — float8
- n_sum — float8
tbl_data_rain_1h_last
- ymd — varchar(15) — 기본 키 — NOT NULL
- sensor_cd — varchar(15) — 외래 키 → sensor_mast.sensor_cd — NOT NULL
- h01 — float8
- h02 — float8
- h03 — float8
- h04 — float8
- h05 — float8
- h06 — float8
- h07 — float8
- h08 — float8
- h09 — float8
- h10 — float8
- h11 — float8
- h12 — float8
- h13 — float8
- h14 — float8
- h15 — float8
- h16 — float8
- h17 — float8
- h18 — float8
- h19 — float8
- h20 — float8
- h21 — float8
- h22 — float8
- h23 — float8
- h24 — float8
- n_sum — float8
tbl_data_rain_area_info
- sensor_cd — varchar(15) — 외래 키 → sensor_mast.sensor_cd — NOT NULL
- area_code — varchar(12)
- nx — varchar(3)
- ny — varchar(3)
- reg_dt — timestamp
- update_dt — timestamp
- use_yn — varchar
tbl_data_rain_fcst
- sensor_cd — varchar(15) — 외래 키 → sensor_mast.sensor_cd — NOT NULL
- base_ymd — varchar(10)
- base_hm — varchar(8)
- fcst_ymd — varchar(10)
- h1_hm — varchar(5)
- h1_val — varchar(8)
- h2_hm — varchar(5)
- h2_val — varchar(8)
- h3_hm — varchar(5)
- h3_val — varchar(8)
- h4_hm — varchar(5)
- h4_val — varchar(8)
- h5_hm — varchar(5)
- h5_val — varchar(8)
- h6_hm — varchar(5)
- h6_val — varchar(8)
- reg_dt — timestamp
tbl_data_rain_grid_fcst_info
- base_ymd — varchar(15) — 기본 키 — NOT NULL
- base_hm — varchar(15) — 기본 키 — NOT NULL
- sensor_cd — varchar(15) — 외래 키 → sensor_mast.sensor_cd — NOT NULL
- fcst_ymd — varchar(10)
- h1_hm — varchar(5)
- h1_val — varchar(8)
- h2_hm — varchar(5)
- h2_val — varchar(8)
- h3_hm — varchar(5)
- h3_val — varchar(8)
- h4_hm — varchar(5)
- h4_val — varchar(8)
- h5_hm — varchar(5)
- h5_val — varchar(8)
- h6_hm — varchar(5)
- h6_val — varchar(8)
- reg_dt — timestamp
- nx — varchar(3)
- ny — varchar(3)
tbl_data_rain_grid_fcst_last
- sensor_cd — varchar(15) — 외래 키 → sensor_mast.sensor_cd — NOT NULL
- base_ymd — varchar(10)
- base_hm — varchar(8)
- fcst_ymd — varchar(10)
- h1_hm — varchar(5)
- h1_val — varchar(8)
- h2_hm — varchar(5)
- h2_val — varchar(8)
- h3_hm — varchar(5)
- h3_val — varchar(8)
- h4_hm — varchar(5)
- h4_val — varchar(8)
- h5_hm — varchar(5)
- h5_val — varchar(8)
- h6_hm — varchar(5)
- h6_val — varchar(8)
- reg_dt — timestamp
- nx — varchar(3)
- ny — varchar(3)
tbl_data_rain_m
- ymdh — varchar(15) — 기본 키 — NOT NULL
- sensor_cd — varchar(15) — 외래 키 → sensor_mast.sensor_cd — NOT NULL
- m01 — float8
- m02 — float8
- m03 — float8
- m04 — float8
- m05 — float8
- m06 — float8
tbl_data_rain_ms
- ymdhm — varchar(15) — 기본 키 — NOT NULL
- sensor_cd — varchar(15) — 외래 키 → sensor_mast.sensor_cd — NOT NULL
- accumulate15m — float8
- accumulate1h — float8
- reg_dt — timestamp
tbl_data_rain_ms_last
- ymdhm — varchar(15) — 기본 키 — NOT NULL
- sensor_cd — varchar(15) — 외래 키 → sensor_mast.sensor_cd — NOT NULL
- accumulate15m — float8
- accumulate1h — float8
- reg_dt — timestamp
tbl_data_tide
- ymdhm — varchar(15) — 기본 키 — NOT NULL
- sensor_cd — varchar(15) — 외래 키 → sensor_mast.sensor_cd — NOT NULL
- level — float8
- reg_dt — timestamp
tbl_data_tide_busan
- obs_cd — varchar(15) — 기본 키 — NOT NULL
- record_time — varchar(15) — 기본 키 — NOT NULL
- tide_level — float4 — NOT NULL
- reg_dt — timestamp — NOT NULL
tbl_data_tide_busan_fcst
- obs_cd — varchar(15) — 기본 키 — NOT NULL
- record_time — varchar(15) — 기본 키 — NOT NULL
- fcst_tide_level — float4 — NOT NULL
- reg_dt — timestamp — NOT NULL
tbl_data_tide_busan_fcst_lowhigh_point
- ymd — varchar(15) — 기본 키 — NOT NULL
- point1_val — float8
- point1_dt — timestamp
- point2_val — float8
- point2_dt — timestamp
- point3_val — float8
- point3_dt — timestamp
- point4_val — float8
- point4_dt — timestamp
- reg_dt — timestamp — NOT NULL
tbl_data_tide_chart
- ymd — varchar(10)
- tide1_data — text
- tide2_data — text
- tide3_data — text
- tide1_yesterday_data — text
- tide2_yesterday_data — text
- tide3_yesterday_data — text
- tide_timeline — text
- update_dt — timestamp
tbl_data_tide_last
- sensor_cd — varchar(15) — 외래 키 → sensor_mast.sensor_cd — NOT NULL
- ymdhm — varchar(14)
- level — float8
- seq — int8
- reg_dt — timestamp
- update_dt — timestamp
tbl_data_wind
- ymdhm — varchar(15) — 기본 키 — NOT NULL
- sensor_cd — varchar(15) — 외래 키 → sensor_mast.sensor_cd — NOT NULL
- wind_speed_1m — float8
- wind_speed_1m_unit — varchar(10)
- wind_direction_1m — float8
- wind_direction_1m_unit — varchar(5)
- warn_status — varchar(10)
- sensor_status — varchar(2)
- temp — float8
- humi — float8
- finedust — int4
- ufinedust — int4
- wind_speed_10m — float8
- wind_speed_10m_unit — varchar(10)
- wind_direction_10m — float8
- wind_direction_10m_unit — varchar(5)
- wind_speed_gust — float8
- wind_speed_gust_unit — varchar(10)
- wind_direction_gust — float8
- wind_direction_gust_unit — varchar(5)
- reg_dt — time
tbl_data_wind_last
- sensor_cd — varchar(15) — 외래 키 → sensor_mast.sensor_cd — NOT NULL
- wind_speed_1m — float8
- wind_speed_1m_unit — varchar(10)
- wind_direction_1m — float8
- wind_direction_unit_1m_unit — varchar(5)
- warn_status — varchar(10)
- sensor_status — varchar(2)
- temp — float8
- humi — float8
- finedust — int4
- ufinedust — int4
- wind_speed_10m — float8
- wind_speed_10m_unit — varchar(10)
- wind_direction_10m — float8
- wind_direction_10m_unit — varchar(5)
- wind_speed_gust — float8
- wind_speed_gust_unit — varchar(10)
- wind_direction_gust — float8
- wind_direction_gust_unit — varchar(5)
- ymdhm — varchar(30)
- reg_dt — timestamp
tbl_data_wind_moment
- sensor_cd — varchar(15) — 외래 키 → sensor_mast.sensor_cd — NOT NULL
- wind_speed — float8
- wind_speed_unit — varchar(10)
- wind_direction — float8
- wind_direction_unit — varchar(5)
- warn_status — varchar(10)
- sensor_status — varchar(2)
- ymdhm — varchar(30)
- reg_dt — timestamp
tbl_data_wlvl
- ymdhm — varchar(15) — 기본 키 — NOT NULL
- sensor_cd — varchar(15) — 외래 키 → sensor_mast.sensor_cd — NOT NULL
- wlvl — float8
- reg_dt — timestamp
- se_code — varchar
tbl_data_wlvl_last
- sensor_cd — varchar(15) — 외래 키 → sensor_mast.sensor_cd — NOT NULL
- wlvl — float8
- ymdhm — varchar(12)
- reg_dt — timestamp
tbl_disaster_area_detl_area_info
- object_cd — varchar(15) — 기본 키 — NOT NULL
- area_name — varchar(60)
- occur_date — varchar(50)
- occur_location — varchar(120)
- sign_instl — varchar(20)
- instl_date — varchar(50)
- danger_factors — varchar(250)
- past_damage_cont — varchar(250)
- past_damage_cause — varchar(200)
- evacu_people — varchar(10)
- evacu_area — varchar(100)
- ctrl_method — varchar(100)
- promotion_method — varchar(100)
- ctrl_evacu — varchar(300)
- reg_dt — timestamp
- update_dt — timestamp
tbl_disaster_area_detl_road_info
- object_cd — varchar(15) — 기본 키 — NOT NULL
- sido — varchar(10)
- gu — varchar(10)
- manage_dep — varchar(20)
- road_name — varchar(30)
- road_type — varchar(20)
- flood_area_name — varchar(100)
- ctrl_observ_pt — varchar(100)
- ctrl_danger_lvl — varchar(100)
- tel_no — varchar(80)
- reg_dt — timestamp
- update_dt — timestamp
- tel_name — varchar(50)
tbl_disaster_area_detl_struct_info
- object_cd — varchar(15) — 기본 키 — NOT NULL
- area_name — varchar(20)
- mng_num — varchar(20)
- mng_org — varchar(15)
- occur_location — varchar(120)
- mng_own_type — varchar(20)
- disaster_grade — varchar(20)
- unspec_cause — varchar(150)
- spec_notice — varchar(15)
- release_date — varchar(15)
- release_cause — varchar(150)
- struct_size — varchar(40)
- compl_date — varchar(15)
- struct_type — varchar(30)
- struct_use — varchar(30)
- build_struct — varchar(30)
- adj_facility — varchar(30)
- danger_factors — varchar(150)
- struct_ma — varchar(50)
- esti_cost — varchar(50)
- struct_mnger — varchar(150)
- reg_dt — timestamp
- update_dt — timestamp
tbl_disaster_area_info_mast
- object_cd — varchar(15) — 기본 키 — NOT NULL
- object_name — varchar(50)
- lat — varchar(20)
- lon — varchar(20)
- ico_url — varchar(150)
- gbcd — varchar(4)
- reg_dt — timestamp
- update_dt — timestamp
- modal_type — char
tbl_flood_trace_info
- object_cd — varchar(15) — 기본 키 — NOT NULL
- gu — varchar(10)
- disaster_name — varchar(120)
- type_name — varchar(50)
- period — varchar(25)
- start_time — varchar(10)
- highest_point_time — varchar(10)
- end_time — varchar(10)
- inundation_depth — varchar(50)
- area_size — varchar(20)
- zone_type — varchar(20)
- aerial_pic_url — varchar(150)
- field_pic_url — varchar(150)
- reg_dt — timestamp
- update_dt — timestamp
- object_name — varchar(200)
- lat — varchar(20)
- lon — varchar(20)
- ico_url — varchar(150)
- gbcd — varchar(4)
tbl_incident_traffic_info
- incident_id — varchar(15) — 기본 키 — NOT NULL
- incident_type_cd — varchar
- incident_sub_type_cd — varchar
- incident_sub_type_name — varchar
- address_jibun — varchar
- address_jibun_cd — varchar
- address_new — varchar
- locationdata_x — float4
- locationdata_y — float4
- incident_traffic_cd — varchar
- incident_grade_cd — varchar
- incident_title — varchar
- ymdhm — varchar
- lane — varchar
- roadname — varchar
- controltype — varchar
- important — varchar
- reg_dt — timestamp
tbl_info_rain_grid
- sensor_cd — varchar(15) — 외래 키 → sensor_mast.sensor_cd — NOT NULL
- nx — varchar(3)
- ny — varchar(3)
- reg_dt — timestamp
- update_dt — timestamp
- use_yn — varchar
tbl_menu_bom
- seq — int4 — NOT NULL
- menu_id — varchar(10) — NOT NULL
- parent_id — varchar(10)
- menu_name — varchar(40) — NOT NULL
- marker_checked — bool
- sel_box_onoff — bool
- gbcd — varchar(10) — NOT NULL
tbl_rain_sensor_sub_data
- sensor_cd — varchar(15) — NOT NULL
- sensor_ip — varchar(18)
- sensor_port — varchar(5)
- use_yn — varchar(1)
- bigo — varchar(15)
- reg_dt — timestamp
- update_dt — timestamp
tbl_shelter_info
- object_cd — varchar(15) — 기본 키 — NOT NULL
- shelter_addr — varchar(40)
- shelter_ph — varchar(20)
- reg_dt — timestamp
- update_dt — timestamp
- object_name — varchar(50)
- lat — varchar(20)
- lon — varchar(20)
- ico_url — varchar(150)
- etc1 — varchar(6)
- etc2 — varchar(50)
- gbcd — varchar(4)
vworld_key
- sn — varchar(15) — 기본 키 — NOT NULL
- url — varchar(200)
- api_key — varchar(100)