Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
zone_id | int4 | 10 | null |
|
|
Zone Id of a device_match record. zone.device_match table is a parent table for all partitioned (by zone_id) zone_xxx.device_match tables. It maps to zone.id column |
||||
device_id | int4 | 10 | null |
|
|
Id of a device this attribute belongs to. It maps to device.id |
||||
pattern_id | int4 | 10 | null |
|
|
Id of pattern that contains a match for given profile type record. It maps to profile.pattern.id |
||||
type_id | int4 | 10 | null |
|
|
Id of a profile type for given match record. It maps to profile.type. Valid values for profile.type are Device Type, OS, Model, Version, Vendor |
||||
attribute_id | int4 | 10 | null |
|
|
Id of an attribute/value for given match record. It maps to profile.attribute. All values for profile.attribute comes from pattern->attribute value of patterns.xml |
||||
confidence | int4 | 10 | null |
|
|
Confidence for any given match record. It is derived from profile.pattern_attribute for matching pattern_id and type_id. It is stored in device_match to make fetching profile information avoiding lookup against pattern_attribute. |
Table contained 0 rows
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
pk_device_match | Primary key | Asc/Asc | device_id + type_id |
idx_device_match_attribute_id | Performance | Asc | attribute_id |
idx_device_match_device_id | Performance | Asc | device_id |
idx_device_match_type_id | Performance | Asc | type_id |