Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
id | serial | 10 | √ | nextval('zone.device_response_id_seq'::regclass) |
|
|
Unique identifier for device response record |
|||
zone_id | int4 | 10 | null |
|
|
Zone Id of a device_response record. It maps to zone.id |
||||
collector_id | int4 | 10 | null |
|
|
Collector Id of a device this record belongs to. It maps to system.collector.id |
||||
device_id | int4 | 10 | null |
|
|
Id of a device this record belongs to. It maps to device.id |
||||
protocol_id | int4 | 10 | null |
|
|
Protocol Id of a device this record belongs to. It maps to zone.protocol.id |
||||
scantype_id | int4 | 10 | null |
|
|
Scan Type Id of a device this record belongs to. It maps to zone.scantype.id |
||||
ports | _int4 | 10 | √ | null |
|
|
List of ports (if any) that constituted this response. For example, for cifs response, it will be set to 445, for host response coming from dns, it will be set to 53. This column is only populated for httpDetails, hostDiscovery and cifs. Device->response->ports get normalized in this column. It contains all the list of ports a device has received response from for a given scan type and protocol at any given point in time. |
|||
time | timestamptz | 35,6 | √ | null |
|
|
Time when a device response was received for given scan type and protocol. |
|||
vlan | int4 | 10 | √ | null |
|
|
Table contained 0 rows
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
pk_device_response | Primary key | Asc | id |
idx_device_response_collector_id | Performance | Asc | collector_id |
idx_device_response_devid | Performance | Asc | device_id |
idx_device_response_devst | Performance | Asc/Asc | scantype_id + device_id |
idx_device_response_protocol_id | Performance | Asc | protocol_id |
idx_device_response_scantype_id | Performance | Asc | scantype_id |
uk_device_response | Must be unique | Asc/Asc/Asc/Asc/Asc | zone_id + device_id + protocol_id + collector_id + scantype_id |