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 |
|
|
|||||
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 |