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