REMS

Tables (10)

COMPANY (사업자)

  • COM_NO (Field) — VARCHAR — Primary key
  • COM_NM (Field2) — VARCHAR
  • COM_ADD (Field3) — VARCHAR
  • RPSV_NM (Field4) — VARCHAR
  • RPSV_CONT (Field5) — VARCHAR
  • ID (Field7) — varchar — Foreign key → USERS.ID

DAY_MAE_INFO (일별 계측정보)

  • FCTS_MNG_ID (Field7) — VARCHAR — Foreign key → FACILITY_INFO.FCTS_MNG_ID
  • COM_NO (Field2) — VARCHAR — Foreign key → COMPANY.COM_NO
  • MOL_ID (Field) — VARCHAR — Foreign key → MODULE_INFO.MOL_ID
  • YEAR (Field4) — datetime
  • MONTH (Field5) — datetime
  • DAY (Field6) — datetime
  • ANM (Field8) — decimal

FACILITY_INFO (설비정보)

  • FCTS_MNG_ID (Field) — VARCHAR — Primary key
  • FCTS_MNG_NO (Field2) — VARCHAR
  • FCTS_NM (Field3) — VARCHAR
  • COM_NO (Field5) — VARCHAR — Foreign key → COMPANY.COM_NO

HOUR_MAE_INFO (시간별 계측정보)

  • FCTS_MNG_ID (Field9) — VARCHAR — Foreign key → FACILITY_INFO.FCTS_MNG_ID
  • COM_NO (Field2) — VARCHAR — Foreign key → COMPANY.COM_NO
  • MOL_ID (Field) — VARCHAR — Foreign key → MODULE_INFO.MOL_ID
  • YEAR (Field4) — datetime
  • MONTH (Field5) — datetime
  • DAY (Field6) — datetime
  • HOUR (Field7) — datetime
  • ANM (Field8) — decimal

MODULE_INFO (모듈정보)

  • MOL_ID (Field) — VARCHAR — Primary key
  • MOL_NO (Field2) — VARCHAR
  • FCTS_MNG_ID (Field4) — VARCHAR — Foreign key → FACILITY_INFO.FCTS_MNG_ID

MON_MAE_INFO (월별 계측정보)

  • FCTS_MNG_ID (Field6) — VARCHAR — Foreign key → FACILITY_INFO.FCTS_MNG_ID
  • COM_NO (Field2) — VARCHAR — Foreign key → COMPANY.COM_NO
  • MOL_ID (Field) — VARCHAR — Foreign key → MODULE_INFO.MOL_ID
  • YEAR (Field4) — datetime
  • MONTH (Field5) — datetime
  • ANM (Field8) — decimal

PROBLEM (장애)

  • MOL_ID (Field) — VARCHAR — Foreign key → MODULE_INFO.MOL_ID
  • CONTENT (Field3) — VARCHAR
  • STATUS (Field4) — VARCHAR
  • HAP_DT (Field5) — DATETIME
  • FIN_DT (Field6) — DTAETIME
  • PRO_ID (PK) — VARCHAR

REAL_MEA_INFO (실시간 계측정보)

  • FCTS_MNG_ID (Field6) — VARCHAR — Foreign key → FACILITY_INFO.FCTS_MNG_ID
  • COM_NO (Field2) — VARCHAR — Foreign key → COMPANY.COM_NO
  • MOL_ID (Field) — VARCHAR — Foreign key → MODULE_INFO.MOL_ID
  • REAL (Field4) — datetime
  • AMN (Field5) — decimal
  • Field3
  • Field7
  • Field8
  • Field9
  • Field10
  • Field11
  • Field12 — VARCHAR

USERS (회원)

  • ID (PK) — VARCHAR(50) — Primary key
  • PWD (Field2) — VARCHAR(50)
  • NM (Field3) — VARCHAR(50)
  • EMAIL (Field4) — VARCHAR(50)
  • REG_DT (Field5) — datetime
  • MDF_DT (Field6) — datetime

YEAR_MAE_INFO (년별 계측정보)

  • FCTS_MNG_ID (Field5) — VARCHAR — Foreign key → FACILITY_INFO.FCTS_MNG_ID
  • COM_NO (Field2) — VARCHAR — Foreign key → COMPANY.COM_NO
  • MOL_ID (Field) — VARCHAR — Foreign key → MODULE_INFO.MOL_ID
  • YEAR (Field4) — datetime
  • ANM (Field8) — decimal