iftable


Description

This table contains a list of all interface tables discovered in a zone. It also contains an entry for device level routes. It is parent table that is partitioned over zone schema. For example, interface tables discovered for zone id 2 will reside in zone_0002.iftable

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('zone.iftable_id_seq'::regclass)
device.iftable_id fk_device_iftable R
iftable_vlan.iftable_id fk_iftvl_ift R
interface.iftable_id fk_interface_tbl R

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

Zone Id for interface table entry
hash text 2147483647 null

A hash that uniquely identifes an interface table. It is constructed by concatenating all interface->physicaladdresses and interface->index with | and creating a hash out of it. For an incoming response, if a record with identity hash does not exist, new entry is inserted in iftable. If an entry is inserted while processing device level routes, hash is set to "device:"
contenthash text 2147483647 null

Content hash of interface data that is constructed by concatenating interface index, description, name, alias, adminstatus, opstatus, physical address, addresses, vlan, voicevlan, switchinto port, switchinfo rootport, switchinfo trunkport, switchinfo vlans, switchinfo hosts acrosss all incoming interface infomation. It is used to perform a check to decide if any further update on interface is needed or not. For an incoming response, if a hash in iftable machtes with response's hash but contenthash doesn't match, ( Any of the attributes that calculates content hash has changed since last time we got response ) appropariate updates to iftable, interface and interface_hosts are made, else that procesing is skipped. Contenthash will be empty when iftable entry represents device level route processing.
bridgeaddress macaddr 2147483647 √ null

Bridge address of an interface table. It is normalized from device->bridgeAddress. It will be null when iftable entry represents device level route processing.
iphash text 2147483647 √ null

Not being used.

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk_iftable Primary key Asc id
idx_iftable_hash Performance Asc hash
uk_iftable Must be unique Asc/Asc zone_id + hash

Relationships

Close relationships within degrees of separation