interface


Description

This table contains a list of all interfaces discovered in a zone. It is parent table that is partitioned over zone schema. Example: Interface records discovered for zone id 2 will reside in zone_0002.interface. Please note: for interface entry that is recorded as part of device level route processing gets an Interface Index of 0 and an interface description of "unassociated routes 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

Unique identifier for interfacetable record.
zone_id int4 10 null
zone.id fk_interface_zone R

Zone Id for interface entry.
iftable_id int4 10 null
iftable.id fk_interface_tbl R
physicaladdress macaddr 2147483647 √ null

Physical address of interface. It is normalized from device->interface->physicalAddress.
index int4 10 √ null

Index of interface. It is normalized from device->interface->index.
port int4 10 √ null

Port of interface. It is normalized from device->interface->switchInfo->port.
vlan int4 10 √ null

Vlan of interface. It is normalized from device->interface->vlan as well as device->interface->switchInfo->vlans. If switchInfo contains vlan, it will use that instead of interface->vlan.
voicevlan int4 10 √ null
vlans _int4 10 √ null
trunk bool 1 √ null

Trunk of interface. It is normalized from device->interface->switchInfo->trunkPort.
rootport bool 1 √ null

Rootport of interface. It is normalized from device->interface->index->switchInfo->rootPort.
description text 2147483647 √ null

Description of interface. It is normalized from device->interface->description.
name text 2147483647 √ null

Name of interface. It is normalized from device->interface->name.
alias text 2147483647 √ null

Alias of interface. It is normalized from device->interface->alias.
adminstatus int4 10 √ null

AdminStatus of interface. It is normalized from device->interface->adminStatus.
opstatus int4 10 √ null

Optstatus of interface. It is normalized from device->interface->opstatus.
bridge macaddr 2147483647 √ null

Bridge of interface. It is normalized from device->interface->switchInfo->bridge.

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_physaddr Performance Asc physicaladdress
idx_interface_tblidx Performance Asc/Asc iftable_id + index

Relationships

Close relationships within degrees of separation