지열ERD
테이블 (26)
TB_BLDG
- BLDG_ID — varchar2(50) — NOT NULL
- BLDG_NM — varchar2(200)
- BLDG_MNGR_NM — varchar2(20)
- BLDG_MNGR_TELNO — varchar2(20)
- BLDG_ADDR — varchar2(500)
- BLDG_DTL_ADDR — varchar2(500)
- SGG — varchar2(100)
- DEPT_CD1 — varchar2(20)
- DEPT_CD2 — varchar2(20)
- DEPT_CD3 — varchar2(20)
- DEPT_CD4 — varchar2(20)
- DEPT_CD5 — varchar2(20)
- REG_ID — varchar2(255)
- REG_DT — timestamp — NOT NULL
- UPDT_ID — varchar2(255)
- UPDT_DT — timestamp
- DEL_ID — varchar2(255)
- DEL_DT — timestamp
- DEL_YN — char — NOT NULL
TB_BLDG_EQPMNT_MPNG
- BLDG_ID — varchar2(50) — 외래 키 → TB_BLDG.BLDG_ID
- EQPMNT_ID — number — 외래 키 → TB_EQPMNT.EQPMNT_ID
- REG_ID — varchar2(255)
- REG_DT — timestamp — NOT NULL
- UPDT_ID — varchar2(255)
- UPDT_DT — timestamp
- DEL_ID — varchar2(255)
- DEL_DT — timestamp
- DEL_YN — char — NOT NULL
TB_BLDG_HIST
- BLDG_HIST_ID — number — NOT NULL
- BLDG_ID — varchar2(50) — 외래 키 → TB_BLDG.BLDG_ID — NOT NULL
- BLDG_NM — varchar2(200)
- BLDG_MNGR_NM — varchar2(20)
- BLDG_MNGR_TELNO — varchar2(20)
- BLDG_ADDR — varchar2(500)
- BLDG_DTL_ADDR — varchar2(500)
- SGG — varchar2(100)
- DEPT_CD1 — varchar2(20)
- DEPT_CD2 — varchar2(20)
- DEPT_CD3 — varchar2(20)
- DEPT_CD4 — varchar2(20)
- DEPT_CD5 — varchar2(20)
- HIST_TY — varchar2(10) — NOT NULL
- REG_ID — varchar2(255)
- REG_DT — timestamp — NOT NULL
- UPDT_ID — varchar2(255)
- UPDT_DT — timestamp
- DEL_ID — varchar2(255)
- DEL_DT — timestamp
- DEL_YN — char — NOT NULL
TB_BLDG_MNGR
- BLDG_MNGR_ID — number — NOT NULL
- BLDG_ID — varchar2(50) — 외래 키 → TB_BLDG.BLDG_ID
- MNGR_NM — varchar2(200)
- MNGR_TELNO — varchar2(20)
- REG_ID — varchar2(255)
- REG_DT — timestamp — NOT NULL
- UPDT_ID — varchar2(255)
- UPDT_DT — timestamp
- DEL_ID — varchar2(255)
- DEL_DT — timestamp
- DEL_YN — char — NOT NULL
TB_CERT_EQPMNT
- CERT_EQPMNT_ID — number — NOT NULL
- EQPMNT_MKR_NM — varchar2(200)
- EQPMNT_MDL_NM — varchar2(200)
- EQPMNT_VOLM — number
- EQPMNT_MNGR_NM — varchar2(20)
- EQPMNT_MNGR_TELNO — varchar2(20)
- ENERGY_SRC_CD — varchar2(10)
- REG_ID — varchar2(255)
- REG_DT — timestamp — NOT NULL
- UPDT_ID — varchar2(255)
- UPDT_DT — timestamp
- DEL_ID — varchar2(255)
- DEL_DT — timestamp
- DEL_YN — char — NOT NULL
TB_CERT_RTU
- CERT_RTU_ID — number — NOT NULL
- RTU_MDL_NM — varchar2(50)
- RTU_MKR_NM — varchar2(50)
- REG_ID — varchar2(255)
- REG_DT — timestamp — NOT NULL
- UPDT_ID — varchar2(255)
- UPDT_DT — timestamp
- DEL_ID — varchar2(255)
- DEL_DT — timestamp
- DEL_YN — char — NOT NULL
TB_CYCL
- CYCL_ID — number — NOT NULL
- CYCL_YR — number
- CYCL_CNT — number
- BGNG_YMD — date
- END_YMD — date
- REG_ID — varchar2(255)
- REG_DT — timestamp — NOT NULL
- UPDT_ID — varchar2(255)
- UPDT_DT — timestamp
- DEL_ID — varchar2(255)
- DEL_DT — timestamp
- DEL_YN — char — NOT NULL
TB_DEPT
- DEPT_CD — varchar2(20) — 기본 키 — NOT NULL
- DEPT_NM — varchar2(200) — NOT NULL
- HGHRK_DEPT_CD — varchar2(20)
- UP_DEPT_CD — varchar2(20)
- DEPT_WHOL_NM — varchar2(200)
- DEPT_STP — number
- DEPT_ORDR — number
- ETC_INFO1 — varchar2(200)
- ETC_INFO2 — varchar2(200)
- ETC_INFO3 — varchar2(200)
- REG_ID — varchar2(255)
- REG_DT — timestamp — NOT NULL
- UPDT_ID — varchar2(255)
- UPDT_DT — timestamp
- DEL_ID — varchar2(255)
- DEL_DT — timestamp
- DEL_YN — char — NOT NULL
TB_EQPMNT
- EQPMNT_ID — number — NOT NULL
- CERT_EQPMNT_ID — number — 외래 키 → TB_CERT_EQPMNT.CERT_EQPMNT_ID
- CID — varchar2(50) — NOT NULL
- AUTH_KEY — varchar2(50) — NOT NULL
- EQPMNT_INSTL_DT — timestamp
- REG_ID — varchar2(255)
- REG_DT — timestamp — NOT NULL
- UPDT_ID — varchar2(255)
- UPDT_DT — timestamp
- DEL_ID — varchar2(255)
- DEL_DT — timestamp
- DEL_YN — char — NOT NULL
TB_EQPMNT_HIST
- EQPMNT_HIST_ID — number — NOT NULL
- EQPMNT_ID — number — 외래 키 → TB_EQPMNT.EQPMNT_ID
- CID — varchar2(50) — NOT NULL
- AUTH_KEY — varchar2(50) — NOT NULL
- EQPMNT_INSTL_DT — timestamp
- HIST_TY — varchar2(10) — NOT NULL
- REG_ID — varchar2(255)
- REG_DT — timestamp — NOT NULL
- UPDT_ID — varchar2(255)
- UPDT_DT — timestamp
- DEL_ID — varchar2(255)
- DEL_DT — timestamp
- DEL_YN — char — NOT NULL
TB_EQPMNT_RTU_MPNG
- EQPMNT_ID — number — 외래 키 → TB_EQPMNT.EQPMNT_ID
- RTU_ID — number — 외래 키 → TB_RTU.RTU_ID
- REG_ID — varchar2(255)
- REG_DT — timestamp — NOT NULL
- UPDT_ID — varchar2(255)
- UPDT_DT — timestamp
- DEL_ID — varchar2(255)
- DEL_DT — timestamp
- DEL_YN — char — NOT NULL
TB_GEOTHERMAL_DATA_AUTO_RAW
- GEOTHERMAL_DATA_AUTO_RAW_ID — number — NOT NULL
- CID — varchar2(11) — NOT NULL
- VLTGE — number
- ERCRT — number
- OPPT — number
- HP_HEAT_PRDCTN_QY — number
- HP_ACCMLT_PRDCTN_QY — number
- HP_ACCMLT_PWRER_USE_QY — number
- HP_STTS_VL — number
- HP_GEOTHERMAL_WTR_IN_TP — number
- HP_GEOTHERMAL_WTR_OUT_TP — number
- HP_CDYSM_IN_TP — number
- HP_CDYSM_OUT_TP — number
- HP_COLD_HOT_WTR_FLUX — number
- CDYSM_IN_TP — number
- CDYSM_OUT_TP — number
- CDYSM_USE_FLUX_VL — number
- CDYSM_ACCMLT_USE_HEAT_QY — number
- HOT_WTR_WSP_TP — number
- HOT_WTR_HOT_WTR_TP — number
- HOT_WTR_USE_FLUX_VL — number
- HOT_WTR_ACCMLT_USE_HEAT_QY — number
- DEFECT_YN — char
- CRTR_YMD — date
- RTU_RCPTN_DT — timestamp
- RTU_TRSM_DT — timestamp
- SRVR_RCPTN_DT — timestamp
- REG_ID — varchar2(255)
- REG_DT — timestamp — NOT NULL
- UPDT_ID — varchar2(255)
- UPDT_DT — timestamp
- DEL_ID — varchar2(255)
- DEL_DT — timestamp
- DEL_YN — char — NOT NULL
- CLSF_YN — char — NOT NULL
- CLSF_DT — timestamp
TB_GEOTHERMAL_DATA_MNL
- GEOTHERMAL_DATA_MNL_ID — number — NOT NULL
- EQPMNT_ID — number — 외래 키 → TB_EQPMNT.EQPMNT_ID
- CYCL_ID — number — 외래 키 → TB_CYCL.CYCL_ID
- CID — varchar2(50) — NOT NULL
- VLTGE — number
- ERCRT — number
- OPPT — number
- HP_HEAT_PRDCTN_QY — number
- HP_ACCMLT_PRDCTN_QY — number
- HP_ACCMLT_PWRER_USE_QY — number
- HP_STTS_VL — number
- HP_GEOTHERMAL_WTR_IN_TP — number
- HP_GEOTHERMAL_WTR_OUT_TP — number
- HP_CDYSM_IN_TP — number
- HP_CDYSM_OUT_TP — number
- HP_COLD_HOT_WTR_FLUX — number
- HP_DEFECT_YN — char
- CDYSM_IN_TP — number
- CDYSM_OUT_TP — number
- CDYSM_USE_FLUX_VL — number
- CDYSM_ACCMLT_USE_HEAT_QY — number
- HOT_WTR_WSP_TP — number
- HOT_WTR_HOT_WTR_TP — number
- HOT_WTR_USE_FLUX_VL — number
- HOT_WTR_ACCMLT_USE_HEAT_QY — number
- LOAD_DEFECT_YN — char
- ACCMLT_COP — number
- INST_COP — number
- REG_ID — varchar2(255)
- REG_DT — timestamp — NOT NULL
- UPDT_ID — varchar2(255)
- UPDT_DT — timestamp
- DEL_ID — varchar2(255)
- DEL_DT — timestamp
- DEL_YN — char — NOT NULL
TB_GEOTHERMAL_HP_DATA_AUTO
- GEOTHERMAL_HP_DATA_AUTO_ID — number — NOT NULL
- GEOTHERMAL_DATA_AUTO_RAW_ID — number — 외래 키 → TB_GEOTHERMAL_DATA_AUTO_RAW.GEOTHERMAL_DATA_AUTO_RAW_ID
- CID — varchar2(11) — NOT NULL
- HP_HEAT_PRDCTN_QY — number
- HP_ACCMLT_PRDCTN_QY — number
- HP_ACCMLT_PWRER_USE_QY — number
- HP_STTS_VL — number
- HP_GEOTHERMAL_WTR_IN_TP — number
- HP_GEOTHERMAL_WTR_OUT_TP — number
- HP_CDYSM_IN_TP — number
- HP_CDYSM_OUT_TP — number
- HP_COLD_HOT_WTR_FLUX — number
- DEFECT_YN — char
- CRTR_YMD — date
- RTU_RCPTN_DT — timestamp
- RTU_TRSM_DT — timestamp
- SRVR_RCPTN_DT — timestamp
- ACCMLT_COP — number
- INST_COP — number
- REG_ID — varchar2(255)
- REG_DT — timestamp — NOT NULL
- UPDT_ID — varchar2(255)
- UPDT_DT — timestamp
- DEL_ID — varchar2(255)
- DEL_DT — timestamp
- DEL_YN — char — NOT NULL
- TOT_YN — char — NOT NULL
- TOT_DT — date
TB_GEOTHERMAL_HP_DATA_ERR
- GEOTHERMAL_HP_DATA_ERR_ID — number — NOT NULL
- GEOTHERMAL_DATA_AUTO_RAW_ID — number — 외래 키 → TB_GEOTHERMAL_DATA_AUTO_RAW.GEOTHERMAL_DATA_AUTO_RAW_ID
- CID — varchar2(50) — NOT NULL
- VLTGE — number
- ERCRT — number
- OPPT — number
- HP_HEAT_PRDCTN_QY — number
- HP_ACCMLT_PRDCTN_QY — number
- HP_ACCMLT_PWRER_USE_QY — number
- HP_STTS_VL — number
- HP_GEOTHERMAL_WTR_IN_TP — number
- HP_GEOTHERMAL_WTR_OUT_TP — number
- HP_CDYSM_IN_TP — number
- HP_CDYSM_OUT_TP — number
- HP_COLD_HOT_WTR_FLUX — number
- DEFECT_YN — char
- CRTR_YMD — date
- REG_ID — varchar2(255)
- REG_DT — timestamp — NOT NULL
- UPDT_ID — varchar2(255)
- UPDT_DT — timestamp
- DEL_ID — varchar2(255)
- DEL_DT — timestamp
- DEL_YN — char — NOT NULL
- ERR_TY — varchar2(10)
- ERR_MSG — varchar2(500)
TB_GEOTHERMAL_LOAD_DATA_AUTO
- GEOTHERMAL_LOAD_DATA_AUTO_ID — number — NOT NULL
- GEOTHERMAL_DATA_AUTO_RAW_ID — number — 외래 키 → TB_GEOTHERMAL_DATA_AUTO_RAW.GEOTHERMAL_DATA_AUTO_RAW_ID
- CID — varchar2(11) — NOT NULL
- CDYSM_IN_TP — number
- CDYSM_OUT_TP — number
- CDYSM_USE_FLUX_VL — number
- CDYSM_ACCMLT_USE_HEAT_QY — number
- HOT_WTR_WSP_TP — number
- HOT_WTR_HOT_WTR_TP — number
- HOT_WTR_USE_FLUX_VL — number
- HOT_WTR_ACCMLT_USE_HEAT_QY — number
- DEFECT_YN — char
- CRTR_YMD — date
- RTU_RCPTN_DT — timestamp
- RTU_TRSM_DT — timestamp
- SRVR_RCPTN_DT — timestamp
- REG_ID — varchar2(255)
- REG_DT — timestamp — NOT NULL
- UPDT_ID — varchar2(255)
- UPDT_DT — timestamp
- DEL_ID — varchar2(255)
- DEL_DT — timestamp
- DEL_YN — char — NOT NULL
- TOT_YN — char — NOT NULL
- TOT_DT — date
TB_GEOTHERMAL_LOAD_DATA_ERR
- GEOTHERMAL_LOAD_DATA_ERR_ID — number — NOT NULL
- GEOTHERMAL_DATA_AUTO_RAW_ID — number — 외래 키 → TB_GEOTHERMAL_DATA_AUTO_RAW.GEOTHERMAL_DATA_AUTO_RAW_ID
- CID — varchar2(50) — NOT NULL
- CDYSM_IN_TP — number
- CDYSM_OUT_TP — number
- CDYSM_USE_FLUX_VL — number
- CDYSM_ACCMLT_USE_HEAT_QY — number
- HOT_WTR_WSP_TP — number
- HOT_WTR_HOT_WTR_TP — number
- HOT_WTR_USE_FLUX_VL — number
- HOT_WTR_ACCMLT_USE_HEAT_QY — number
- DEFECT_YN — char
- CRTR_YMD — date
- REG_ID — varchar2(255)
- REG_DT — timestamp — NOT NULL
- UPDT_ID — varchar2(255)
- UPDT_DT — timestamp
- DEL_ID — varchar2(255)
- DEL_DT — timestamp
- DEL_YN — char — NOT NULL
- ERR_TY — varchar2(10)
- ERR_MSG — varchar2(500)
TB_GEOTHERMAL_LOG
- LOG_ID — number — NOT NULL
- CID — varchar2(50)
- MULTI — number
- PAYLOAD_HEX — varchar2(500)
- STTS — varchar2(20)
- REG_ID — varchar2(255)
- REG_DT — timestamp — NOT NULL
TB_INST
- INST_ID — number — 기본 키 — NOT NULL
- INST_NM — varchar2(200)
- INST_CLSF — varchar2(100)
- INST_MNGR_NM — varchar2(20)
- INST_MNGR_TELNO — varchar2(20)
- INST_ADDR — varchar2(500)
- INST_DTL_ADDR — varchar2(500)
- DEPT_CD1 — varchar2(20)
- DEPT_CD2 — varchar2(20)
- DEPT_CD3 — varchar2(20)
- DEPT_CD4 — varchar2(20)
- DEPT_CD5 — varchar2(20)
- REG_ID — varchar2(255)
- REG_DT — timestamp — NOT NULL
- UPDT_ID — varchar2(255)
- UPDT_DT — timestamp
- DEL_ID — varchar2(255)
- DEL_DT — timestamp
- DEL_YN — char — NOT NULL
TB_INST_BLDG_MPNG
- INST_ID — number — 외래 키 → TB_INST.INST_ID
- BLDG_ID — varchar2(50) — 외래 키 → TB_BLDG.BLDG_ID
- REG_ID — varchar2(255)
- REG_DT — timestamp — NOT NULL
- UPDT_ID — varchar2(255)
- UPDT_DT — timestamp
- DEL_ID — varchar2(255)
- DEL_DT — timestamp
- DEL_YN — char — NOT NULL
- INST_ID (INST_ID2) — number — 외래 키 → TB_INST.INST_ID — NOT NULL
TB_OUTSD_USER
- USER_ID — varchar2(100) — NOT NULL
- USER_PSWD — varchar2(500)
- USER_TELNO — varchar2(20)
- USER_ROLE — varchar2(20)
- DEPT_CD1 — varchar2(20)
- DEPT_CD2 — varchar2(20)
- DEPT_CD3 — varchar2(20)
- DEPT_CD4 — varchar2(20)
- DEPT_CD5 — varchar2(20)
- REG_ID — varchar2(255)
- REG_DT — timestamp — NOT NULL
- UPDT_ID — varchar2(255)
- UPDT_DT — timestamp
- DEL_ID — varchar2(255)
- DEL_DT — timestamp
- DEL_YN — char — NOT NULL
TB_RGN
- RGN_CD — varchar2(20) — 기본 키 — NOT NULL
- RGN_SE_CD — varchar2(20)
- RGN_NM — varchar2(200)
- USE_YN — char(1)
- REG_ID — varchar2(255)
- REG_DT — timestamp — NOT NULL
- UPDT_ID — varchar2(255)
- UPDT_DT — timestamp
- DEL_ID — varchar2(255)
- DEL_DT — timestamp
- DEL_YN — char — NOT NULL
TB_RTU
- RTU_ID — number — NOT NULL
- CERT_RTU_ID — number — 외래 키 → TB_CERT_RTU.CERT_RTU_ID
- CID — varchar2(50) — NOT NULL
- STTS — varchar2(20)
- ACS_TOKEN — varchar2(64)
- EXPRY_DT — varchar2(64)
- RTU_INSTL_DT — timestamp
- REG_ID — varchar2(255)
- REG_DT — timestamp — NOT NULL
- UPDT_ID — varchar2(255)
- UPDT_DT — timestamp
- DEL_ID — varchar2(255)
- DEL_DT — timestamp
- DEL_YN — char — NOT NULL
TB_RTU_HIST
- RTU_HIST_ID — number — NOT NULL
- RTU_ID — number — 외래 키 → TB_RTU.RTU_ID
- CERT_RTU_ID — number
- CID — varchar2(50) — NOT NULL
- STTS — varchar2(20)
- ACS_TOKEN — varchar2(64)
- EXPRY_DT — varchar2(64)
- RTU_INSTL_DT — timestamp
- HIST_TY — varchar2(10) — NOT NULL
- REG_ID — varchar2(255)
- REG_DT — timestamp — NOT NULL
- UPDT_ID — varchar2(255)
- UPDT_DT — timestamp
- DEL_ID — varchar2(255)
- DEL_DT — timestamp
- DEL_YN — char — NOT NULL
TB_SYS_CD
- CD_ID — varchar2(20) — 기본 키 — NOT NULL
- UP_CD_ID — varchar2(20)
- CD_NM — varchar2(200)
- CD_CN1 — varchar2(200)
- CD_CN2 — varchar2(200)
- CD_CN3 — varchar2(200)
- CD_ORDR — number
- REG_ID — varchar2(255)
- REG_DT — timestamp — NOT NULL
- UPDT_ID — varchar2(255)
- UPDT_DT — timestamp
- DEL_ID — varchar2(255)
- DEL_DT — timestamp
- DEL_YN — char — NOT NULL
TB_USER_BLDG_MPNG
- USER_BLDG_MPNG_ID — number — NOT NULL
- USER_ID — varchar2(100) — 외래 키 → TB_OUTSD_USER.USER_ID
- BLDG_ID — varchar2(50) — 외래 키 → TB_BLDG.BLDG_ID
- REG_ID — varchar2(255)
- REG_DT — timestamp — NOT NULL
- UPDT_ID — varchar2(255)
- UPDT_DT — timestamp
- DEL_ID — varchar2(255)
- DEL_DT — timestamp
- DEL_YN — char — NOT NULL