devices

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
device_id INT UNSIGNED 10 √ null
device_group_device.device_id device_group_device_device_id_foreignC
device_relationships.child_device_id device_relationship_child_device_id_fkC
device_relationships.parent_device_id device_relationship_parent_device_id_fkC
sensors.device_id sensors_device_id_foreignC
wireless_sensors.device_id wireless_sensors_device_id_foreignC
inserted TIMESTAMP 19 √ current_timestamp()
hostname VARCHAR 128 null
sysName VARCHAR 128 √ NULL
ip VARBINARY 16 √ NULL
overwrite_ip VARCHAR 40 √ NULL
community VARCHAR 255 √ NULL
authlevel enum('noAuthNoPriv', 'authNoPriv', 'authPriv') 12 √ NULL
authname VARCHAR 64 √ NULL
authpass VARCHAR 64 √ NULL
authalgo VARCHAR 10 √ NULL
cryptopass VARCHAR 64 √ NULL
cryptoalgo VARCHAR 10 √ NULL
snmpver VARCHAR 4 'v2c'
port SMALLINT UNSIGNED 5 161
transport VARCHAR 16 'udp'
timeout INT 10 √ NULL
retries INT 10 √ NULL
snmp_disable BIT 3 0
bgpLocalAs INT UNSIGNED 10 √ NULL
sysObjectID VARCHAR 128 √ NULL
sysDescr TEXT 65535 √ NULL
sysContact TEXT 65535 √ NULL
version TEXT 65535 √ NULL
hardware TEXT 65535 √ NULL
features TEXT 65535 √ NULL
location_id INT UNSIGNED 10 √ NULL
os VARCHAR 32 √ NULL
status BIT 3 0
status_reason VARCHAR 50 null
ignore BIT 3 0
disabled BIT 3 0
uptime BIGINT 19 √ NULL
agent_uptime INT UNSIGNED 10 0
last_polled TIMESTAMP 19 √ NULL
last_poll_attempted TIMESTAMP 19 √ NULL
last_polled_timetaken DOUBLE 5,2 √ NULL
last_discovered_timetaken DOUBLE 5,2 √ NULL
last_discovered TIMESTAMP 19 √ NULL
last_ping TIMESTAMP 19 √ NULL
last_ping_timetaken DOUBLE 8,2 √ NULL
purpose TEXT 65535 √ NULL
type VARCHAR 20 ''
serial TEXT 65535 √ NULL
icon VARCHAR 255 √ NULL
poller_group INT 10 0
override_sysLocation BIT 3 √ 0
notes TEXT 65535 √ NULL
port_association_mode INT 10 1
max_depth INT 10 0
disable_notify BIT 3 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc device_id
devices_hostname_index Performance Asc hostname
devices_last_poll_attempted_index Performance Asc last_poll_attempted
devices_last_polled_index Performance Asc last_polled
devices_os_index Performance Asc os
devices_status_index Performance Asc status
devices_sysname_index Performance Asc sysName

Relationships

Close relationships within degrees of separation