attribute_cidr


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
zone_id int4 10 null
cidrval cidr 2147483647 null
collector_id int4 10 √ null
collector.id fk_attrcidr_collector R
attributetype_id int4 10 null
attributetype.id fk_attrcidr_attrtype R
attribute_id int4 10 √ null
attribute.id fk_attrcidr_attr R
hasresponses bool 1 √ false
timestamp timestamp 29,6 √ now()

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