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