pattern


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('profile.pattern_id_seq'::regclass)
pattern_attribute.pattern_id fk_pattern_attr_pattern R
certificatepath_pattern.pattern_id fk_certpath_pattern_pattern C
macvendor_pattern.pattern_id fk_macvendor_pattern_pattern C
profiledata_pattern.pattern_id fk_pd_pattern_pattern C
patternsource_id int4 10 null
patternsource.id fk_pattern_source R
organization_id int4 10 √ null
organization.id fk_pattern_org R
userdefined bool 1 √ false
expression text 2147483647 √ null
timestamp timestamp 29,6 √ transaction_timestamp()
lastupdate timestamp 29,6 √ transaction_timestamp()

Table contained 4587 rows

Indexes

Constraint Name Type Sort Column(s)
pk_pattern Primary key Asc id
idx_pattern_patternsource_id Performance Asc patternsource_id
idx_pattern_userdefined Performance Asc userdefined
uk_pattern Must be unique Asc/Asc/Asc expression + patternsource_id + organization_id

Relationships

Close relationships within degrees of separation