Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('precheckin_legal_document_id_seq'::regclass) |
|
|
|||||
| doc_type | varchar | 20 | null |
|
|
||||||
| lang_code | varchar | 5 | null |
|
|
||||||
| version | varchar | 10 | '1.0'::character varying |
|
|
||||||
| title | text | 2147483647 | √ | null |
|
|
|||||
| content_html | text | 2147483647 | null |
|
|
The terms (doc_type=terms) row seeded by this patch is placeholder copy pending legal review; it did not exist as real content before this patch. |
|||||
| is_translated | bool | 1 | true |
|
|
||||||
| is_active | bool | 1 | true |
|
|
||||||
| create_at | timestamp | 29,6 | √ | CURRENT_TIMESTAMP |
|
|
|||||
| update_at | timestamp | 29,6 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| precheckin_legal_document_pkey | Primary key | Asc | id |
| precheckin_legal_document_doc_type_lang_code_version_key | Must be unique | Asc/Asc/Asc | doc_type + lang_code + version |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| precheckin_legal_document_doc_type_check | ((doc_type)::text = ANY ((ARRAY['terms'::character varying, 'privacy'::character varying])::text[])) |
Relationships
Close relationships within degrees of separation
