target


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('zone.target_id_seq'::regclass)
target_highpriority.target_id fk_target_hp_target C
zone_id int4 10 null
collector_id int4 10 null
collector.id fk_target_collector C
device_id int4 10 √ null
device.id fk_target_device C
route_id int4 10 √ null
route.id fk_target_route C
cidr_id int4 10 √ null
attribute_cidr.id fk_target_cidr C
cidrval cidr 2147483647 null
scantype_id int4 10 null
scantype.id fk_target_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 Primary key Asc id
idx_target_cidr Performance
idx_target_cidr_id Performance Asc cidr_id
idx_target_colcidr Performance Asc/Asc collector_id + cidrval
idx_target_colcidrst Performance Asc/Asc/Asc collector_id + scantype_id + cidrval
idx_target_collt Performance Asc/Asc collector_id + last_target
idx_target_colordid Performance Asc/Asc collector_id + ordid
idx_target_colscancidr_gist Performance Asc/Asc collector_id + scantype_id
idx_target_device_id Performance Asc device_id
idx_target_route_id Performance Asc route_id
idx_target_scantype_id Performance Asc scantype_id
uk_target Must be unique Asc/Asc/Asc/Asc cidrval + collector_id + zone_id + scantype_id

Relationships

Close relationships within degrees of separation