20210826 of REMS

Tables (13)

CD_DTA (코드 상세)

  • DTA_CD (Field) — VARCHAR — Primary key
  • DTA_CD_NM (Field2) — VARCHAR
  • MSTR_CD (Field5) — VARCHAR — Foreign key → CD_MSTR.MSTR_CD
  • DTA_ORDER (Field6) — VARCHAR
  • USE_YN (Field7) — VARCHAR
  • REG_DT (Field3) — DATETIME
  • MDFCN_DT (Field4) — DATETIME

CD_MSTR (코드마스터)

  • MSTR_CD (Field) — VARCHAR — Primary key
  • MSTR_CD_NM (Field2) — VARCHAR
  • REG_DT (Field3) — DATETIME
  • MDFCN_DT (Field4) — DATETIME

DD_INST_INFO (일별 계측정보)

  • GNRN_BIZ_UUID (Field9) — VARCHAR — Foreign key → GNRN_BIZ.GNRN_BIZ_UUID
  • FAC_MNG_UUID (Field7) — VARCHAR — Foreign key → GNRN_FAC_INFO.FAC_MNG_UUID
  • DV_UUID (Field8) — VARCHAR — Foreign key → DV_INFO.DV_UUID
  • YMD (Field) — VARCHAR
  • GNRN_VLM (Field2) — decimal
  • PK_GNRN_VLM (Field3) — DECIMAL
  • AVG_GNRN_VLM (Field4) — DECIMAL
  • DC_VTG (Field10) — DECIMAL
  • DC_CRT (Field11) — DECIMAL
  • DC_EFFEC_PWR (Field12) — DECIMAL
  • AC_VTG (Field13) — DECIMAL
  • AC_CRT (Field14) — DECIMAL
  • AC_EFFEC_PWR (Field15) — DECIMAL
  • REG_DT (Field5) — DATETIME
  • MDFCN_DT (Field6) — DATETIME
  • GNRN_EFFCY (Field16) — DECIMAL
  • SC_VTG (Field17) — DECIMAL
  • SC_CRT (Field18) — DECIMAL
  • SC_OPT (Field19) — DECIMAL
  • RS_RN (Field20) — DECIMAL
  • ST_SN (Field21) — DECIMAL
  • TR_TN (Field22) — DECIMAL
  • FRQCY (Field23) — DECIMAL
  • R_CRT (Field24) — DECIMAL
  • T_CRT (Field25) — DECIMAL
  • S_CRT (Field26) — DECIMAL
  • OPT (Field27) — DECIMAL

DV_INFO (디바이스 정보)

  • DV_UUID (Field) — VARCHAR — Primary key
  • FAC_MNG_UUID (Field7) — VARCHAR — Foreign key → GNRN_FAC_INFO.FAC_MNG_UUID
  • DV_NO (Field8) — INT
  • DV_NM (Field2) — VARCHAR
  • DV_DTA (Field3) — VARCHAR
  • DV_MKR (Field4) — VARCHAR
  • REG_DT (Field5) — DATETIME
  • MDFCN_DT (Field6) — DATETIME

FAILURE (장애)

  • FAL_ID (Field) — VARCHAR — Primary key
  • DV_UUID (Field6) — VARCHAR — Foreign key → DV_INFO.DV_UUID
  • FAC_MNG_UUID (Field42) — VARCHAR — Foreign key
  • GNRN_BIZ_UUID (Field7) — VARCHAR
  • CONTENT_CD (Field2) — VARCHAR
  • STAT_CD (Field3) — VARCHAR
  • OCRN_DT (Field4) — DATETIME
  • END_DT (Field5) — DATETIME

GNRN_BIZ (발전 사업자)

  • GNRN_BIZ_UUID (Field) — VARCHAR — Primary key
  • SYS_MNGR_UUID (Field13) — VARCHAR — Foreign key → SYS_MNGR.SYS_MNGR_UUID
  • MNGR_CO_UUID (Field12) — VARCHAR — Foreign key → MNGR_CO.MNGR_CO_UUID
  • BRNO (Field2) — VARCHAR
  • ID (Field11) — VARCHAR
  • PWD (Field3) — VARCHAR
  • BIZ_ADDR (Field5) — VARCHAR
  • BIZ_NM (Field4) — VARCHAR
  • RPRSV_NM (Field6) — VARCHAR
  • RPRSV_CONT (Field7) — VARCHAR
  • RPRSV_EML (Field8) — VARCHAR
  • REG_DT (Field9) — DATETIME
  • MDFCN_DT (Field10) — DATETIME
  • PIC (Field15) — VARCHAR
  • PIC_CONT (Field16) — VARCHAR

