task_evidence

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
evidence_id uuid 2147483647 null
task_id uuid 2147483647 null
task.task_id fk_task_evidence_task_company R
company_id uuid 2147483647 null
user_account.company_id fk_task_evidence_actor_company R
task.company_id fk_task_evidence_task_company R
evidence_type varchar 30 null
file_reference varchar 300 √ null
note varchar 500 √ null
recorded_by uuid 2147483647 null
user_account.user_id fk_task_evidence_actor_company R
recorded_at timestamptz 35,6 null
created_at timestamptz 35,6 null

Indexes

Constraint Name Type Sort Column(s)
pk_task_evidence Primary key Asc evidence_id
idx_task_evidence_task Performance Asc/Asc/Asc company_id + task_id + recorded_at
uq_task_evidence_id_task_company Must be unique Asc/Asc/Asc evidence_id + task_id + company_id

Check Constraints

Constraint Name Constraint
ck_task_evidence_type ((evidence_type)::text = ANY ((ARRAY['DOCUMENT'::character varying, 'RECEIPT'::character varying, 'OFFICIAL_RESULT'::character varying, 'HR_CONFIRMATION'::character varying])::text[]))
ck_task_evidence_content (((file_reference IS NOT NULL) AND (char_length(TRIM(BOTH FROM file_reference)) > 0)) OR ((note IS NOT NULL) AND (char_length(TRIM(BOTH FROM note)) > 0)))
ck_task_evidence_created_at (created_at >= recorded_at)

Relationships

Close relationships within degrees of separation