Columns
Table | Type | Column | Type | Size | Nulls | Auto | Default | Comments |
---|---|---|---|---|---|---|---|---|
pattern_attribute | Table | attribute_id | int4 | 10 | null | |||
type | Table | type | text | 2147483647 | null | |||
patterns | View | expression | text | 2147483647 | √ | null | ||
pattern | Table | patternsource_id | int4 | 10 | null | |||
patternsource | Table | source | text | 2147483647 | null | |||
patterns | View | patternsource_id | int4 | 10 | √ | null | ||
patternsource | Table | id | serial | 10 | √ | nextval('profile.patternsource_id_seq'::regclass) | ||
patterns | View | pattern_id | int4 | 10 | √ | null | ||
pattern_attribute | Table | confidence | int4 | 10 | null | |||
pattern | Table | timestamp | timestamp | 29 | √ | transaction_timestamp() | ||
pattern_attribute | Table | type_id | int4 | 10 | null | |||
pattern | Table | id | serial | 10 | √ | nextval('profile.pattern_id_seq'::regclass) | ||
pattern | Table | organization_id | int4 | 10 | √ | null | ||
patterns | View | source | text | 2147483647 | √ | null | ||
pattern | Table | userdefined | bool | 1 | √ | false | ||
type | Table | id | serial | 10 | √ | nextval('profile.type_id_seq'::regclass) | ||
pattern | Table | expression | text | 2147483647 | √ | null | ||
pattern | Table | lastupdate | timestamp | 29 | √ | transaction_timestamp() | ||
attribute | Table | id | serial | 10 | √ | nextval('profile.attribute_id_seq'::regclass) | zone_id for attribute record |
|
attribute | Table | attribute | text | 2147483647 | null | Id of user that is performing this operation. |
||
pattern_attribute | Table | priority | int4 | 10 | null | |||
pattern | Table | attributetype_id | int4 | 10 | √ | null | ||
pattern_attribute | Table | pattern_id | int4 | 10 | null | |||
patterns | View | array_agg | _text | 2147483647 | √ | null |