device_profiledata


Description

This table contains reference information for all the profiledata/banner a device has responded along with profiledata type (snmp sysDesc, sysObjId, CIFS, http/certificates, tcp/p0f). It is parent table that is partitioned over zone schema. A device can have as many records as received Unique responses for each profiledata type in this table.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
zone_id int4 10 null

Zone Id of a device_profiledata record. It maps to zone.id
device_id int4 10 null
device.id fk_dev_pd_dev C

Id of a device this record belongs to. It maps to device.id
profiledata_id int4 10 null
profiledata.id fk_dev_pd_data C

Id of a profiledata this record refers to. It maps to zone.profiledata.id. One profiledata_id can be shared across multiple devices.
type_id int4 10 null
profiledatatype.id fk_dev_pd_datat C

Id of a profiledata type this record refers to. It maps to zone.profiledatatype.id. Valid values for zone.profiledatatype.type are sysDescr, sysObjectID, tcp, http, cifs.
port int4 10 null

Responding port (where applicable) for profiledata. Set to 0 for profile data types sysDescr, sysObjId and CIFS. Set to -1 for tcp (p0f). Set to the port that responded to this profiledata/banner for profile data type http (certificate)

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk_dev_pd Primary key Asc/Asc/Asc/Asc device_id + profiledata_id + type_id + port
idx_device_profiledata_devicea_id Performance Asc device_id
idx_device_profiledata_profiledata_id Performance Asc profiledata_id
idx_device_profiledata_profiledatatype_id Performance Asc type_id

Relationships

Close relationships within degrees of separation