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