certificatepath_pattern


Description

This table contains mapping for certificatepath to pattern. 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 the certificatepath_pattern record
certificatepath_id int4 10 null
certificatepath.id fk_certpath_pattern_certpath C

Id of certificatepath that this certificatepath matches. It maps to zone.certificatepath.id
pattern_id int4 10 null
pattern.id fk_certpath_pattern_pattern C

Id of pattern that this certificatepath matches. It maps to profile.pattern.id

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk_certpath_pattern Primary key Asc/Asc certificatepath_id + pattern_id

Relationships

Close relationships within degrees of separation