Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | √ | nextval('controlshift_consent_mappings_id_seq'::regclass) |
|
|
|||||
| controlshift_consent_id | int8 | 19 | null |
|
|
||||||
| consent_text_id | int8 | 19 | null |
|
|
||||||
| method | varchar | 2147483647 | null |
|
|
||||||
| opt_in_level | varchar | 2147483647 | null |
|
|
||||||
| opt_in_option | varchar | 2147483647 | null |
|
|
||||||
| opt_out_level | varchar | 2147483647 | null |
|
|
||||||
| opt_out_option | varchar | 2147483647 | null |
|
|
||||||
| created_at | timestamp | 29,6 | null |
|
|
||||||
| updated_at | timestamp | 29,6 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| controlshift_consent_mappings_pkey | Primary key | Asc | id |
| idx_ctrlshift_consents_on_ctrlshift_consent_and_consent_text | Must be unique | Asc/Asc | controlshift_consent_id + consent_text_id |
| index_controlshift_consent_mappings_on_consent_text_id | Performance | Asc | consent_text_id |
| index_controlshift_consent_mappings_on_controlshift_consent_id | Performance | Asc | controlshift_consent_id |
Relationships
Close relationships within degrees of separation
