test

Tables (38)

snmp_active_user_5min_info

  • server_ip — varchar(16) — Primary key — NOT NULL
  • polling_time — datetime — Primary key — NOT NULL
  • active_min_user — int(10)
  • active_avg_user — int(10)
  • active_max_user — int(10)

snmp_active_user_day_info

  • server_ip — varchar(16) — Primary key — NOT NULL
  • polling_time — datetime — Primary key — NOT NULL
  • active_min_user — int(10)
  • active_avg_user — int(10)
  • active_max_user — int(10)

snmp_active_user_hour_info

  • server_ip — varchar(16) — Primary key — NOT NULL
  • polling_time — datetime — Primary key — NOT NULL
  • active_min_user — int(10)
  • active_avg_user — int(10)
  • active_max_user — int(10)

snmp_core_5min_info

  • server_ip — varchar(16) — Primary key — NOT NULL
  • polling_time — datetime — Primary key — NOT NULL
  • core_index — int(10) — Primary key — NOT NULL
  • core_status — int(2) — NOT NULL
  • core_min_load — int(3) — NOT NULL
  • core_desc — varchar(100)

snmp_core_day_info

  • server_ip — varchar(16) — Primary key — NOT NULL
  • polling_time — datetime — Primary key — NOT NULL
  • core_index — int(10) — Primary key — NOT NULL
  • core_status — int(2) — NOT NULL
  • core_min_load — int(3) — NOT NULL
  • core_desc — varchar(100)

snmp_core_hour_info

  • server_ip — varchar(16) — Primary key — NOT NULL
  • polling_time — datetime — Primary key — NOT NULL
  • core_index — int(10) — Primary key — NOT NULL
  • core_status — int(2) — NOT NULL
  • core_min_load — int(3) — NOT NULL
  • core_desc — varchar(100)

snmp_core_info

  • server_ip — varchar(16) — Primary key — NOT NULL
  • polling_time — datetime — Primary key — NOT NULL
  • core_index — int(10) — Primary key — NOT NULL
  • core_status — int(2) — NOT NULL
  • core_min_load — int(3) — NOT NULL
  • core_desc — varchar(100)

snmp_cpu_5min_info

  • server_ip — varchar(16) — Primary key — NOT NULL
  • polling_time — datetime — Primary key — NOT NULL
  • cpu_1min_load — float(3,1)
  • cpu_5min_load — float(3,1)
  • cpu_15min_load — float(3,1)

snmp_cpu_day_info

  • server_ip — varchar(16) — Primary key — NOT NULL
  • polling_time — datetime — Primary key — NOT NULL
  • cpu_1min_load — float(3,1)
  • cpu_5min_load — float(3,1)
  • cpu_15min_load — float(3,1)

snmp_cpu_hour_info

  • server_ip — varchar(16) — Primary key — NOT NULL
  • polling_time — datetime — Primary key — NOT NULL
  • cpu_1min_load — float(3,1)
  • cpu_5min_load — float(3,1)
  • cpu_15min_load — float(3,1)

snmp_cpu_info

  • server_ip — varchar(16) — Primary key — NOT NULL
  • polling_time — datetime — NOT NULL
  • cpu_1min_load — float(3,1)
  • cpu_5min_load — float(3,1)
  • cpu_15min_load — float(3,1)

snmp_current_fault_info

  • id — int(11) — Primary key — NOT NULL
  • server_ip — varchar(16) — NOT NULL
  • create_time — datetime
  • fault_type — varchar(30) — NOT NULL
  • fault_detail — varchar(256) — NOT NULL
  • severity — int(11)
  • value — int(3)

snmp_dashboard_info

  • server_ip — varchar(16) — Primary key — NOT NULL
  • change_time — datetime
  • ping_alive — int(2)
  • snmp_alive — int(2)
  • cpu_fault_status — int(2)
  • memory_fault_status — int(2)
  • disk_fault_status — int(2)
  • network_fault_status — int(2)

