attribute_cidr


Description

This table contains all the CIDRs for each collector that are either system defined or user configured (custom attributes). 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.attribute_cidr_id_seq'::regclass)
target.cidr_id fk_target_cidr C
target_highpriority.cidr_id fk_target_hp_cidr C

Unique identifier for attribute_cidr record
zone_id int4 10 null
zone.id fk_attrcidr_zone R

Zone Id for attribute_cidr record
cidrval cidr 2147483647 null

CIDR value for attribute_cidr record
collector_id int4 10 √ null
collector.id fk_attrcidr_collector R

Collector Id. Maps to system.collector.id
attributetype_id int4 10 null
attributetype.id fk_attrcidr_attrtype R

Id of attribute type. Maps to system.attributetype.id
attribute_id int4 10 √ null
attribute.id fk_attrcidr_attr R

Id of attribute value. Maps to zone.attribute.id
hasresponses bool 1 √ false

Boolean flag set to true or false indicating if CIDR (in cidrval column) contains any device that has any responses recorded. Set to true if there is any entry in device_response for any device containing this CIDR record, false otherwise
timestamp timestamp 29,6 √ now()

Timestamp when this record was created/updated.

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk_attrcidr Primary key Asc id
idx_zone_attribute_cidr_ipr Performance
uk_attrcidr Must be unique Asc/Asc/Asc/Asc cidrval + collector_id + attributetype_id + attribute_id

Relationships

Close relationships within degrees of separation