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