GNRN_FAC_INFO (발전설비정보)

  • FAC_MNG_UUID (Field) — VARCHAR — Primary key
  • GNRN_BIZ_UUID (Field10) — VARCHAR — Foreign key → GNRN_BIZ.GNRN_BIZ_UUID
  • FAC_MNG_NO (Field2) — VARCHAR
  • FAC_NM (Field3) — VARCHAR
  • FAC_AREA (Field5) — VARCHAR
  • FAC_ADDR (Field6) — VARCHAR
  • FAC_CPT (Field7) — DECIMAL
  • REG_DT (Field8) — DATETIME
  • MDFCN_DT (Field9) — DATETIME
  • ENY_CD (Field11) — VARCHAR
  • FAC_RPRSV_YN (Field12) — VARCHAR
  • FAC_NO (Field4) — INT

HR_INST_INFO (시간별 계측정보)

  • GNRN_BIZ_UUID (Field11) — VARCHAR — Foreign key → GNRN_BIZ.GNRN_BIZ_UUID
  • FAC_MNG_UUID (Field8) — VARCHAR — Foreign key → GNRN_FAC_INFO.FAC_MNG_UUID
  • DV_UUID (Field9) — VARCHAR — Foreign key → DV_INFO.DV_UUID
  • YMD (Field) — VARCHAR
  • HR (Field2) — VARCHAR
  • GNRN_VLM (Field3) — decimal
  • PK_GNRN_VLM (Field4) — DECIMAL
  • AVG_GNRN_VLM (Field5) — DECIMAL
  • DC_VTG (Field10) — DECIMAL
  • DC_CRT (Field12) — DECIMAL
  • DC_EFFEC_PWR (Field13) — DECIMAL
  • AC_VTG (Field14) — DECIMAL
  • AC_CRT (A) — DECIMAL
  • AC_EFFEC_PWR (Field16) — DECIMAL
  • REG_DT (Field6) — DATETIME
  • MDFCN_DT (Field7) — DATETIME
  • GNRN_EFFCY (Field15) — DECIMAL
  • SC_VTG (Field17) — DECIMAL
  • SC_CRT (Field18) — DECIMAL
  • SC_OPT (Field19) — DECIMAL
  • RS_RN (Field20) — DECIMAL
  • ST_SN (Field21) — DECIMAL
  • TR_TN (Field22) — DECIMAL
  • FRQCY (Field23) — DECIMAL
  • R_CRT (Field24) — DECIMAL
  • T_CRT (Field25) — DECIMAL
  • S_CRT (Field26) — DECIMAL
  • OPT (Field27) — DECIMAL

MM_INST_INFO (월별 계측정보)

  • GNRN_BIZ_UUID (Field9) — VARCHAR — Foreign key → GNRN_BIZ.GNRN_BIZ_UUID
  • FAC_MNG_UUID (Field7) — VARCHAR — Foreign key → GNRN_FAC_INFO.FAC_MNG_UUID
  • DV_UUID (Field8) — VARCHAR — Foreign key → DV_INFO.DV_UUID
  • YM (Field) — VARCHAR
  • GNRN_VLM (Field2) — decimal
  • PK_GNRN_VLM (Field3) — DECIMAL
  • AVG_GNRN_VLM (Field4) — DECIMAL
  • DC_VTG (Field10) — DECIMAL
  • DC_CRT (Field11) — DECIMAL
  • DC_EFFEC_PWR (Field12) — DECIMAL
  • AC_VTG (Field13) — DECIMAL
  • AC_CRT (Field14) — DECIMAL
  • AC_EFFEC_PWR (Field15) — DECIMAL
  • REG_DT (Field5) — DATETIME
  • MDFCN_DT (Field6) — DATETIME
  • GNRN_EFFCY (Field16) — DECIMAL
  • SC_VTG (Field17) — DECIMAL
  • SC_CRT (Field18) — DECIMAL
  • SC_OPT (Field19) — DECIMAL
  • RS_RN (Field20) — DECIMAL
  • ST_SN (Field21) — DECIMAL
  • TR_TN (Field22) — DECIMAL
  • FRQCY (Field23) — DECIMAL
  • R_CRT (Field24) — DECIMAL
  • T_CRT (Field25) — DECIMAL
  • S_CRT (Field26) — DECIMAL
  • OPT (Field27) — DECIMAL

