profiledata_pattern


Description

This table contains mapping of profile data to patterns. It is parent table that is partitioned over zone schema.

Columns

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

Zone Id for profiledata_pattern record. It maps to system.zone.id

profiledata_id int4 10 null
profiledata.id fk_pd_pattern_pd C

Profiledata Id for profiledata_pattern record. It maps to zone.profiledata.id

pattern_id int4 10 null
pattern.id fk_pd_pattern_pattern C

Pattern Id for profiledata_pattern record. It maps to profile.pattern.id

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk_pd_pattern Primary key Asc/Asc profiledata_id + pattern_id

Relationships