Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| email_log_id | serial | 10 | √ | nextval('nrfc.email_log_id_seq'::regclass) |
|
|
Incremental id generated for a submission email log. |
|
| email_id | varchar | 40 | √ | null |
|
|
Identifier for the associated email assigned by CHES (if applicable). |
|
| email_sent_ind | varchar | 1 | √ | null |
|
|
Indicator for whether the email has been sent (‘Y’ for Yes, ‘N’ for No). |
|
| exception_message | text | 2147483647 | √ | null |
|
|
Textual message describing any exceptions that occurred during email processing. |
|
| template_name | varchar | 40 | null |
|
|
Name of the email template used for sending the email. |
||
| email_address | varchar | 100 | null |
|
|
Email address to which the email is sent. |
||
| email_subject | varchar | 100 | null |
|
|
Subject of the email. |
||
| email_variables | jsonb | 2147483647 | √ | null |
|
|
JSONB field to store variables related to the email content. |
|
| create_timestamp | timestamp | 29,6 | CURRENT_TIMESTAMP |
|
|
Timestamp indicating when the email log entry was created. |
||
| update_timestamp | timestamp | 29,6 | √ | CURRENT_TIMESTAMP |
|
|
Timestamp indicating when the email log entry was last updated. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| email_log_id_pk | Primary key | Asc | email_log_id |
Relationships
Close relationships within degrees of separation
