s_shipment_addr Table (347)
• 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
Security Flags
- No access control via user's Role.