interface_host


Description

This table contains a list of all interface hosts discovered in a zone. It is parent table that is partitioned over zone schema. For example, interface hosts discovered for zone id 2 will reside in zone_0002.interface_host. device->interface->switchInfo->hosts contains a list of MAC address along with its vlan. Each of these individual entries in the list gets normalized into a record in this table. If MAC address exists in device table, it uses that. If not, a new entry is created in device for this MAC with last update set to layer2-hosts. Entry gets updated when interface switchInfo hosts contains updated response.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
zone_id int4 10 √ null
zone.id fk_ifha_zone R

Zone Id for interface host record.
interface_id int4 10 null
interface.id fk_ifha_intf C

Id of interface that contains this interface host.
device_id int4 10 null
device.id fk_ifha_dev C

Device Id of MAC that is host for this interface.
vlans _int4 10 null

Array of vlans for given interface host. device->interface->switchInfo->vlans gets normalized here.

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk_ifha_pk Primary key Asc/Asc/Asc interface_id + device_id + vlans

Relationships

Close relationships within degrees of separation