snmp_delete_info

  • min_data — int(3) — Primary key — NOT NULL
  • hour_data — int(3)
  • day_data — int(3)

snmp_device_baseline

  • server_ip — varchar(16) — Primary key — NOT NULL
  • cpu_utilization_minor — int(3) — NOT NULL
  • cpu_utilization_major — int(3) — NOT NULL
  • cpu_utilization_critical — int(3) — NOT NULL
  • mem_utilization_minor — int(3) — NOT NULL
  • mem_utilization_major — int(3) — NOT NULL
  • mem_utilization_critical — int(3) — NOT NULL
  • disk_utilization_minor — int(3) — NOT NULL
  • disk_utilization_major — int(3) — NOT NULL
  • disk_utilization_critical — int(3) — NOT NULL
  • network_utilization_minor — int(3) — NOT NULL
  • network_utilization_major — int(3) — NOT NULL
  • network_utilization_critical — int(3) — NOT NULL

snmp_device_info

  • server_ip — varchar(16) — Primary key — NOT NULL
  • site_code — varchar(6) — NOT NULL
  • site_id — int(4) — NOT NULL
  • server_type — varchar(16)
  • snmp_port — int(11) — NOT NULL
  • user_name — varchar(256) — NOT NULL
  • security_level — varchar(256) — NOT NULL
  • auth_protocol — varchar(256)
  • auth_password — varchar(256)
  • priv_protocol — varchar(256)
  • priv_password — varchar(256)

snmp_disk_5min_info

  • server_ip — varchar(16) — Primary key — NOT NULL
  • polling_time — datetime — Primary key — NOT NULL
  • disk_index — int(11) — Primary key — NOT NULL
  • disk_desc — varchar(100)
  • disk_total_size — bigint(20)
  • disk_used_size — bigint(20)
  • disk_free_size — bigint(20)
  • disk_utilization — float(3,1)

snmp_disk_day_info

  • server_ip — varchar(16) — Primary key — NOT NULL
  • polling_time — datetime — Primary key — NOT NULL
  • disk_index — int(11) — Primary key — NOT NULL
  • disk_desc — varchar(100)
  • disk_total_size — bigint(20)
  • disk_used_size — bigint(20)
  • disk_free_size — bigint(20)
  • disk_utilization — float(3,1)

snmp_disk_hour_info

  • server_ip — varchar(16) — Primary key — NOT NULL
  • polling_time — datetime — Primary key — NOT NULL
  • disk_index — int(11) — Primary key — NOT NULL
  • disk_desc — varchar(100)
  • disk_total_size — bigint(20)
  • disk_used_size — bigint(20)
  • disk_free_size — bigint(20)
  • disk_utilization — float(3,1)

snmp_disk_info

  • server_ip — varchar(16) — Primary key — NOT NULL
  • disk_index — int(11) — Primary key — NOT NULL
  • change_time — datetime
  • disk_desc — varchar(100)
  • disk_total_size — bigint(20)
  • disk_used_size — bigint(20)
  • disk_free_size — bigint(20)
  • disk_utilization — float(3,1)

snmp_dmi_hw_info

  • server_ip — varchar(16) — Primary key — NOT NULL
  • hw_handle — int(4) — Primary key — NOT NULL
  • hw_type — int(3) — Primary key — NOT NULL
  • hw_title — varchar(50) — Primary key — NOT NULL
  • hw_item — varchar(50) — Primary key — NOT NULL
  • change_time — datetime — NOT NULL
  • hw_detail — text

snmp_fault_info

  • id — int(11) — Primary key — NOT NULL
  • server_ip — varchar(16) — NOT NULL
  • create_time — datetime — NOT NULL
  • end_time — datetime
  • fault_type — varchar(30)
  • fault_detail — varchar(256)
  • severity — int(11)
  • value — int(11)
  • by_user_id — varchar(20)
  • by_user_name — varchar(20)

