ASD
Tables (15)
TBL_ALARM_LOG
- SEQ — INT
- TIME — DATETIME — NOT NULL
- TYPE — VARCHAR(50) — NOT NULL
- DAU_ID — INT — NOT NULL
- DESC — VARCHAR(255)
- ACK — BOOLEAN
- ACK_TIME — DATETIME
TBL_EQUIPMENT_LOG
- SEQ — INT
- SETTING_TIME — DATETIME — NOT NULL
- DAU_ID — INT — NOT NULL
- GATING — BOOLEAN — NOT NULL
- GATING_THRESHOLD — INT — NOT NULL
- PT_FREQUENCY — INT — NOT NULL
- GATING_PRE — INT — NOT NULL
- GATING_POST — INT — NOT NULL
- CH_GATING — INT — NOT NULL
- CH_CALIBRATION — INT — NOT NULL
- CH_PREAMP — INT — NOT NULL
- BAND_STOP_FILTER — INT — NOT NULL
TBL_EQUIPMENT_SETTING
- SEQ — INT
- NM — VARCHAR(100) — NOT NULL
- SERIAL — VARCHAR(100)
- FIRMWAREVER — VARCHAR(50)
- IP — VARCHAR(15)
- PORT — INT
- MAC — VARCHAR(17)
- CHANNEL_COUNT — INT
- GATING_ENABLE — BOOLEAN
- GATING_THRESHOLD — FLOAT
- PT_FREQUENCY — FLOAT
- GATING_PRE — INT
- GATING_POST — INT
- CHANNEL_INFO — JSON — JSON 현재 수정은 불가능하고 조회만 가능해보임
TBL_EVENT_DATA
- ALARM_SEQ — INT — NOT NULL
- INDEX — INT — NOT NULL
- DATA — FLOAT
TBL_EVENT_DIAGNOSIS
- SEQ — INT
- SENSOR_ID — INT — NOT NULL
- SENSOR_NAME — VARCHAR(100)
- DAU_NAME — VARCHAR(100)
- CHANNEL — INT — NOT NULL
- TIME — DATETIME — NOT NULL
- COMMENT — 'ARCHAR(255',` VARCHAR(255) — ARCHAR(255',` VARCHAR(255) NULL COMMENT `GRAPH_DATA` VARCHAR(255) NUL
- PD_INFO — VARCHAR(255) — JSON
- TYPE — VARCHAR(255) — PD INFO에 있으면 필요없는 컬럼
TBL_SENSOR
- SEQ — INT
- SENSOR_DESC — VARCHAR(255)
- DAU_ID_SEQ — INT — NOT NULL
- CHANNEL — INT — NOT NULL
- GROUP_NUM — INT
- SENSOR_NAME — VARCHAR(100) — NOT NULL
TBL_SYSTEM_SETTING
- SEQ — INT
- UNIT — VARCHAR(50) — JSON
- SELFTEST — BOOLEAN — JSON
- EVENTSETTING — VARCHAR(255) — JSON
- ALARMSETTING — VARCHAR(255) — JSON
- SYSTEMEVENTSETTING — VARCHAR(255) — JSON
- FTP_FILE_SYNC — BOOLEAN — JSON
TBL_TREND_10MIN
- SEQ — INT
- DAU_ID — INT — NOT NULL
- SENSOR_ID — INT — NOT NULL
- CHANNEL — INT — NOT NULL
- TIME — DATETIME — NOT NULL
- MAX — FLOAT
- AVG — FLOAT
TBL_TREND_15MIN
- SEQ — INT
- DAU_ID — INT — NOT NULL
- SENSOR_ID — INT — NOT NULL
- CHANNEL — INT — NOT NULL
- TIME — DATETIME — NOT NULL
- MAX — FLOAT
- AVG — FLOAT
TBL_TREND_5MIN
- SEQ — INT
- DAU_ID — INT — NOT NULL
- SENSOR_ID — INT — NOT NULL
- CHANNEL — INT — NOT NULL
- TIME — DATETIME — NOT NULL
- MAX — FLOAT
- AVG — FLOAT
TBL_TREND_DAY
- SEQ — INT
- DAU_ID — INT — NOT NULL
- SENSOR_ID — INT — NOT NULL
- CHANNEL — INT — NOT NULL
- TIME — DATETIME — NOT NULL
- MAX — FLOAT
- AVG — FLOAT
TBL_TREND_HOUR
- SEQ — INT
- DAU_ID — INT — NOT NULL
- SENSOR_ID — INT — NOT NULL
- CHANNEL — INT — NOT NULL
- TIME — DATETIME — NOT NULL
- MAX — FLOAT
- AVG — FLOAT
TBL_TREND_MONTH
- SEQ — INT
- DAU_ID — INT — NOT NULL
- SENSOR_ID — INT — NOT NULL
- CHANNEL — INT — NOT NULL
- TIME — DATETIME — NOT NULL
- MAX — FLOAT
- AVG — FLOAT
TBL_TREND_WEEK
- SEQ — INT
- DAU_ID — INT — NOT NULL
- SENSOR_ID — INT — NOT NULL
- CHANNEL — INT — NOT NULL
- TIME — DATETIME — NOT NULL
- MAX — FLOAT
- AVG — FLOAT
TBL_TREND_YEAR
- SEQ — INT
- DAU_ID — INT — NOT NULL
- SENSOR_ID — INT — NOT NULL
- CHANNEL — INT — NOT NULL
- TIME — DATETIME — NOT NULL
- MAX — FLOAT
- AVG — FLOAT