profiledata


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
type_id int4 10 null
profiledatatype.id fk_profiledata_type R
hash text 2147483647 null
data text 2147483647 null
rawdata text 2147483647 null
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