1

Tables (4)

EVENT_LOG_TAB (Untitled2)

  • EVENT_LOG_ID (이벤트로그) — CHARATER — Primary key
  • EVENT_LOG_VAL (로그값) — CHARATER

SYSTEM_GROUP_TAB (/)

  • SYSTEM_GROUP_ID (그룹ID) — CHARATER — Primary key — NOT NULL
  • SYSTEM_GROUP_NAME (그룹 NAME) — CHARATER
  • GROUP_DESC (그룹 설명) — CHARATER

SYSTEM_STATUS_TAB (.)

  • SYSTEM_PID (장비ID) — CHARATER — Primary key
  • EVENT_LOG_ID (이벤트로그) — CHARATER — Foreign key → EVENT_LOG_TAB.EVENT_LOG_ID
  • SYSTEM_NETWORK_STATUS (네트워크 상태) — NUNMBER
  • LINK_STATUS (링크상태) — NUMBER
  • CPU_STATUS (CPU상태) — NUMBER
  • MEM_STATUS (MEM상태) — NUMBER
  • DISK_STATUS (DISK상태) — NUMBER
  • EVENT_LOGS (EVENTLOG) — NUMBER

system_tab (장비)

  • SYSTEM_ID (장비ID) — CHARATER — Primary key
  • SYSTEM_GROUP_ID (그룹ID2) — CHARATER — Foreign key → SYSTEM_GROUP_TAB.SYSTEM_GROUP_ID — NOT NULL
  • SYSTEM_PID (장비ID2) — CHARATER — Foreign key → SYSTEM_STATUS_TAB.SYSTEM_PID
  • EVENT_LOG_ID (이벤트로그) — CHARATER — Foreign key → SYSTEM_STATUS_TAB.EVENT_LOG_ID
  • manufacturer (제조사) — CHARATER