worker_import_row

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
import_row_id uuid 2147483647 null
import_id uuid 2147483647 null
worker_import_job.import_id fk_worker_import_row_job_company C
company_id uuid 2147483647 null
worker_import_job.company_id fk_worker_import_row_job_company C
worker.company_id fk_worker_import_row_worker_company R
row_number int4 10 null
source_values_json text 2147483647 null
override_values_json text 2147483647 null
normalized_values_json text 2147483647 null
validation_errors_json text 2147483647 null
status varchar 20 null
worker_id uuid 2147483647 √ null
worker.worker_id fk_worker_import_row_worker_company R
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null
version int8 19 0

Indexes

Constraint Name Type Sort Column(s)
pk_worker_import_row Primary key Asc import_row_id
idx_worker_import_row_job_status Performance Asc/Asc/Asc/Asc company_id + import_id + status + row_number
uq_worker_import_row_id_company Must be unique Asc/Asc import_row_id + company_id
uq_worker_import_row_number Must be unique Asc/Asc import_id + row_number

Check Constraints

Constraint Name Constraint
ck_worker_import_row_worker_status (((((status)::text = 'COMMITTED'::text) AND (worker_id IS NOT NULL)) OR (((status)::text <> 'COMMITTED'::text) AND (worker_id IS NULL))))
ck_worker_import_row_time_order ((updated_at >= created_at))
ck_worker_import_row_number ((row_number >= 2))
ck_worker_import_row_version ((version >= 0))
ck_worker_import_row_status (((status)::text = ANY ((ARRAY['PENDING'::character varying, 'VALID'::character varying, 'INVALID'::character varying, 'EXCLUDED'::character varying, 'COMMITTED'::character varying])::text[])))

Relationships

Close relationships within degrees of separation