물리1
테이블 (20)
comtccmmndetailcode
- code_id — character — 기본 키 — NOT NULL
- detail_code — character — 기본 키 — NOT NULL
- code_dc — character — NOT NULL
- code_nm — character — NOT NULL
- frst_register_id — character
- frst_register_pnttm — timestamp
- last_updusr_id — character
- last_updusr_pnttm — timestamp
- sort_ordr — integer
- upper_code_id — character
- upper_detail_code — character
- use_yn — character(1) — NOT NULL
prctn_info_lcgvr_mangm_mtter_m
- lcgvr_mangm_mtter_id — character — 기본 키 — NOT NULL
- frst_rgstn_dtm — timestamp — NOT NULL
- frst_rgter_id — character — NOT NULL
- last_updt_dtm — timestamp — NOT NULL
- last_upusr_id — character — NOT NULL
- mangm_dt — timestamp
- mangm_iem_cd — character(2)
- rmrk — character
prctn_info_mangm_mtter_m
- prctn_info_id — character — 기본 키 — NOT NULL
- lcgvr_mangm_mtter_id — character
- mangm_step_cd — character(2)
- sttn_room_mangm_mtter_id — character
prctn_info_sttn_room_mangm_mtter_m
- sttn_room_mangm_mtter_id — character — 기본 키 — NOT NULL
- dntrm_pinch_clpst_cd — character(2)
- frst_rgstn_dtm — timestamp — NOT NULL
- frst_rgter_id — character — NOT NULL
- last_updt_dtm — timestamp — NOT NULL
- last_upusr_id — character — NOT NULL
- mangm_dt — timestamp
- mangm_pinch — character
- rmrk — character
tb_ldm_adzn_lndsl_dmg_stats_s
- lndsl_dmg_ara_tpcd — character — 기본 키 — NOT NULL
- lndsl_dmg_arcd — character — 기본 키 — NOT NULL
- lndsl_dmg_stats_no — character — 기본 키 — NOT NULL
- lndsl_dmg_qntt — double
tb_ldm_adzn_lndsl_risk_grad_stats_s
- lgdng_cd — character — 기본 키 — NOT NULL
- anlss_area — numeric
- ffgrd_area — numeric
- ffgrd_rate — numeric
- fogrd_area — numeric
- fogrd_rate — numeric
- frgrd_area — numeric
- frgrd_rate — numeric
- lgdng_nm — character — NOT NULL
- scgrd_area — numeric
- scgrd_rate — numeric
- thgrd_area — numeric
- thgrd_rate — numeric
tb_ldm_bbrss_i
- bbs_id — character(20) — 기본 키 — NOT NULL
- answer_at — character(1)
- answer_lc — integer
- atch_file_id — character(20)
- board_use_auth — character
- frst_regist_pnttm — timestamp — NOT NULL
- frst_register_id — character — NOT NULL
- last_updt_pnttm — timestamp
- last_updusr_id — character
- ntce_bgnde — character(20)
- ntce_endde — character(20)
- ntcr_id — character
- ntcr_nm — character
- ntt_cn — text
- ntt_id — numeric
- ntt_no — numeric
- ntt_sj — character
- parntsctt_no — bigint
- password — character
- rdcnt — bigint
- sort_ordr — integer
- use_at — character(1) — NOT NULL
tb_ldm_cbs_send_result_i
- cbs_sndng_ara_cont — character
- cbs_sndng_cont — character
- cbs_sndng_dtm — timestamp
- cbs_sndng_grcd — character
- cbs_sndng_seq — bigint
- frst_rgstn_dtm — timestamp
- frst_rgter_id — character
- last_updt_dtm — timestamp
- last_upusr_id — character
tb_ldm_chck_listb_dtl_info_d
- chck_list_id — character — 기본 키 — NOT NULL
- chck_list_iem_tpcd — character — 기본 키 — NOT NULL
- chck_list_iem_kind_cd — character
- chck_list_iem_seq — bigint
- chck_list_rmrk_cont — character
tb_ldm_chck_listb_iem_mngme_i
- chck_list_iem_tpcd — character — 기본 키 — NOT NULL
- chck_list_iem_nm — character
- chck_list_iem_seq — bigint
- chck_list_iem_use_yn — character(1)
tb_ldm_chck_listb_mngme_m
- chck_list_id — character — 기본 키 — NOT NULL
- frst_rgdt — character(8)
- last_upddt — character(8)
- lndsl_frcst_cd — character
- rain_event_mngme_id — character
- rgter_id — character
- upusr_id — character
tb_ldm_dmo_landslide
- cmmi_agen_code — character(2) — NOT NULL
- cmmi_create_date — timestamp
- cmmi_create_id — character
- cmmi_modify_date — timestamp
- cmmi_modify_id — character
- dmol_addr — character
- dmol_cent_duty — character
- dmol_cent_name — character
- dmol_conf_duty — character
- dmol_conf_name — character
- dmol_idx — bigint
- dmol_loss_cost — integer
- dmol_max_rain — numeric — NOT NULL
- dmol_occure_date — timestamp
- dmol_occure_time — character(2)
- dmol_precipitation — double — NOT NULL
- dmol_rain_edate — timestamp
- dmol_rain_etime — character(2)
- dmol_rain_sdate — timestamp
- dmol_rain_stime — character(2)
- dmol_rec_cost — bigint
- dmol_rec_effects — character
- dmol_rec_plan_etc — character
- dmol_sido_duty — character
- dmol_sido_name — character
- dmol_source — character
- dmol_writer — character
- dmol_writer_duty — character
- gedt_id — bigint
tb_ldm_ecndm_cnsttb_stats_i
- ecndm_cnstt_ara_drar_area — double
- ecndm_cnstt_form_cd — character
- ecndm_cnstt_prps_cd — character
- ecndm_ecbrg_fg — character(1)
- ecndm_lwprt_brdth — double
- ecndm_pndg_cnt — double
- ecndm_rgstr_id — character — NOT NULL
- ecndm_sdpst_qntt — double
- ecndm_sfty_fence_fg — character(1)
- ecndm_slcwy_thckn — double
- ecndm_stsgn_instl_fg — character(1)
- ecndm_tot_hght — double
- ecndm_upend_brdth — double
- ecndm_vldty_hght — double
- pntrt_typ_ecndm_kind_cd — character
- record_seq — integer
tb_ldm_ecndm_rgstr_mngme_m
- ecndm_rgstr_id — character — 기본 키 — NOT NULL
- bsnss_cntrc_mthod_cd — character
- cmplo_examr_clpst_nm1 — character
- cmplo_examr_clpst_nm2 — character
- cmplo_examr_nm1 — character
- cmplo_examr_nm2 — character
- drng_attch_file_id — character
- ecndm_arcd — character
- ecndm_bdgt_tpcd — character
- ecndm_bsnss_bdgt_yr — character(4)
- ecndm_bsnss_cmple_yr — character(4)
- ecndm_bsnss_qntt — bigint
- ecndm_bsnss_tpcd — character
- ecndm_cnsto_nm — character
- ecndm_cnsto_pstn_nm — character
- ecndm_cnsto_tlno — character
- ecndm_cnwrk_bgdt — character(8)
- ecndm_cnwrk_eddt — character(8)
- ecndm_dsgnr_nm — character
- ecndm_dsgnr_pstn_nm — character
- ecndm_dsgnr_tlno — character
- ecndm_flmnd_bgdt — character(8)
- ecndm_flmnd_eddt — character(8)
- ecndm_inspt_clpst_nm — character
- ecndm_inspt_nm — character
- ecndm_lctn_lngtd_val — character
- ecndm_lctn_lttd_val — character
- ecndm_mngme_cd — character
- ecndm_mngme_dtadd — character
- ecndm_mngme_no — character
- ecndm_mnnmb — character
- ecndm_ntn_spot_no — character
- ecndm_pcmtt_cont — character
- ecndm_pssss_tpcd — character
- ecndm_re_ins — character
- ecndm_sprvr_nm — character
- ecndm_sprvr_pstn_nm — character
- ecndm_sprvr_tlno — character
- ecndm_vnara_appdt — character(8)
- ecndm_vnara_appnt_ntfct_no — character
- ecndm_vnara_exmnn_dt — character(8)
- ecndm_vnara_rldt — character(8)
- ecndm_vnara_rls_ntfct_no — character
- ecndm_wrcst_lgvex_amt — numeric
- ecndm_wrcst_ntexp_amt — numeric
- frst_rgdt — character(8)
- last_upddt — character(8)
- lndsl_mnagn_cd — character
- phtgr_attch_file_id — character
- rgter_id — character
- upusr_id — character
- vnara_exmnn_id — character
- vnara_tpe_cd — character
tb_ldm_emerg_sttmn_l
- appnt_clast_yn — character
- conf_dtm — timestamp
- conf_yn — character
- copmsr_esb_seq — character
- copmsr_rcept_instt_code — character
- dlt_yn — character(1)
- dplct_dlt_yn — character(1)
- eltwr_yn — character(1)
- frst_cnfrr_id — character
- frst_rgstn_dtm — timestamp
- frst_rgter_id — character
- last_updt_dtm — timestamp
- last_upusr_id — character
- lclt_frsrv_instt_cd — character
- lgdng_cd — character
- lndsl_info_id — character — NOT NULL
- lndsl_occrr_pbmrl — double
- lndsl_occrr_stcd — character
- lndsl_occrr_tpcd — character
- lndsl_occrr_wndrc_cd — character
- lndsl_prgrs_stcd — character(2)
- lndsl_recpt_dtm — timestamp
- lndsl_rls_dtm — timestamp
- lndsl_sttmn_addr — character — NOT NULL
- lndsl_sttmn_dlt_rsn_cd — character(2)
- lndsl_sttmn_dt — character(8) — NOT NULL
- lndsl_sttmn_hms — character(6)
- lndsl_sttmn_lctn_xcrd — character
- lndsl_sttmn_lctn_ycrd — character
- lndsl_sttmn_prgrs_cd — character
- lndsl_sttmn_prgrs_dtm — timestamp
- lndsl_trmnl_id — character
- lndsl_updt_addr — character
- mangm_cmple_dtm — timestamp
- ndms_dat_input_dtm — timestamp
- nfa_rcipt_id — character
- ntfrt_mnoff_instt_cd — character
- ntfrt_yn — character(1)
- pnu_cd — character
- rcepter_lxtn_no — character
- record_seq — integer
- risk_tpcd — character
- scl_yn — character(1)
- spt_conf_dtm — timestamp
- stnda_xcrd — character
- stnda_ycrd — character
- sttmn_cont — character
- vnara_yn — character(1)
- wther_lttc_id — bigint
tb_ldm_emplr_athry_i
- emplr_athry_cd — character — 기본 키 — NOT NULL
- emplr_athry_nm1 — character
- emplr_athry_nm2 — character
- frst_rgdt — character(8)
- last_upddt — character(8)
- rgter_id — character
- upusr_id — character
tb_ldm_emplr_membr_i
- usid — character — 기본 키 — NOT NULL
- emplr_info_prus_agree_yn — character(1)
- emplr_membr_clpst_nm — character
- emplr_membr_emadd — character
- emplr_membr_nm — character
- emplr_membr_seq — bigint
- emplr_membr_tlno — character
- ininf_pinch_yn — character(1)
- lndsl_frcst_issu_mms_rcptn_yn — character(1)
- lndsl_prctn_mms_rcptn_yn — character(1)
- lndsl_rltm_mms_rcptn_yn — character(1)
- lndsl_sms_mms_rcptn_yn — character
- mms_sndng_hstr_id — character
- prctn_info_montr_yn — character(1)
- prprn_spcl_rprt_mms_rcptn_yn — character(1)
- spcl_rprt_mms_rcptn_yn — character(1)
tb_ldm_emplr_mngme_ara_i
- usid — character — 기본 키 — NOT NULL
- emplr_mngme_ara_seq — bigint
- emplr_mngme_arcd — character
tb_ldm_gps_sttmn_l
- lndsl_info_id — character — 기본 키 — NOT NULL
- conf_dtm — timestamp
- conf_yn — character
- ffrwt_trmnl_id — character
- frst_cnfrr_id — character
- frst_rgstn_dtm — timestamp
- frst_rgter_id — character
- gps_sttmn_tx_id — character
- last_updt_dtm — timestamp
- last_upusr_id — character
- lclt_frsrv_instt_cd — character
- lgdng_cd — character
- lndsl_occrr_tpcd — character
- lndsl_prgrs_stcd — character(2)
- lndsl_recpt_dtm — timestamp
- lndsl_rls_dtm — timestamp
- lndsl_sttmn_addr — character
- lndsl_sttmn_dlt_rsn_cd — character(2)
- lndsl_sttmn_dt — character(8)
- lndsl_sttmn_hms — character(6)
- lndsl_sttmn_lctn_xcrd — character
- lndsl_sttmn_lctn_ycrd — character
- mangm_cmple_dtm — timestamp
- ndms_dat_input_dtm — timestamp
- ntfrt_mnoff_instt_cd — character
- pnu_cd — character
- spt_conf_dtm — timestamp
- stnda_xcrd — character
- stnda_ycrd — character
- wther_lttc_id — bigint
tb_ldm_lancre_exm_flnt_m
- lancre_lndsl_mngme_id — character — 기본 키 — NOT NULL
- bkmnt_frtp_cd — character
- cllps_ara_crcmr_road_dstnc — bigint
- cllps_ara_crcmr_road_fg — character(1)
- cllps_ara_lwprt_house_dstnc — bigint
- frst_rgdt — character(8)
- lancre_arcd — character
- lancre_bsnss_fg — character(1)
- lancre_bsrok_insd_grdnt — numeric
- lancre_bsrok_insd_strike_cd — character
- lancre_clln_fom_cd — character
- lancre_clln_lctn_cd — character
- lancre_crck_lctn_cd — character
- lancre_crck_tot_lngth — double
- lancre_dmge_tpe_cd — character
- lancre_dtadd — character
- lancre_flnt_exmne_nm — character
- lancre_flnt_exmnn_dt — character(8)
- lancre_frst_occrr_area — double
- lancre_frst_ocdt — character(8)
- lancre_lctn_lngtd_val — character
- lancre_lctn_lttd_val — character
- lancre_occrr_caus_cd — character
- lancre_occrr_caus_phsph_cont — character
- lancre_orbrn_cd — character
- lancre_prtct_trgt_cd — character
- lancre_rcmmn_mtcns_cont — character
- lancre_rcnt_occrr_area — double
- lancre_rcnt_ocdt — character(8)
- lancre_sochar_dscrt — character
- lancre_unwtr_resur_fg — character(1)
- lancre_unwtr_resur_plac_cnt — integer
- lancre_upend_crck_cnt — smallint
- lancre_upend_crck_vrtcl_lngth — double
- lancre_upend_crck_width_lngth — double
- lancre_wash_ara_grdnt — numeric
- last_upddt — character(8)
- left_righ_crck_cnt — smallint
- left_righ_crck_vrtcl_lngth — double
- left_righ_crck_width_lngth — double
- prdn_stats_prrck_cd — character
- prdn_stats_prrck_dscrt — character
- rgter_id — character
- risk_clln_grdnt — numeric
- risk_clln_lngth — numeric
- rprsn_koftr_cd — character
- upusr_id — character