Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| submission_id | bigserial | 19 | √ | nextval('tbl_ingestion_submissions_submission_id_seq'::regclass) |
|
|
|||||
| submitted_by | int4 | 10 | null |
|
|
||||||
| title | text | 2147483647 | √ | null |
|
|
|||||
| status | text | 2147483647 | 'DRAFT'::text |
|
|
||||||
| ux_level_used | text | 2147483647 | √ | null |
|
|
|||||
| ux_config_json | jsonb | 2147483647 | '{}'::jsonb |
|
|
||||||
| payload_schema_version | int4 | 10 | 1 |
|
|
||||||
| payload_json | jsonb | 2147483647 | '{}'::jsonb |
|
|
||||||
| validation_json | jsonb | 2147483647 | '{}'::jsonb |
|
|
||||||
| published_entity_refs | jsonb | 2147483647 | √ | null |
|
|
|||||
| reviewed_by | int4 | 10 | √ | null |
|
|
|||||
| reviewed_at | timestamptz | 35,6 | √ | null |
|
|
|||||
| review_note | text | 2147483647 | √ | null |
|
|
|||||
| created_at | timestamptz | 35,6 | now() |
|
|
||||||
| updated_at | timestamptz | 35,6 | now() |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| tbl_ingestion_submissions_pkey | Primary key | Asc | submission_id |
| idx_ingestion_submissions_reviewed_by | Performance | Asc | reviewed_by |
| idx_ingestion_submissions_status_created | Performance | Asc/Desc | status + created_at |
| idx_ingestion_submissions_submitted_by_created | Performance | Asc/Desc | submitted_by + created_at |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| chk_tbl_ingestion_submissions_ux_level_used | ((ux_level_used IS NULL) OR (ux_level_used = ANY (ARRAY['minimal'::text, 'enhanced'::text, 'advanced'::text, 'custom'::text]))) |
| chk_tbl_ingestion_submissions_status | (status = ANY (ARRAY['DRAFT'::text, 'SUBMITTED'::text, 'IN_REVIEW'::text, 'CHANGES_REQUESTED'::text, 'PUBLISHED'::text, 'REJECTED'::text])) |