worker_archive

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
worker_id uuid 2147483647 null
worker.worker_id fk_worker_archive_worker_company R
company_id uuid 2147483647 null
user_account.company_id fk_worker_archive_actor_company R
worker.company_id fk_worker_archive_worker_company R
archived_at timestamptz 35,6 null
archived_by uuid 2147483647 null
user_account.user_id fk_worker_archive_actor_company R
archive_reason varchar 500 null
worker_version int8 19 null

Indexes

Constraint Name Type Sort Column(s)
pk_worker_archive Primary key Asc worker_id
idx_worker_archive_company_time Performance Asc/Desc/Asc company_id + archived_at + worker_id
uq_worker_archive_worker_company Must be unique Asc/Asc worker_id + company_id

Check Constraints

Constraint Name Constraint
ck_worker_archive_worker_version ((worker_version > 0))
ck_worker_archive_reason_not_blank ((char_length(TRIM(BOTH FROM archive_reason)) > 0))

Relationships

Close relationships within degrees of separation