company

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
company_id uuid 2147483647 null
ai_run.company_id fk_ai_run_company R
audit_event.company_id fk_audit_event_company R
company_settings.company_id fk_company_settings_company C
document_request_draft.company_id fk_document_request_draft_company R
event_publication.company_id fk_event_publication_company R
stored_file.company_id fk_stored_file_company R
task.company_id fk_task_company R
user_account.company_id fk_user_account_company R
worker.company_id fk_worker_company R
worker_import_job.company_id fk_worker_import_job_company R
worker_link.company_id fk_worker_link_company R
worker_response.company_id fk_worker_response_company R
workflow_case.company_id fk_workflow_case_company R
name varchar 120 null
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_company Primary key Asc company_id

Check Constraints

Constraint Name Constraint
ck_company_updated_at ((updated_at >= created_at))
ck_company_name_not_blank ((char_length(TRIM(BOTH FROM name)) > 0))
ck_company_status (((status)::text = ANY ((ARRAY['ACTIVE'::character varying, 'SUSPENDED'::character varying, 'DISABLED'::character varying])::text[])))
ck_company_version ((version >= 0))

Relationships

Close relationships within degrees of separation