device


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('zone.device_id_seq'::regclass)
device.device_id fk_device_device R
device_attribute.device_id fk_devattr_dev C
device_certificate.device_id fk_dev_cert_dev C
device_cloudalias.device_id fk_device_cloud_alias_device C
device_match.device_id fk_device_match_device C
device_pattern.device_id fk_device_pattern_device C
device_ports.device_id fk_device_ports_device C
device_profiledata.device_id fk_dev_pd_dev C
device_response.device_id fk_device_response_device C
device_snmpalias.device_id fk_device_alias_device C
device_values.device_id fk_devval_dev C
device_wmialias.device_id fk_device_wmi_alias_device C
interface_host.device_id fk_ifha_dev C
link.device_id1 fk_link_dev1 C
link.device_id2 fk_link_dev2 C
target.device_id fk_target_device C
target_highpriority.device_id fk_target_hp_device C
zone_id int4 10 null
device_id int4 10 √ null
device.id fk_device_device R
iftable_id int4 10 √ null
iftable.id fk_device_iftable R
meta bool 1 √ false
ip inet 2147483647 √ null
mac macaddr 2147483647 √ null
macvendor_id int4 10 √ null
macvendor.id fk_device_macvendor N
identity text 2147483647 √ null
lastupdate text 2147483647 √ null
active bool 1 √ null
firstobserved timestamp 29,6 √ now()
lastobserved timestamp 29,6 √ now()
maclastobserved timestamptz 35,6 √ null
enterprise_id int4 10 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk_device Primary key Asc id
idx_device_iftable_id Performance Asc iftable_id
idx_device_macvendor_id Performance Asc macvendor_id
idx_zone_device_devid Performance Asc device_id
idx_zone_device_enterprise_id Performance Asc enterprise_id
idx_zone_device_ident Performance Asc identity
idx_zone_device_ip Performance
idx_zone_device_ipr Performance
idx_zone_device_mac Performance Asc mac
uk_device_ident Must be unique Asc/Asc meta + identity
uk_device_ipv4 Must be unique Asc/Asc meta + ip

Relationships

Close relationships within degrees of separation