20210720 of REMS
Tables (14)
CD_DTA (코드상세)
- DTA_CD (Field2) — VARCHAR — Primary key
- DTA_CD_NM (Field4) — VARCHAR
- MSTR_CD (Field3) — VARCHAR — Foreign key → CD_MSTR.MSTR_CD
- DTA_ORDER (Field5) — DECIMAL
- USE_YN (Field) — VARCHAR
CD_MSTR (코드마스터)
- MSTR_CD (Field3) — VARCHAR — Primary key
- MSTR_CD_NM (Field2) — VARCHAR
COMPANY (사업자)
- CO_NO (Field) — VARCHAR — Primary key
- COM_NM (Field2) — VARCHAR
- CO_ADD (Field3) — VARCHAR
- RPSV_NM (Field4) — VARCHAR
- RPSV_CONT (Field5) — VARCHAR
- ID (Field7) — varchar — Foreign key → MEMBERS.ID
- USE_YN (Field6) — VARCHAR
- REG_DT (Field8) — datetime
- MDFCN_DT (Field9) — datetime
- CO_RPSV_YN (Field10) — VARCHAR
DD_INST_INFO (일별 계측정보)
- FCTS_MNG_ID (Field7) — VARCHAR — Foreign key → FACILITY_INFO.FCTS_MNG_ID
- CO_NO (Field2) — VARCHAR — Foreign key → COMPANY.CO_NO
- MDL_ID (Field) — VARCHAR — Foreign key → MODULE_INFO.MDL_ID
- YR (Field4) — datetime
- MM (Field5) — datetime
- DD (Field6) — datetime
- ANM (Field8) — decimal
DD_TOTAL_HR_INFO (일별 발전시간 정보)
- FCTS_MNG_ID (Field) — VARCHAR
- C0_NO (Field2) — VARCHAR
- MDL_ID (Field3) — VARCHAR
- FCTS_AREA (Field4) — VARCHAR
- TOTAL_HR (Field5) — INT
- TOTAL_AMN (Field6) — DECIMAL
- AMN_YMD (Field7) — VARCHAR
FACILITY_INFO (설비정보)
- FCTS_MNG_ID (Field) — VARCHAR — Primary key
- FCTS_MNG_NO (Field2) — VARCHAR
- FCTS_NM (Field3) — VARCHAR
- FCTS_RPSV_YN (Field5) — VARCHAR
- FCTS_AREA (Field6) — VARCHAR
- FCTS_ADD (Field8) — VARCHAR
- FCTS_VLM (Field9) — DECIMAL
- ENY_CD (Field7) — VARCHAR
- REG_DT (Field10) — datetime
- MDFCN_CT (Field11) — datetime
- CO_NO (Field4) — VARCHAR
- CO_NO (Field12) — VARCHAR — Foreign key → COMPANY.CO_NO
FAILURE (장애)
- FAL_ID (PK) — VARCHAR — Primary key
- MDL_ID (Field) — VARCHAR — Foreign key → MODULE_INFO.MDL_ID
- CONT (Field3) — VARCHAR
- STAT (Field4) — VARCHAR
- OCRN_DT (Field5) — DATETIME
- END_DT (Field6) — DTAETIME
HR_INST_INFO (시간별 계측정보)
- FCTS_MNG_ID (Field9) — VARCHAR — Foreign key → FACILITY_INFO.FCTS_MNG_ID
- CO_NO (Field2) — VARCHAR — Foreign key → COMPANY.CO_NO
- MDL_ID (Field) — VARCHAR — Foreign key → MODULE_INFO.MDL_ID
- YR (Field4) — datetime
- MM (Field5) — datetime
- DAY (Field6) — datetime
- HR (Field7) — datetime
- ANM (Field8) — decimal
MEMBERS (회원)
- ID (PK) — varchar — Primary key
- PWD (Field2) — varchar
- NM (Field3) — varchar
- EML (Field4) — varchar
- REG_DT (Field5) — datetime
- MDFCN_DT (Field6) — datetime
- USE_YN (Field) — varchar
- CONT (Field7) — VARCHAR
MM_INST_INFO (월별 계측정보)
- FCTS_MNG_ID (Field6) — VARCHAR — Foreign key → FACILITY_INFO.FCTS_MNG_ID
- CO_NO (Field2) — VARCHAR — Foreign key → COMPANY.CO_NO
- MDL_ID (Field) — VARCHAR — Foreign key → MODULE_INFO.MDL_ID
- YR (Field4) — datetime
- MM (Field5) — datetime
- AMN (Field8) — decimal
MNGR (관리자)
- ID (Field) — varchar — Primary key
- PWD (Field2) — varchar
- NM (Field3) — varchar
MODULE_INFO (모듈정보)
- MDL_ID (Field) — VARCHAR — Primary key
- MDL_NO (Field2) — VARCHAR
- FCTS_MNG_ID (Field4) — VARCHAR — Foreign key → FACILITY_INFO.FCTS_MNG_ID
- MDL_DTA (Field3) — LONGTEXT
- MDL_NM (Field5) — VARCHAR
REAL_INST_INFO (실시간 계측정보)
- FCTS_MNG_ID (Field6) — VARCHAR — Foreign key → FACILITY_INFO.FCTS_MNG_ID
- CO_NO (Field2) — VARCHAR — Foreign key → COMPANY.CO_NO
- MDL_ID (Field) — VARCHAR — Foreign key → MODULE_INFO.MDL_ID
- REAL (Field4) — datetime
- AMN (Field5) — decimal
YR_INST_INFO (년별 계측정보)
- FCTS_MNG_ID (Field5) — VARCHAR — Foreign key → FACILITY_INFO.FCTS_MNG_ID
- CO_NO (Field2) — VARCHAR — Foreign key → COMPANY.CO_NO
- MDL_ID (Field) — VARCHAR — Foreign key → MODULE_INFO.MDL_ID
- YR (Field4) — datetime
- ANM (Field8) — decimal