device_snmpalias


Description

This table contains reference information for all the snmp aliases a device has responded to. It is parent table that is partitioned over zone schema. A device can have as many records as received Unique responses for each profiledata type in this table. One device can have zero to many records.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
zone_id int4 10 null
zone.id fk_device_alias_zone R

Zone Id of a device_snmpalias record. It maps to zone.id
device_id int4 10 null
device.id fk_device_alias_device C

Id of a device this record belongs to. It maps to device.id
snmpalias_id int4 10 null
snmpalias.id fk_device_alias_alias C

Id of a snmpalias this record belongs to. It maps to zone.snmpalias.id
last_update timestamp 29,6 √ now()

The most recent time when a device has responded with given alias. It gets updated with current timestamp everytime a device response is received for an SNMP alias.

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk_device_alias Primary key Asc/Asc device_id + snmpalias_id

Relationships

Close relationships within degrees of separation