Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| content_header_id | bpchar | 32 | null |
|
|
||||||
| content_full_text_id | bpchar | 32 | null |
|
|
||||||
| relative_path | text | 2147483647 | null |
|
|
||||||
| file_size_bytes | int8 | 19 | null |
|
|
||||||
| file_sha256 | bpchar | 64 | null |
|
|
||||||
| exported_at | timestamptz | 35,6 | now() |
|
|
||||||
| created_at | timestamptz | 35,6 | now() |
|
|
||||||
| updated_at | timestamptz | 35,6 | now() |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| content_text_file_export_pkey | Primary key | Asc | content_header_id |
| content_text_file_export_exported_at_idx | Performance | Asc | exported_at |
| content_text_file_export_full_text_key | Must be unique | Asc | content_full_text_id |
| content_text_file_export_relative_path_key | Must be unique | Asc | relative_path |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| content_text_file_export_relative_path_txt_check | (relative_path ~ '^[0-9a-f]{32}\.txt$'::text) |
| content_text_file_export_file_size_check | (file_size_bytes >= 0) |
| content_text_file_export_relative_path_no_directory_check | (relative_path !~ '/'::text) |
| content_text_file_export_relative_path_not_absolute_check | (relative_path !~ '^/'::text) |