target_highpriority


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('zone.target_highpriority_id_seq'::regclass)
target_id int4 10 √ null
target.id fk_target_hp_target C
zone_id int4 10 null
zone.id fk_target_hp_zone R
collector_id int4 10 null
collector.id fk_target_hp_collector C
device_id int4 10 √ null
device.id fk_target_hp_device C
route_id int4 10 √ null
route.id fk_target_hp_route C
cidr_id int4 10 √ null
attribute_cidr.id fk_target_hp_cidr C
cidrval cidr 2147483647 null
scantype_id int4 10 null
scantype.id fk_target_hp_scantype R
details text 2147483647 √ null
last_target timestamp 29,6 √ null
batchid int4 10 √ null
ordid float4 8,8 √ random()
expandedconfig text 2147483647 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk_target_hp Primary key Asc id
idx_target_hp_cidr Performance
idx_target_hp_colcidr Performance Asc/Asc collector_id + cidrval
idx_target_hp_colcidrst Performance Asc/Asc/Asc collector_id + scantype_id + cidrval
idx_target_hp_collt Performance Asc/Asc collector_id + last_target
idx_target_hp_colordid Performance Asc/Asc collector_id + ordid
idx_target_hp_colscancidr_gist Performance Asc/Asc collector_id + scantype_id

Relationships

Close relationships within degrees of separation