queuedemail


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
osoitteet_haku_and_hakutulos_id uuid 2147483647 √ null
osoitteet_haku_and_hakutulos.id queuedemail_osoitteet_haku_and_hakutulos_id_fkey R
queuedemailstatus_id text 2147483647 null
queuedemailstatus.id queuedemail_queuedemailstatus_id_fkey R
recipients _text 2147483647 null
replyto text 2147483647 √ null
subject text 2147483647 null
body text 2147483647 null
lahetystunniste text 2147483647 √ null
created timestamp 29,6 CURRENT_TIMESTAMP
modified timestamp 29,6 CURRENT_TIMESTAMP
copy text 2147483647 √ null
last_attempt timestamp 29,6 √ null
sent_at timestamp 29,6 √ null
attachment_ids _text 2147483647 √ null
batch_sent int4 10 0
idempotency_key uuid 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
queuedemail_pkey Primary key Asc id

Check Constraints

Constraint Name Constraint
recipients_required ((recipients <> '{}'::text[]))
sent_at_requires_status_sent ((((queuedemailstatus_id = 'SENT'::text) AND (sent_at IS NOT NULL)) OR (queuedemailstatus_id <> 'SENT'::text)))
sent_has_to_have_lahetystunniste ((((queuedemailstatus_id = 'SENT'::text) AND (lahetystunniste IS NOT NULL)) OR (queuedemailstatus_id <> 'SENT'::text)))

Relationships

Close relationships within degrees of separation