outbox_manual_retry

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
manual_retry_id uuid 2147483647 null
company_id uuid 2147483647 null
user_account.company_id fk_outbox_manual_retry_actor_company R
event_publication.company_id fk_outbox_manual_retry_event_company R
event_id uuid 2147483647 null
event_publication.event_id fk_outbox_manual_retry_event_company R
idempotency_key_hash varchar 64 null
request_hash varchar 64 null
reason varchar 300 null
requested_by uuid 2147483647 null
user_account.user_id fk_outbox_manual_retry_actor_company R
request_id varchar 128 null
trace_id varchar 32 √ null
previous_attempt_count int4 10 0
accepted_status varchar 30 null
accepted_version int8 19 null
created_at timestamptz 35,6 null

Indexes

Constraint Name Type Sort Column(s)
pk_outbox_manual_retry Primary key Asc manual_retry_id
idx_outbox_manual_retry_company_created Performance Asc/Asc company_id + created_at
idx_outbox_manual_retry_event_created Performance Asc/Asc/Asc company_id + event_id + created_at
uq_outbox_manual_retry_event_key Must be unique Asc/Asc/Asc company_id + event_id + idempotency_key_hash

Check Constraints

Constraint Name Constraint
ck_outbox_manual_retry_status (((accepted_status)::text = 'PENDING'::text))
ck_outbox_manual_retry_request_hash ((char_length((request_hash)::text) = 64))
ck_outbox_manual_retry_request_id (((char_length(TRIM(BOTH FROM request_id)) >= 1) AND (char_length(TRIM(BOTH FROM request_id)) <= 128)))
ck_outbox_manual_retry_trace_id (((trace_id IS NULL) OR (char_length((trace_id)::text) = 32)))
ck_outbox_manual_retry_key_hash ((char_length((idempotency_key_hash)::text) = 64))
ck_outbox_manual_retry_previous_attempt_count ((previous_attempt_count >= 0))
ck_outbox_manual_retry_reason (((char_length(TRIM(BOTH FROM reason)) >= 10) AND (char_length(TRIM(BOTH FROM reason)) <= 300)))
ck_outbox_manual_retry_version ((accepted_version >= 0))

Relationships

Close relationships within degrees of separation