지열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