물리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