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)