s_shipment_addr Table (347)
•
Environment: onsite, online
Some tooltip text!
• 4 minutes to read
• 4 minutes to read
Addresses that are ready to be sent in a shipment.
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| id | Primary key | PK | |
| shipment_id | Which shipment this address belongs to | FK s_shipment | |
| address | The email address | String(255) | |
| name | The name of the recipient | String(255) | ● |
| timestamp | A stamp set when this address it taken by ejSender to prevent two ejSenders to take one address. | Int | ● |
| customer_id | Id of the customer if this entry is created by a dynamic list | FK person | |
| type | Indicates if this is an email or a sms | Int | ● |
| sender_nr | Used for multiple ejSenders. This field indicate which ejSender process this belongs to | Int | ● |
| ticket_id | Id of the ticket if this entry is created by a ticketSelection list | FK ticket | |
| status | Status for sending to this particular recipient | Enum ShipmentAddrStatus | ● |
| contact_id | Id of contact bound to shipment address | FK contact | ● |
| sending_time | Estimated or actual sent time (depends on status) | DateTime | ● |
| bounce_reason | Reason text received from mailing system | String(1023) | ● |
| form_submission_id | If this mailing recipient is created from a form submission, this will contain a reference to that submission | FK form_submission | ● |
| bounce_code | If this recipient bounced and we have a bounce code, this field will contain the code | Int | ● |
| bounce_reasontag | If this recipient bounced and we have a bounce reason, this field will contain the reason | String(4000) | ● |
| cleaned | Used for indicating that a bounced recipient row has been cleaned, and now will not be presented again in the cleaning list | Bool | ● |
| workflow_step_id | The row was created by this workflow step | FK workflow_step | ● |
| workflow_instance_id | The row was created by this workflow instance | FK workflow_instance | ● |
| Status | ID | Comment |
|---|---|---|
| Unknown | 0 | Default value for empty rows |
| Ready | 1 | Ready for shipment |
| Duplicate | 2 | Blocked because it duplicates another shipment addr in the same batch |
| Blocked | 3 | Blocked because of nomailing flag |
| Sent | 4 | Sent |
| Bounced | 5 | Bounce received from transport channel |
| Opened | 6 | Recipient has opened the message, we know because of tracking |
| Clicked | 7 | Recipient has actively clicked a link in the message |
| SoftBounced | 8 | Vacation notice, etc |
| NoSubscription | 9 | Recipient does not have subscription for shipmentType |
| Complained | 10 | Recipient sent a complaint |
| TooManyBounces | 11 | Recipient address has bounced too many times |
Indexes
| Fields | Types | Description |
|---|---|---|
| id | PK | Clustered, Unique |
| shipment_id | FK | Index |
| address | String(255) | Index |
| customer_id | FK | Index |
| ticket_id | FK | Index |
| contact_id | FK | Index |
| status, shipment_id | Enum, FK | Index |
| workflow_instance_id | FK | Index |
| workflow_step_id | FK | Index |
Relationships
| Table | Description |
|---|---|
| contact | Companies and Organizations. |
| form_submission | A form submission |
| person | Persons |
| s_shipment | Contains info about one shipment. The addresses are stored in s_shipment_addr |
| ticket | This table contains the tickets (requests) of the system. Its purpose should be evident. |
| workflow_instance | A set of properties related to the workflow instance of one participant going through the flow |
| workflow_step | A set of steps related to a workflow. |
Replication Flags
- None
Security Flags
- No access control via user's Role.