external_submission

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
external_submission_id uuid 2147483647 null
task_id uuid 2147483647 null
task.task_id fk_external_submission_task_company R
company_id uuid 2147483647 null
user_account.company_id fk_external_submission_actor_company R
task.company_id fk_external_submission_task_company R
destination varchar 160 null
safe_reference varchar 300 null
submitted_by uuid 2147483647 null
user_account.user_id fk_external_submission_actor_company R
submitted_at timestamptz 35,6 null
created_at timestamptz 35,6 null

Indexes

Constraint Name Type Sort Column(s)
pk_external_submission Primary key Asc external_submission_id
idx_external_submission_task Performance Asc/Asc/Asc company_id + task_id + submitted_at
uq_external_submission_id_task_company Must be unique Asc/Asc/Asc external_submission_id + task_id + company_id

Check Constraints

Constraint Name Constraint
ck_external_submission_created_at (created_at >= submitted_at)
ck_external_submission_destination_not_blank (char_length(TRIM(BOTH FROM destination)) > 0)
ck_external_submission_reference_not_blank (char_length(TRIM(BOTH FROM safe_reference)) > 0)

Relationships

Close relationships within degrees of separation