LDH
Tables (51)
adbk_inf
- adbk_id — d_id — Primary key — NOT NULL
- adbk_name — d_name — NOT NULL
- adbk_cell_number — varchar(11) — NOT NULL
- description — d_contents
- use_yn — d_YN — NOT NULL
- reg_at — d_at — NOT NULL
- reg_user — varchar(20) — NOT NULL
- mod_at — d_at
- mod_user — varchar(50)
ajsm_010_flat
- serial — d_seq
- event — varchar(50)
- rain — varchar(10)
- wind — varchar(20)
- windspeed — varchar(50)
- tempo — varchar(50)
- huminity — varchar(50)
- waterlevel — boolean
- surface_w_salinity — varchar(50)
- intermediate_w_salinity — varchar(50)
- deep_w_salinity — varchar(50)
- water_tempo — varchar(50)
- conductivity — varchar(50)
- bat_volt — varchar(50)
- sender — varchar(50)
- index — integer
- sysdate — d_sysdate
- huminity_calc — varchar(50)
- conductivity_conv — varchar(50)
- cre_at — d_at
ajsm_010_json
- serial — d_seq — Primary key — NOT NULL
- date_time — d_time
- cmd — varchar(6)
- alarm — varchar(50)
- w_temp — varchar(50)
- surface_w_salinity — varchar(50)
- surface_w_salinity — varchar(50)
- intermediate_w_salinity — varchar(50)
- deep_w_salinity — varchar(50)
- conductivity — varchar(50)
- conductivity_conv — varchar(50)
- bat_volt — varchar(50)
- modem_sig — varchar(50)
- cre_at — d_at — NOT NULL
ajsm_010_sms
- serial — d_seq — Primary key — NOT NULL
- recv_content — text
- sender — varchar(50)
- cre_at — d_at — NOT NULL
alarm_management
- alarm_id — d_id — Primary key — NOT NULL
- memory_addr — varchar(10)
- alarm_name — d_longname — NOT NULL
- memory_value — double — NOT NULL
- threshold_value — double
- reg_dt — d_dt — NOT NULL
- is_received — boolean
- is_received_time — timestamp
alarm_message
- alarm_id — d_id — Primary key — NOT NULL
- salinity — boolean
- waterlevel — boolean
- inner_gate — boolean
- outer_gate — boolean
- sea_level — boolean
- use_yn — d_YN
- device_group_description — d_contents
- level — varchar(20)
- msg — varchar(500)
- reserved0 — boolean
- reserved1 — boolean
- reg_at — d_at — NOT NULL
- reg_user — varchar(20) — NOT NULL
- mod_at — d_at
- mod_user — varchar(50)
auth_grp
- 권한그룹ID (auth_grp_id) — integer — Primary key — NOT NULL
- 권한그룹명 (auth_grp_nm) — character
auth_mst
- 메뉴ID (menu_id) — character — Foreign key → menu_inf.메뉴ID — NOT NULL
- 권한그룹ID (auth_grp_id) — integer — Foreign key → auth_grp.권한그룹ID — NOT NULL
broadcast_log
- serial — d_seq — Primary key — NOT NULL
- device_id — d_id — NOT NULL
- tts_id — d_id — NOT NULL
- brd_type — varchar(20) — NOT NULL
- brd_exec_result_status — varchar(20) — NOT NULL
- error_msg — text
- brd_start_at — d_at
- brd_end_at — d_at
common_code
- group_code — d_generalcode — Primary key — NOT NULL
- common_code — d_commcode — Primary key — NOT NULL
- common_code_name — d_name
- common_code_description — d_contents
- use_yn — d_YN
- common_ref1 — varchar(50)
- common_ref2 — varchar(50)
- common_ref3 — varchar(50)
- common_ref4 — varchar(50)
- common_ref5 — varchar(50)
- common_ref6 — varchar(50)
- common_ref7 — varchar(50)
- common_ref8 — varchar(50)
- reg_at — d_at — NOT NULL
- reg_user — varchar(20) — NOT NULL
- mod_at — d_at
- mod_user — varchar(50)
common_group
- group_code — d_generalcode — NOT NULL
- group_code_name — d_name
- group_code_description — d_contents
- use_yn — d_YN
- reg_at — d_at — NOT NULL
- reg_user — varchar(20) — NOT NULL
- mod_at — d_at
- mod_user — varchar(50)
data_cut
- data_cut_id — d_id — Primary key — NOT NULL
- data_cut_method — varchar(50) — NOT NULL
- use_yn — d_YN
- sender — varchar(50)
- target_schema — varchar(50)
- target_table — varchar(50)
- reg_at — d_at — NOT NULL
- reg_user — varchar(20) — NOT NULL
- mod_at — d_at
- mod_user — varchar(50)
data_layout
- layout_id — d_id — Primary key — NOT NULL
- sensor_code — varchar(50)
- data_cut_id — d_id
- layout_eng — d_name
- layout_kor — d_name
- column_name — varchar(50)
- datatype — varchar(20)
- datalength — integer
- column_order — d_index
- table_name — d_name
- unit — varchar(8)
- calc — varchar(200)
- threshold — double
- event_code_yn — d_YN
- orderby — d_index
- timestamp_yn — boolean
- threshold_count — integer
- threshold2 — double
- threshold3 — double
- graph_range — bigint
- auto_brd_yn — d_YN
- use_yn — d_YN
- cre_at — timestamp
- ref_column — varchar(50)
- latitude — double
- longitude — double
dept_info
- 부서ID (dept_id) — d_id — Primary key — NOT NULL
- 부서명 (dept_name) — d_name — NOT NULL
- 상위부서ID (parent_dept_id) — d_id
- 부서식별자 (dept_identifier) — d_basecode
- 부서레벨 (dept_level) — integer
device_group
- device_group_id — d_id — Primary key — NOT NULL
- device_group_name — d_longname — NOT NULL
- device_group_description — d_contents
- use_yn — d_YN
- latitude — double
- longitude — double
- map_level — integer
- reg_at — d_at — NOT NULL
- reg_user — varchar(20) — NOT NULL
- mod_at — timestamp
- mod_user — varchar(50)
device_group_mapping
- serial — d_seq — Primary key — NOT NULL
- device_group_id — d_id — NOT NULL
- device_id — d_id — NOT NULL
- reg_at — d_at — NOT NULL
- reg_user — varchar(20) — NOT NULL
- mod_at — d_at
- mod_user — varchar(50)
device_rtusensor_mapping
- serial — d_seq — Primary key — NOT NULL
- device_id — bigint — NOT NULL
- sensor_id — bigint — NOT NULL
- mapping_name — varchar(200)
- reg_at — timestamp — NOT NULL
- reg_user — varchar(20) — NOT NULL
- mod_at — timestamp
- mod_user — varchar(50)
equip_camera_position
- camera_position_id — d_id — Primary key — NOT NULL
- rtu_id — d_id — NOT NULL
- position_name — d_name — NOT NULL
- pan — numeric — NOT NULL
- tilt — numeric — NOT NULL
- zoom — numeric — NOT NULL
- use_yn — d_YN — NOT NULL
- cre_at — timestamp — NOT NULL
- updated_at — timestamp
event_code_mapping
- event_code — d_classcode — Primary key — NOT NULL
- event_name — text — NOT NULL
ingest_event
- serial — d_seq — Primary key — NOT NULL
- data — jsonb — NOT NULL
- event_delimiter — varchar(80) — NOT NULL
- extra — jsonb
- occurred_at — timestamp — NOT NULL
- recv_at — d_at — NOT NULL
- schema_version — varchar(20)
- source — varchar(120) — NOT NULL
- brd_exec_result_status — varchar(20) — NOT NULL
- trace_id — d_id
insight_satlit
- serial — d_seq — NOT NULL
- region_code — d_basecode
- img_path — text
location_inf
- region_code — d_basecode
- level1 — varchar(50)
- level2 — varchar(50)
- level3 — varchar(50)
- grid_x — varchar(20)
- grid_y — varchar(20)
- longitude_degree — varchar(20)
- longitude_min — varchar(20)
- longitude_second — varchar(20)
- latitude_degree — varchar(20)
- latitude_min — varchar(20)
- latitude_second — varchar(20)
- longitude_decimal — varchar(20)
- latitude_decimal — varchar(20)
- position_update — varchar(8)
- use_yn — d_YN
login_log
- serial — d_seq — Primary key — NOT NULL
- user_id — d_id — NOT NULL
- ip_addr — varchar(50) — NOT NULL
- browser_info — varchar(255) — NOT NULL
- login_time — varchar(14)
- login_result — varchar(10) — NOT NULL
- fail_reason — varchar(255)
member
- 사용자ID (user_id) — d_id — Primary key — NOT NULL
- 사용자코드 (user_code) — d_generalcode
- 사영자명 (user_name) — d_name
- 비밀번호 (user_pwd) — varchar(128)
- 부서명 (dept_name) — d_name
- 부서식별자 (dept_identifier) — d_basecode — NOT NULL
- 부서ID (dept_id2) — d_id — Foreign key → dept_info.부서ID — NOT NULL
menu_inf
- 메뉴ID (menu_id) — character — Primary key — NOT NULL
- 상위메뉴ID (parent_id) — character
- 메뉴이름 (menu_nm) — character
modem_device
- device_id — d_id — Primary key — NOT NULL
- device_name — varchar(100) — NOT NULL
- phone — d_telephone — NOT NULL
- latitude — double — NOT NULL
- longitude — double — NOT NULL
- use_yn — d_YN
- map_level — integer
- door_min — double
- door_max — double
- reg_at — d_at — NOT NULL
- reg_user — varchar(20) — NOT NULL
- mod_at — timestamp
- mod_user — varchar(50)
modem_status
- id — d_id — Primary key — NOT NULL
- modem_name — d_name — NOT NULL
- is_locked — boolean — NOT NULL
- updated_at — timestamp
- is_locked_at — timestamp
mqtt_inbox
- serial — d_seq — Primary key — NOT NULL
- topic — varchar(256) — NOT NULL
- QOS — integer — NOT NULL
- retained — boolean — NOT NULL
- payload — text — NOT NULL
- recv_at — d_at — NOT NULL
plc_data
- serial — bigint
- md71 — real
- md76 — real
- mw40_bit_0 — boolean
- md105 — real
- md120 — real
- mw40_bit_1 — boolean
- mw41_bit_0 — boolean
- mw40_bit_2 — boolean
- mw43_bit_1 — boolean
- mw45_bit_1 — boolean
- mw41_bit_1 — boolean
- mw43_bit_3 — boolean
- mw45_bit_3 — boolean
- mw41_bit_2 — boolean
- mw43_bit_4 — boolean
- mw45_bit_4 — boolean
- mw41_bit_3 — boolean
- mw41_bit_4 — boolean
- mw42_bit_0 — boolean
- mw42_bit_1 — boolean
- mw43_bit_0 — boolean
- mw43_bit_2 — boolean
- mw43_bit_5 — boolean
- mw43_bit_6 — boolean
- mw43_bit_7 — boolean
- mw44_bit_0 — boolean
- mw44_bit_1 — boolean
- mw45_bit_0 — boolean
- mw45_bit_2 — boolean
- mw45_bit_5 — boolean
- mw45_bit_7 — boolean
- mw4 — integer
- mw5 — integer
- mw262 — integer
- mw263 — integer
- md74 — real
- md104 — real
- mw55 — integer
- mw260 — integer
- mw261 — integer
- mw264 — integer
- mw266 — integer
- md68 — real
- md70 — real
- mw97 — integer
- mw56 — integer
- mw265 — integer
- md72 — real
- md73 — real
- md65 — real
- md66 — real
- md91 — real
- md100 — real
- md118 — real
- md119 — real
- md102 — real
- md103 — real
- md115 — real
- md116 — real
- … +9
plc_memory_data
- serial — d_seq — Primary key — NOT NULL
- memory_type — varchar(2) — NOT NULL
- memory_addr — varchar(10) — NOT NULL
- int_value — integer
- real_value — double
- reg_dt — d_dt
- bit_value — boolean
- mod_dt — d_dt
- percentage_value — double
- tmp_int_value — integer
- tmp_real_value — double
plc_memory_realtime
- serial — d_seq — Primary key — NOT NULL
- memory_type — varchar(2) — NOT NULL
- memory_addr — varchar(10) — NOT NULL
- int_value — integer
- real_value — double
- percentage_value — double
- updated_at — timestamp
- bit_value — boolean
- percentage_value — double
- tmp_int_value — integer
- tmp_real_value — double
rcv_raw
- serial — d_seq — Primary key — NOT NULL
- basic_dt — varchar(8) — NOT NULL
- base_hms — varchar(6) — NOT NULL
- rtu_id — d_id — NOT NULL
- hdr_cnt — d_cnt
- body_cnt — d_cnt — NOT NULL
- description — d_contents
- use_yn — d_YN — NOT NULL
- reg_at — d_at — NOT NULL
- reg_user — varchar(20) — NOT NULL
- mod_at — d_at
- mod_user — varchar(50)
rdr_img_info
- serial — d_seq — NOT NULL
- region_code — d_basecode
- img_path — text
refresh_token
- user_id — d_id — Primary key — NOT NULL
- device_id — d_id — Primary key — NOT NULL
- refresh_token — text — NOT NULL
- issued_at — timestamp — NOT NULL
- expired_at — timestamp — NOT NULL
rtu_alarm_data
- serial — d_seq — Primary key — NOT NULL
- recv_at — d_at
- event_delimiter — varchar(80)
- event_code — d_classcode
- event_description — d_contents
- rainfall — varchar(20)
- winddirection — varchar(20)
- windspeed — varchar(50)
- temperature — varchar(20)
- huminity — varchar(50)
- waterlevel — boolean
- surface_watertemp — varchar(20)
- middle_watertemp — varchar(20)
- deep_watertemp — varchar(20)
- total_watertemp — varchar(20)
- conductivity — varchar(50)
- battery_volt — varchar(20)
- sender — varchar(50)
- msg_id — d_id
rtu_alm_tcp_data
- serial — d_seq — Primary key — NOT NULL
- tid — d_id — NOT NULL
- recv — date — NOT NULL
- recv_at — d_at — NOT NULL
- repeat_cnt — d_cnt
- cmd — varchar(6)
- alm_cd — d_basecode
- wtmp — numeric
- s_sal — numeric
- i_sal — numeric
- d_sal — numeric
- cond — numeric
- volt — numeric
- sig — integer
- reg_at — d_at
rtu_sensor
- sensor_id — d_id — Primary key — NOT NULL
- data_cut_id — d_id
- sensor_name — d_longname
- sensor_mnfct — varchar(50)
- sensor_model — varchar(50)
- dataformat — varchar(10)
- delimiter — varchar(3)
- last_delimiter_yn — d_YN
- site_name — d_name
- instl_position — varchar(20)
- report_section — varchar(20)
- use_yn — d_YN
- sensor_code — varchar(50)
- rtu_id — d_id
- data_layout — varchar(150)
- field_name — d_name
- tcp_sms_type — varchar(50)
- reg_at — d_at — NOT NULL
- reg_user — varchar(20) — NOT NULL
- mod_at — d_at
- mod_user — varchar(50)
rtu_sensor_dtl
- sensor_id — d_id — Primary key — NOT NULL
- sensor_dtl_id — d_id — Primary key — NOT NULL
- sensor_dtl_name — varchar(100)
- layout_id — d_id — NOT NULL
- use_yn — d_YN — NOT NULL
- data_yn — d_YN
- reg_at — d_at — NOT NULL
- reg_user — varchar(20) — NOT NULL
- mod_at — d_at
- mod_user — varchar(50)
scheduled_broadcast_execution
- id — d_id — Primary key — NOT NULL
- brd_name — d_longname — NOT NULL
- tts_id — d_id — NOT NULL
- device_ids — d_contents — NOT NULL
- repeat_type — varchar(10) — NOT NULL
- repeat_value — text
- start_time — d_time — NOT NULL
- start_date — d_date — NOT NULL
- end_date — d_date
- is_active_yn — d_YN — NOT NULL
- cre_at — d_at
sms_messages
- serial — d_seq — Primary key — NOT NULL
- msg_index — integer — NOT NULL
- sender — varchar(50) — NOT NULL
- recv_at — d_at — NOT NULL
- recv_content — text — NOT NULL
- processed — boolean
- pdu_flag — boolean
- is_process — integer
sms_parsed_data
- serial — d_seq — Primary key — NOT NULL
- sms_id — d_id
- site_name — d_name
- unit_no — integer
- metric — varchar(100)
- value — real
- unit — varchar(8)
- recv_at — d_at
- extra_text — varchar(200)
- cre_at — d_at — NOT NULL
sms_send_event
- serial — d_seq — Primary key — NOT NULL
- send_memory_number — varchar(500) — NOT NULL
- recv_memory_number — varchar(500)
- cstmr_id — d_id — NOT NULL
- send_memory_id — d_id
- recv_name — d_name
- recv_phone — varchar(500) — NOT NULL
- recv_success — varchar(20)
- send_dt — d_dt
- send_text — text — NOT NULL
- send_log — text — NOT NULL
- msg_id — d_id
tide_data
- serial — d_seq — Primary key — NOT NULL
- obs_code — d_generalcode — NOT NULL
- record_date — d_date — NOT NULL
- record_time — timestamp — NOT NULL
- tide_level — integer — NOT NULL
tide_data_ghdg
- serial — d_seq — Primary key — NOT NULL
- obs_code — d_generalcode
- record_date — d_date
- record_time — timestamp
- tide_level — integer
- cre_at — d_at
tide_data_ghwp
- serial — d_seq — Primary key — NOT NULL
- obs_code — d_generalcode
- record_date — d_date
- record_time — timestamp(0)
- tide_level — integer(0)
- cre_at — d_at
token
- id — d_id — NOT NULL
- access_token — text
- refresh_token — text
- expiration — timestamp
- reg_at — d_at — NOT NULL
- reg_user — varchar(20) — NOT NULL
- mod_at — timestamp
- mod_user — varchar(50)
tts_history
- serial — d_seq — Primary key — NOT NULL
- tts_content — varchar(500) — NOT NULL
- file_path — varchar(255) — NOT NULL
- use_yn — d_YN
- cre_at — timestamp
- tts_title — varchar(255)
- device_id — d_id
- repeat_count — integer
- start_sound_file — varchar(255)
- end_sound_file — varchar(255)
- brd_volume_value — integer
ultra_srt_fcst
- serial — d_seq — Primary key — NOT NULL
- region_code — d_basecode
- announce_date — varchar(8)
- announce_time — varchar(4)
- nx — varchar(3)
- ny — varchar(3)
- category — varchar(3)
- fcst_date — varchar(8)
- fcst_time — varchar(4)
- fcst_value — varchar(20)
vilage_fcst
- serial — d_seq — Primary key — NOT NULL
- region_code — d_basecode
- announce_date — varchar(8)
- announce_time — varchar(4)
- category — varchar(3)
- fcst_date — varchar(8)
- fcst_time — varchar(4)
- fcst_value — varchar(20)
- nx — varchar(3)
- ny — varchar(3)
weather_wrn_info
- serial — d_seq — NOT NULL
- region_code — d_basecode
- stn_id — d_id
- time_fc — varchar(12)
- time_seq — d_seq — NOT NULL
- war_fc — varchar(2)
- other — varchar(2000)
- t1 — varchar(500)
- t2 — varchar(2000)
- t3 — varchar(2000) — NOT NULL
- t4 — varchar(2000) — NOT NULL
- t5 — varchar(12) — NOT NULL
- t6 — varchar(4000) — NOT NULL
- t7 — varchar(400) — NOT NULL
web_file_info
- file_id — d_id — Primary key — NOT NULL
- task_typ — varchar(10) — NOT NULL
- task_id — d_id — NOT NULL
- file_path — varchar(255) — NOT NULL
- file_name — varchar(1000) — NOT NULL
- file_size — integer — NOT NULL
- file_extra — varchar(10) — NOT NULL
- mime_type — varchar(100) — NOT NULL
- file_name — varchar(1000) — NOT NULL
- file_checksum — varchar(64) — NOT NULL
- remark — varchar(300)
- body_atchd_yn — varchar(1) — NOT NULL
- use_yn — d_YN — NOT NULL
- del_yn — d_YN — NOT NULL
- reg_at — d_at — NOT NULL
- reg_user — varchar(20) — NOT NULL
- mod_at — d_at
- mod_user — varchar(50)