route


Description

This table contains unique routes that have been discovered for a zone. It also stores metadata for routes indicating whether they are targeted, known, internal or eligible. 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.route_id_seq'::regclass)
interface_route.route_id fk_intf_route_route C
target.route_id fk_target_route C
target_highpriority.route_id fk_target_hp_route C

Unique identifier for route record
zone_id int4 10 null
zone.id fk_route_zone R

Zone Id for route record. It maps to system.zone.id
route cidr 2147483647 √ null

CIDR value for route
target bool 1 √ null

Boolean indicating if given route is in targeted CIDR list for any collectors of this zone. Targeted CIDR list represents CIDRs set in Discovery Spaces => Target List table. Set to true if it is targeted, false otherwise
known bool 1 √ null

Boolean indicating if given route is in known CIDR list for this zone. Known CIDR list represents CIDRs set in Zone Networks => Known List. Set to true if it is known, false otherwise
internal bool 1 √ null

Boolean indicating if given route is in internal CIDR list for this zone. Internal CIDR list represents CIDRs set in Zone Networks => Internal List.Set to true if it is internal, false otherwise
trusted bool 1 √ null

Boolean indicating if given route is in eligible CIDR list for this zone. Eligible CIDR list represents CIDRs set in Zone Networks => Eligible List.Set to true if it is eligible, false otherwise
last_update timestamp 29,6 √ now()

Timestamp when this route record was created/updated

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk_route Primary key Asc id
idx_zone_route_route Performance Asc route
idx_zone_route_route_ipr Performance
uk_route_route Must be unique Asc route

Relationships

Close relationships within degrees of separation