s_shipment_addr Table (347)
• 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 | ● |
| 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 |
Relationships
| Table | Description |
|---|---|
| contact | Companies and Organizations. This table features a special record containing information about the contact that owns the database. |
| form_submission | A form submission |
| person | Persons in a company or an organizations. All associates have a corresponding person record |
| 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. |
Replication Flags
- None
Security Flags
- No access control via user's Role.