interface


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('zone.interface_id_seq'::regclass)
interface_address.interface_id fk_ifaddr_intf_intf C
interface_host.interface_id fk_ifha_intf C
interface_route.interface_id fk_intf_route_interface C
zone_id int4 10 null
iftable_id int4 10 null
iftable.id fk_interface_tbl R
infhash text 2147483647 √ null
indconthash text 2147483647 √ null
physicaladdress macaddr 2147483647 √ null
index int4 10 √ null
port int4 10 √ null
vlan int4 10 √ null
voicevlan int4 10 √ null
vlans _int4 10 √ null
trunk bool 1 √ null
rootport bool 1 √ null
description text 2147483647 √ null
name text 2147483647 √ null
alias text 2147483647 √ null
adminstatus int4 10 √ null
opstatus int4 10 √ null
iftype int4 10 √ null
bridge macaddr 2147483647 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
interface_pkey Primary key Asc id
idx_interface_bridge Performance Asc bridge
idx_interface_indconthash Performance Asc indconthash
idx_interface_infhash Performance Asc infhash
idx_interface_physaddr Performance Asc physicaladdress
idx_interface_tblidx Performance Asc/Asc iftable_id + index

Relationships

Close relationships within degrees of separation