snmp_interface_5min_info

  • server_ip — varchar(16) — Primary key — NOT NULL
  • polling_time — datetime — Primary key — NOT NULL
  • if_index — int(3) — Primary key — NOT NULL
  • if_in_octets — bigint(20)
  • if_in_ucast_pkts — bigint(20)
  • if_in_nucast_pkts — bigint(20)
  • if_in_discards — bigint(20)
  • if_in_errors — bigint(20)
  • if_inUnknown_protos — bigint(20)
  • if_out_octets — bigint(20)
  • if_out_ucast_pkts — bigint(20)
  • if_out_nucast_pkts — bigint(20)
  • if_out_discards — bigint(20)
  • if_out_errors — bigint(20)
  • if_in_utilization — float(3,1)
  • if_out_utilization — float(3,1)

snmp_interface_day_info

  • server_ip — varchar(16) — Primary key — NOT NULL
  • polling_time — datetime — Primary key — NOT NULL
  • if_index — int(11) — Primary key — NOT NULL
  • if_in_octets — bigint(20)
  • if_in_ucast_pkts — bigint(20)
  • if_in_nucast_pkts — bigint(20)
  • if_in_discards — bigint(20)
  • if_in_errors — bigint(20)
  • if_inUnknown_protos — bigint(20)
  • if_out_octets — bigint(20)
  • if_out_ucast_pkts — bigint(20)
  • if_out_nucast_pkts — bigint(20)
  • if_out_discards — bigint(20)
  • if_out_errors — bigint(20)
  • if_in_utilization — float(3,1)
  • if_out_utilization — float(3,1)

snmp_interface_hour_info

  • server_ip — varchar(16) — Primary key — NOT NULL
  • polling_time — datetime — Primary key — NOT NULL
  • if_index — int(11) — Primary key — NOT NULL
  • if_in_octets — bigint(20)
  • if_in_ucast_pkts — bigint(20)
  • if_in_nucast_pkts — bigint(20)
  • if_in_discards — bigint(20)
  • if_in_errors — bigint(20)
  • if_inUnknown_protos — bigint(20)
  • if_out_octets — bigint(20)
  • if_out_ucast_pkts — bigint(20)
  • if_out_nucast_pkts — bigint(20)
  • if_out_discards — bigint(20)
  • if_out_errors — bigint(20)
  • if_in_utilization — float(3,1)
  • if_out_utilization — float(3,1)

snmp_interface_info

  • server_ip — varchar(16) — Primary key — NOT NULL
  • if_index — int(11) — Primary key — NOT NULL
  • if_desc — varchar(256)
  • if_type — varchar(256)
  • if_mtu — int(11)
  • if_speed — bigint(20)
  • if_phys_address — varchar(20)
  • if_admin_status — varchar(10)
  • if_oper_status — varchar(10)
  • if_duplex_type — varchar(10)

snmp_interface_temp_info

  • server_ip — varchar(16) — Primary key — NOT NULL
  • polling_time — datetime — Primary key — NOT NULL
  • if_index — int(3) — Primary key — NOT NULL
  • if_in_octets — bigint(20)
  • if_in_ucast_pkts — bigint(20)
  • if_in_nucast_pkts — bigint(20)
  • if_in_discards — bigint(20)
  • if_in_errors — bigint(20)
  • if_inUnknown_protos — bigint(20)
  • if_out_octets — bigint(20)
  • if_out_ucast_pkts — bigint(20)
  • if_out_nucast_pkts — bigint(20)
  • if_out_discards — bigint(20)
  • if_out_errors — bigint(20)

snmp_memory_5min_info

  • server_ip — varchar(16) — Primary key — NOT NULL
  • polling_time — datetime — Primary key — NOT NULL
  • mem_real_total_size — bigint(20)
  • mem_swap_total_size — bigint(20)
  • mem_real_used_size — bigint(20)
  • mem_swap_used_size — bigint(20)
  • mem_real_shared_size — bigint(20)
  • mem_real_buffered_size — bigint(20)
  • mem_real_cached_size — bigint(20)
  • mem_real_utilization — float(3,1)
  • mem_swap_utilization — float(3,1)