MNGR_CO (관리업체)

  • MNGR_CO_UUID (Field) — VARCHAR — Primary key
  • SYS_MNGR_UUID (Field14) — VARCHAR — Foreign key → SYS_MNGR.SYS_MNGR_UUID
  • BRNO (Field2) — VARCHAR
  • ID (Field3) — VARCHAR
  • PWD (Field4) — VARCHAR
  • MNGR_CO_NM (Field5) — VARCHAR
  • MNGR_CO_ADDR (Field6) — VARCHAR
  • RPRSV_CONT (Field13) — VARCHAR
  • RPRSV_NM (Field7) — VARCHAR
  • RPRSV_EML (Field8) — VARCHAR
  • PIC (Field9) — VARCHAR
  • PIC_CONT (Field10) — VARCHAR
  • REG_DT (Field11) — DATETIME
  • MDFCN_DT (Field12) — DATETIME
  • USE_YN (Field15) — varchar

REAL_INST_INFO (실시간 계측정보)

  • GNRN_BIZ_UUID (Field8) — VARCHAR — Foreign key → GNRN_BIZ.GNRN_BIZ_UUID
  • FAC_MNG_UUID (Field6) — VARCHAR — Foreign key → GNRN_FAC_INFO.FAC_MNG_UUID
  • DV_UUID (Field7) — VARCHAR — Foreign key → DV_INFO.DV_UUID
  • REAL_DT (Field) — DATETIME
  • GNRN_VLM (Field4) — DECIMAL
  • PK_GNRN_VLM (Field2) — DECIMAL
  • AVG_GNRN_VLM (Field3) — DECIMAL
  • DC_VTG (Field9) — DECIMAL
  • DC_CRT (Field10) — DECIMAL
  • DC_EFFEC_PWR (Field11) — DECIMAL
  • AC_VTG (Field12) — DECIMAL
  • AC_CRT (A) — DECIMAL
  • AC_EFFEC_PWR (Field14) — DECIMAL
  • REG_DT (Field5) — DATETIME
  • GNRN_EFFCY (Field13) — DECIMAL
  • SC_VTG (Field15) — DECIMAL
  • SC_CRT (Field16) — DECIMAL
  • SC_OPT (Field17) — DECIMAL
  • RS_RN (Field18) — DECIMAL
  • ST_SN (Field19) — DECIMAL
  • TR_TN (Field20) — DECIMAL
  • FRQCY (Field21) — DECIMAL
  • R_CRT (Field22) — DECIMAL
  • T_CRT (Field23) — DECIMAL
  • S_CRT (Field24) — DECIMAL
  • OPT (Field25) — DECIMAL
  • STAT (Field26) — VARCHAR

SYS_MNGR (시스템 관리자)

  • SYS_MNGR_UUID (Field) — VARCHAR — Primary key
  • ID (Field2) — VARCHAR
  • PWD (Field3) — VARCHAR
  • SYS_MNGR_NM (Field4) — VARCHAR
  • SYS_MNGR_CONT (Field5) — VARCHAR
  • SYS_MNGR_EML (Field6) — VARCHAR
  • REG_DT (Field7) — DATETIME
  • MDFCN_DT (Field8) — DATETIME

YR_INST_INFO (년별 계측정보)

  • GNRN_BIZ_UUID (Field9) — VARCHAR — Foreign key → GNRN_BIZ.GNRN_BIZ_UUID
  • FAC_MNG_UUID (Field7) — VARCHAR — Foreign key → GNRN_FAC_INFO.FAC_MNG_UUID
  • DV_UUID (Field8) — VARCHAR — Foreign key → DV_INFO.DV_UUID
  • YR (Field) — datetime
  • GNRN_VLM (Field2) — decimal
  • PK_GNRN_VLM (Field3) — DECIMAL
  • AVG_GNRN_VLM (Field4) — DECIMAL
  • REG_DT (Field5) — DATETIME
  • MDFCN_DT (Field6) — DATETIME
  • DC_VTG (Field10) — DECIMAL
  • DC_CRT (Field11) — DECIMAL
  • DC_EFFEC_PWR (Field12) — DECIMAL
  • AC_VTG (Field13) — DECIMAL
  • AC_CRT (Field14) — DECIMAL
  • AC_EFFEC_PWR (Field15) — DECIMAL
  • GNRN_EFFCY (Field16) — DECIMAL
  • SC_VTG (Field17) — DECIMAL
  • SC_CRT (Field18) — DECIMAL
  • SC_OPT (Field19) — DECIMAL
  • RS_RN (Field20) — DECIMAL
  • ST_SN (Field21) — DECIMAL
  • TR_TN (Field22) — DECIMAL
  • FRQCY (Field23) — DECIMAL
  • R_CRT (Field24) — DECIMAL
  • T_CRT (Field25) — DECIMAL
  • S_CRT (Field26) — DECIMAL
  • OPT (Field27) — DECIMAL