MFM-ERD
Tables (15)
ALERT (Untitled)
- ID — INTEGER — Primary key — NOT NULL
- SERVERNO — INTEGER — Foreign key → SERVER.SERVER_ID — NOT NULL
- STATID — INTEGER
- STAT_LEVEL — VARCHAR
- STAT_VALUE — DOUBLE
- SETTING_VALUE (SETTINGV_ALUE) — DOUBLE
- RECOVERY_TIME — TIMESTAMP
- DESCRIPTION — VARCHAR
- WHO — VARCHAR
- REASON — VACHAR
- LOG_TIME — TIMESTAMP
- ADD_TIME — TIMESTAMP
- USER_DESCRIPTION — VARCHAR
ALERT_FILTER (CopyOfUntitled)
- ID — INTEGER — Primary key — NOT NULL
- FILTER_NAME — VARCHAR
- MAIN_VALUE — INTEGER
- RESET_SEC — INTEGER
- SUB_VALUE — INTEGER
ALERT_MGR (Untitled3)
- ID — INTEGER — Primary key — NOT NULL
- SERVER_NO — INTEGER — Foreign key → SERVER.SERVER_ID — NOT NULL
- STAT_ID — INTEGER — Foreign key → STAT.STAT_ID — NOT NULL
- FILTER_ID — INTEGER — Foreign key → ALERT_FILTER.ID — NOT NULL
- COMPARISON — VARCHAR
- CRITICAL — DOUBLE
- WARNING — DOUBLE
- TYPE — INTEGER
- DESCRIPTION — VACHAR
- USE_YN — BOOLEAN
ALERT_MGR_HISTORY (Untitled5)
BACKUP_HISTORY (Untitled6)
- ID — INTEGER — Primary key — NOT NULL
- SERVER_NO — INTEGER — Foreign key → SERVER.SERVER_ID — NOT NULL
- LOG_TIME — TIMESTAMP
- START_TIME — TIMESTAMP
- END_TIME — TIMESTAMP
- BACKUP_DESTINATION — TIMESTAMP
- EXIT_STATE — VARCHAR
- LAST_ERROR_CODE — VARCHAR
CODE (Untitled7)
- ID — INTEGER — Primary key — NOT NULL
- CODE — VARCHAR
- DESCRIPTION — VARCHAR
- DETAIL_CODE — VARCHAR
- ADD_TIME (ADD_TME) — TIMESTAMP
DEADLOCK (Untitled8)
- ID — INTEGER — Foreign key → SERVER.SERVER_ID — NOT NULL
- LOCK_TYPE — LOCK_TYPE
- LOCK_DATE_TIME — TIMESTAMP
- LOGTIME — TIMESTAMP
DISK_INFO (Untitled9)
- ID — INTEGER — Foreign key → SERVER.SERVER_ID — NOT NULL
- FILE_SYSTEM — VARCHAR
- MOUNT — VARCHAR
- TOTAL — BIGINT
- USED — BIGINT
- FREE — BIGINT
- USAGE_PERCENT — NUMERIC(5,2)
- RESERVED — BIGINT
- LOGTIME — TIMESTAMP
DISK_IO (Untitled10)
- ID — INTEGER — Foreign key → SERVER.SERVER_ID — NOT NULL
- PARTITION_NAME — VARCHAR
- TPS — NUMERIC(20,2)
- READ_COUNT_PER_SEC — NUMERIC(20,2)
- WRITE_COUNT_PER_SEC — NUMERIC(20,2)
- WRITE_BYTE_PER_SEC — NUMERIC(20,2)
- LOGTIME — TIMESTAMP
ERROR_LOG (Untitled11)
- ID — INTEGER — Foreign key → SERVER.SERVER_ID — NOT NULL
- ERROR_LOG_TYPE — ERROR_LOG_TYPE
- VALUE — TEXT
- RECOVERY_TIME — TIMESTAMP
- LOGTIME — TIMESTAMP
- WHO — VARCHAR
- REASON — VARCHAR
LOCATION (Untitled13)
- LOCATION_ID — BIGINT — Primary key — NOT NULL
- ID (ID2) — INTEGER — Foreign key → SERVER.SERVER_ID — NOT NULL
- GROUP_ID — VARCHAR
- GROUP_NO — INTEGER
LOCK_TREE (Untitled14)
- SERVER_ID — BIGINT — Foreign key → SERVER.SERVER_ID — NOT NULL
- LOCK_TRX_ID — VARCHAR
- HOLDER_TRX_ID — VARCHAR
- LOCK_MODE — LOCK_MODE
- LOCK_TYPE — LOCK_TYPE
- LOCK_TABLE — VARCHAR
- LOCK_PAGE — BIGINT
- LOCK_REC — BIGINT
- USERS — VARCHAR
- HOST — VARCHAR
- DB — VARCHAR
- ELAPSED_TIME — BIGINT
- SQLTEXT_HID — BIGINT
PROCESS (Untitled12)
SERVER (Untitled2)
- SERVER_ID — INTEGER — Primary key — NOT NULL
- NO — INTEGER
- NAME — VARCHAR
- ALIAS — VARCHAR
- TYPE — VARCHAR
- DESCRIPTION — VARCHAR
- IP — VARCHAR
- DB_PORT — INTEGER
- LOGIN_ID — VARCHAR
- PASSWD — VARCHAR
- SYSMON_PORT — INTEGER
- USE_YN — BOOLEAN
- ENCODING — VARCHAR
- INSTANCE_NAME — VARCHAR
- SQL_TEXT_LIMIT — INTEGER
STAT (Untitled4)
- STAT_ID — BIGINT — Primary key — NOT NULL
- STAT_KIND — INTEGER
- STAT_NAME — VARCHAR
- CAPTION — VARCHAR
- EXPRESSION — VARCHAR
- STAT_TYPE — VARCHAR
- USE_OPTION — BOOLEAN
- VALUE_TYPE — INTEGER
- ADD_TIME — TIMESTAMP