snmp_memory_day_info

  • server_ip — varchar(16) — Primary key — NOT NULL
  • polling_time — datetime — Primary key — NOT NULL
  • mem_real_total_size — bigint(20)
  • mem_swap_total_size — bigint(20)
  • mem_real_used_size — bigint(20)
  • mem_swap_used_size — bigint(20)
  • mem_real_shared_size — bigint(20)
  • mem_real_buffered_size — bigint(20)
  • mem_real_cached_size — bigint(20)
  • mem_real_utilization — float(3,1)
  • mem_swap_utilization — float(3,1)

snmp_memory_hour_info

  • server_ip — varchar(16) — Primary key — NOT NULL
  • polling_time — datetime — Primary key — NOT NULL
  • mem_real_total_size — bigint(20)
  • mem_swap_total_size — bigint(20)
  • mem_real_used_size — bigint(20)
  • mem_swap_used_size — bigint(20)
  • mem_real_shared_size — bigint(20)
  • mem_real_buffered_size — bigint(20)
  • mem_real_cached_size — bigint(20)
  • mem_real_utilization — float(3,1)
  • mem_swap_utilization — float(3,1)

snmp_memory_info

  • server_ip — varchar(16) — Primary key — NOT NULL
  • polling_time — datetime — NOT NULL
  • mem_real_total_size — bigint(20)
  • mem_swap_total_size — bigint(20)
  • mem_real_used_size — bigint(20)
  • mem_swap_used_size — bigint(20)
  • mem_real_shared_size — bigint(20)
  • mem_real_buffered_size — bigint(20)
  • mem_real_cached_size — bigint(20)
  • mem_real_utilization — float(3,1)
  • mem_swap_utilization — float(3,1)

snmp_mp_5min_info

  • server_ip — varchar(16) — Primary key — NOT NULL
  • polling_time — datetime — Primary key — NOT NULL
  • mp_name — varchar(50) — Primary key — NOT NULL
  • mp_pid — int(10)
  • mp_cpu_utilization — float(3,1)

snmp_mp_day_info

  • server_ip — varchar(16) — Primary key — NOT NULL
  • polling_time — datetime — Primary key — NOT NULL
  • mp_name — varchar(50) — Primary key — NOT NULL
  • mp_pid — int(10)
  • mp_cpu_utilization — float(3,1)

snmp_mp_hour_info

  • server_ip — varchar(16) — Primary key — NOT NULL
  • polling_time — datetime — Primary key — NOT NULL
  • mp_name — varchar(50) — Primary key — NOT NULL
  • mp_pid — int(10)
  • mp_cpu_utilization — float(3,1)

snmp_mp_info

  • server_ip — varchar(16) — Primary key — NOT NULL
  • mp_name — varchar(50) — Primary key — NOT NULL
  • polling_time — datetime — NOT NULL
  • mp_pid — int(10)
  • mp_status — int(2)
  • mp_cpu_utilization — float(3,1)

snmp_mp_temp_info

  • server_ip — varchar(16) — Primary key — NOT NULL
  • polling_time — datetime — Primary key — NOT NULL
  • mp_name — varchar(50) — Primary key — NOT NULL
  • mp_pid — int(10)
  • mp_status — int(2)
  • mp_cpu_usage — int(10)

snmp_sw_version_info

  • server_ip — varchar(16) — Primary key — NOT NULL
  • sw_name — varchar(50) — Primary key — NOT NULL
  • change_time — datetime — NOT NULL
  • sw_version — varchar(100) — NOT NULL

snmp_system_info

  • server_ip — varchar(16) — Primary key — NOT NULL
  • sys_name — varchar(256)
  • sys_uptime — varchar(256)
  • change_time — datetime
  • sys_desc — varchar(256)
  • sys_contact — varchar(256)
  • sys_location — varchar(256)