Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| c_pk | int8 | 19 | null |
|
|
|||
| c_created | timestamp | 29,6 | √ | null |
|
|
||
| c_created_by | varchar | 255 | √ | null |
|
|
||
| c_updated_by | varchar | 255 | √ | null |
|
|
||
| c_updated | timestamp | 29,6 | √ | null |
|
|
||
| c_ol | int8 | 19 | √ | null |
|
|
||
| c_pid | varchar | 255 | null |
|
|
|||
| c_def_value | varchar | 4096 | √ | null |
|
|
||
| c_description | varchar | 255 | √ | null |
|
|
||
| c_from_file | bool | 1 | √ | null |
|
|
||
| c_group_name | varchar | 36 | √ | null |
|
|
||
| c_key | varchar | 60 | null |
|
|
|||
| c_max_value | varchar | 4096 | √ | null |
|
|
||
| c_min_value | varchar | 4096 | √ | null |
|
|
||
| c_owner | varchar | 60 | √ | null |
|
|
||
| c_scope | varchar | 255 | null |
|
|
|||
| c_type | varchar | 36 | null |
|
|
|||
| c_current_value | varchar | 4096 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| cor_pref_preference_pkey | Primary key | Asc | c_pk |
| uc_preference | Must be unique | Asc/Asc | c_key + c_owner |
| ukrc8pmokt0idroxr3uchecospu | Must be unique | Asc | c_pid |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| cor_pref_preference_c_scope_check | ((c_scope)::text = ANY ((ARRAY['APPLICATION'::character varying, 'MODULE'::character varying, 'ROLE'::character varying, 'USER'::character varying])::text[])) |