document_request_draft

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
draft_id uuid 2147483647 null
document_request_draft_type.draft_id fk_document_request_draft_type_draft C
task_id uuid 2147483647 null
task.task_id fk_document_request_draft_task_company R
company_id uuid 2147483647 null
company.company_id fk_document_request_draft_company R
task.company_id fk_document_request_draft_task_company R
language varchar 20 null
message varchar 1000 √ null
review_status varchar 20 null
created_at timestamptz 35,6 CURRENT_TIMESTAMP
updated_at timestamptz 35,6 CURRENT_TIMESTAMP
version int8 19 0

Indexes

Constraint Name Type Sort Column(s)
pk_document_request_draft Primary key Asc draft_id
idx_document_request_draft_company Performance Asc company_id
uq_document_request_draft_task Must be unique Asc/Asc task_id + company_id

Check Constraints

Constraint Name Constraint
ck_document_request_draft_language_not_blank ((char_length(TRIM(BOTH FROM language)) > 0))
ck_document_request_draft_review_status (((review_status)::text = 'DRAFT'::text))
ck_document_request_draft_updated_at ((updated_at >= created_at))
ck_document_request_draft_version ((version >= 0))

Relationships

Close relationships within degrees of separation