Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int8 | 19 | √ | null |
|
|
||||||||||||||
| format | varchar | 64 | null |
|
|
|||||||||||||||
| source_filename | text | 2147483647 | √ | null |
|
|
||||||||||||||
| source_uri | text | 2147483647 | √ | null |
|
|
||||||||||||||
| source_sha256 | bpchar | 64 | null |
|
|
|||||||||||||||
| importer_version | int4 | 10 | null |
|
|
|||||||||||||||
| imported_at | timestamptz | 35,6 | now() |
|
|
|||||||||||||||
| input_item_count | int4 | 10 | null |
|
|
|||||||||||||||
| accepted_rule_count | int4 | 10 | null |
|
|
|||||||||||||||
| rejected_rule_count | int4 | 10 | null |
|
|
|||||||||||||||
| metadata | jsonb | 2147483647 | '{}'::jsonb |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| autopagerize_dataset_pkey | Primary key | Asc | id |
| autopagerize_dataset_identity_key | Must be unique | Asc/Asc/Asc | format + source_sha256 + importer_version |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| autopagerize_dataset_counts_check | ((input_item_count >= 0) AND (accepted_rule_count >= 0) AND (rejected_rule_count >= 0) AND ((accepted_rule_count + rejected_rule_count) = input_item_count)) |
| autopagerize_dataset_source_sha256_check | (source_sha256 ~ '^[0-9a-f]{64}$'::text) |
| autopagerize_dataset_format_check | ((format)::text = 'wedata-autopagerize-items-all'::text) |