interface


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('system.interface_id_seq'::regclass)
collector.externaldnsinterface_id fk_collector_extdnsintf N
collector.interface_id fk_collector_intf N
collector.leakinterface_id fk_collector_leakintf N
name text 2147483647 null
config text 2147483647 √ null
type text 2147483647 √ null
packetrate int4 10 1000
active bool 1 √ null
system_id int4 10 null
system.id fk_interface_system C
address macaddr 2147483647 √ null
ipv4 inet 2147483647 √ null
ipv6 inet 2147483647 √ null
ospf_enabled bool 1 √ null
ospf_area int4 10 √ null
ospf_authtype int4 10 √ null
ospf_auth text 2147483647 √ null
ospf_router_id inet 2147483647 √ null

Table contained 3 rows

Indexes

Constraint Name Type Sort Column(s)
pk_interface Primary key Asc id
uk_interface Must be unique Asc/Asc system_id + name

Relationships

Close relationships within degrees of separation