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