link


Description

This table contains Link information for both layer2 and layer3. Layer3 links are discovered through pathDiscovery (traces) as well as OSPF discovery. Layer2 links are discovered through SNMP discovery. It is parent table that is partitioned over zone schema.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('zone.link_id_seq'::regclass)

Unique identifier for link record
zone_id int4 10 null
zone.id fk_link_zone R

Zone Id for link record
linkset_id int4 10 null
linkset.id fk_link_set R

Linkset Id for link record. It maps to zone.linkset.id. It identifies whether this link is host or node and whether it is representing layer2 link or layer3 link
device_id1 int4 10 null
device.id fk_link_dev1 C

From Device Id for link record. It maps to zone.device.id.
device_id2 int4 10 null
device.id fk_link_dev2 C

To Device Id for link record. It maps to zone.device.id.
last_update timestamp 29,6 √ now()

Timestamp when this record was created/updated

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk_link Primary key Asc id
idx_link_linkset_id Performance Asc linkset_id
idx_zone_link_d1 Performance Asc device_id1
idx_zone_link_d1d2 Performance Asc/Asc device_id1 + device_id2
idx_zone_link_d2 Performance Asc device_id2
uk_link_devs Must be unique Asc/Asc/Asc/Asc zone_id + linkset_id + device_id1 + device_id2

Relationships

Close relationships within degrees of separation