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