NC
Tables (10)
nc_f_fault_event
- event_id — BIGINT — Primary key — NOT NULL
- device_id — BIGINT — Foreign key → nc_r_resource_device.device_id — NOT NULL
- component_id — BIGINT — Foreign key → nc_r_resource_component.component_id
- metric_id — SMALLINT — Foreign key → nc_p_metric_catalog.metric_id
- event_type — ENUM('THRESHOLD_EXCEEDED','SNMP_NO_RESPONSE') — NOT NULL
- severity — ENUM('INFO','WARNING','CRITICAL') — NOT NULL
- threshold_value — DOUBLE
- actual_value — DOUBLE
- occurred_at — DATETIME — NOT NULL
- recovered_at — DATETIME
- status — ENUM('OPEN','RECOVERED') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
nc_p_metric_aggregate_1d
- id — BIGINT — Primary key — NOT NULL
- bucket_at — DATE — NOT NULL
- device_id — BIGINT — NOT NULL
- component_id — BIGINT — NOT NULL
- metric_id — SMALLINT — NOT NULL
- avg_value — DOUBLE — NOT NULL
nc_p_metric_aggregate_1h
- id — BIGINT — Primary key — NOT NULL
- bucket_at — DATETIME — NOT NULL
- device_id — BIGINT — NOT NULL
- component_id — BIGINT — NOT NULL
- metric_id — SMALLINT — NOT NULL
- avg_value — DOUBLE — NOT NULL
nc_p_metric_aggregate_30m
- id — BIGINT — Primary key — NOT NULL
- bucket_at — DATETIME — NOT NULL
- device_id — BIGINT — NOT NULL
- component_id — BIGINT — NOT NULL
- metric_id — SMALLINT — NOT NULL
- avg_value — DOUBLE — NOT NULL
nc_p_metric_catalog
- metric_id — SMALLINT — Primary key — NOT NULL
- metric_code — VARCHAR(50) — NOT NULL
- component_type — ENUM('CPU','MEMORY','DISK','INTERFACE','SYSTEM') — NOT NULL
- metric_name — VARCHAR(100) — NOT NULL
- unit — VARCHAR(20)
- description — VARCHAR(255)
nc_p_metric_latest
- id — BIGINT — Primary key — NOT NULL
- device_id — BIGINT — Foreign key → nc_r_resource_device.device_id — NOT NULL
- component_id — BIGINT — Foreign key → nc_r_resource_component.component_id — NOT NULL
- metric_id — SMALLINT — Foreign key → nc_p_metric_catalog.metric_id — NOT NULL
- value — DOUBLE — NOT NULL
- collected_at — DATETIME — NOT NULL
nc_p_metric_raw_5m
- id — BIGINT — Primary key — NOT NULL
- collected_at — DATETIME — NOT NULL
- device_id — BIGINT — NOT NULL
- component_id — BIGINT — NOT NULL
- metric_id — SMALLINT — NOT NULL
- value — DOUBLE — NOT NULL
nc_r_collect_config
- config_id — BIGINT — Primary key — NOT NULL
- device_id — BIGINT — Foreign key → nc_r_resource_device.device_id — NOT NULL
- snmp_version — ENUM('V1','V2C','V3')
- target_ip — VARCHAR(45) — NOT NULL
- target_port — INT
- community_alias — VARCHAR(50)
- polling_interval_sec — INT — NOT NULL
- is_enabled — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
nc_r_resource_component
- component_id — BIGINT — Primary key — NOT NULL
- device_id — BIGINT — Foreign key → nc_r_resource_device.device_id — NOT NULL
- component_type — ENUM('CPU','MEMORY','DISK','INTERFACE','SYSTEM') — NOT NULL
- component_name — VARCHAR(100) — NOT NULL
- description — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
nc_r_resource_device
- device_id — BIGINT — Primary key — NOT NULL
- device_name — VARCHAR(100) — NOT NULL
- device_type — VARCHAR(30) — NOT NULL
- management_ip — VARCHAR(45) — NOT NULL
- location — VARCHAR(100)
- status — ENUM('ACTIVE','INACTIVE','MAINTENANCE') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL