nackcandidate


Description

This table will hold any device that has ever received a response, for non-host / non-path ScanTypes. Any time a response is received for non-host/non-path scantypes for a device, an entry will get inserted in this table for responding ip, collector_id, scantype_id, zone_id Any time a NACK response is received for a device, an entry will get deleted from this table that matches ip, collector_id, scantype_id and zone_id of incoming NACK response. All the matching entries for a collector_id will be deleted when a collector gets archived Table will be truncated when either a zone gets deleted, or the NACK configuration parameter gets turned off.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('zone.nackcandidate_id_seq'::regclass)
zone_id int4 10 null
zone.id fk_nackcandidate_zone R
collector_id int4 10 null
scantype_id int4 10 null
ip inet 2147483647 √ null
mac macaddr 2147483647 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
idx_nackcandidate_ip Performance
uk_nackcandidate Must be unique Asc/Asc/Asc/Asc ip + zone_id + collector_id + scantype_id

Relationships

Close relationships within degrees of separation