worker_document_upload_idempotency

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
worker_link_id uuid 2147483647 null
worker_link.worker_link_id fk_worker_document_upload_idempotency_link_company R
client_request_id varchar 100 null
stored_file_id uuid 2147483647 null
stored_file.stored_file_id fk_worker_document_upload_idempotency_file_company R
created_at timestamptz 35,6 CURRENT_TIMESTAMP
company_id uuid 2147483647 null
worker_link.company_id fk_worker_document_upload_idempotency_link_company R
stored_file.company_id fk_worker_document_upload_idempotency_file_company R
idempotency_key_hash varchar 64 √ null
request_hash varchar 64 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_worker_document_upload_idempotency Primary key Asc/Asc worker_link_id + client_request_id
idx_worker_document_upload_idempotency_company Performance Asc company_id
idx_worker_document_upload_idempotency_file_company Performance Asc/Asc stored_file_id + company_id
uq_worker_document_upload_idempotency_key_hash Must be unique Asc/Asc worker_link_id + idempotency_key_hash

Check Constraints

Constraint Name Constraint
ck_worker_document_upload_idempotency_key_hash (((idempotency_key_hash IS NULL) OR (char_length((idempotency_key_hash)::text) = 64)))
ck_worker_document_upload_idempotency_hash_pair ((((idempotency_key_hash IS NULL) AND (request_hash IS NULL)) OR ((idempotency_key_hash IS NOT NULL) AND (request_hash IS NOT NULL))))
ck_worker_document_upload_idempotency_request_hash (((request_hash IS NULL) OR (char_length((request_hash)::text) = 64)))

Relationships

Close relationships within degrees of separation