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