device_values


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('zone.device_values_id_seq'::regclass)
zone_id int4 10 null
device_id int4 10 null
device.id fk_devval_dev C
target bool 1 √ false
known bool 1 √ false
internal bool 1 √ false
trusted bool 1 √ false
forwarder bool 1 √ false
perimeter bool 1 √ false
snmpresponder bool 1 √ false
hasresponses bool 1 √ false
hastraces bool 1 √ false
leakinbound bool 1 √ false
leakoutbound bool 1 √ false
l3hosts int4 10 √ 0
l3peers int2 5 √ 0
l2hosts int4 10 √ 0
l2peers int2 5 √ 0
devicetype text 2147483647 √ null
os text 2147483647 √ null
version text 2147483647 √ null
model text 2147483647 √ null
vendor text 2147483647 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk_devval Primary key Asc id
idx_device_values_devid Performance Asc device_id
uk_devval Must be unique Asc/Asc zone_id + device_id

Relationships

Close relationships within degrees of separation