profiledata


Description

This table contains a Unique copy of the profile data in a zone. That is to say that if we had 20 devices with the same banner or sysDescr we would have one copy here and it would be referenced from zone.device_profiledata. p0f, cifs, snmp and httpbanners responses go in this table. It is parent table that is partitioned over zone schema.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('zone.profiledata_id_seq'::regclass)
device_profiledata.profiledata_id fk_dev_pd_data C
profiledata_pattern.profiledata_id fk_pd_pattern_pd C
zone_id int4 10 null
zone.id fk_profiledata_zone R
type_id int4 10 null
profiledatatype.id fk_profiledata_type R
hash text 2147483647 null

MD5 hash of the (normalized) data column
data text 2147483647 null

The normalized profile data. At least converted to lower case and non printable characters are deleted or escaped.
rawdata text 2147483647 null

The raw (unnormalized) profile data
timestamp timestamp 29,6 √ transaction_timestamp()

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk_profiledata Primary key Asc id
idx_profiledata_typehash Performance Asc/Asc type_id + hash

Relationships

Close relationships within degrees of separation