s_shipment_addr Table (347)
Addresses that are ready to be sent in a shipment.Fields
| Name | Description | Type | Nullable |
|---|---|---|---|
| id | Primary key | PK | No |
| shipment_id | Which shipment this address belongs to | FK s_shipment | No |
| address | The email address | String(255) | No |
| name | The name of the recipient | String(255) | Yes |
| timestamp | A stamp set when this address it taken by ejSender to prevent two ejSenders to take one address. | Int | Yes |
| customer_id | Id of the customer if this entry is created by a dynamic list | FK person | No |
| type | Indicates if this is an email or a sms | Int | Yes |
| sender_nr | Used for multiple ejSenders. This field indicate which ejSender process this belongs to | Int | Yes |
| ticket_id | Id of the ticket if this entry is created by a ticketSelection list | FK ticket | No |
| status | Status for sending to this particular recipient | Enum ShipmentAddrStatus | Yes |
| contact_id | Id of contact bound to shipment address | FK contact | Yes |
| sending_time | Estimated or actual sent time (depends on status) | DateTime | Yes |
| bounce_reason | Reason text received from mailing system | String(1023) | Yes |
| form_submission_id | If this mailing recipient is created from a form submission, this will contain a reference to that submission | FK form_submission | Yes |
| bounce_code | If this recipient bounced and we have a bounce code, this field will contain the code | Int | Yes |
| bounce_reasontag | If this recipient bounced and we have a bounce reason, this field will contain the reason | String(4000) | Yes |
| cleaned | Used for indicating that a bounced recipient row has been cleaned, and now will not be presented again in the cleaning list | Bool | Yes |
| workflow_step_id | The row was created by this workflow step | FK workflow_step | Yes |
| workflow_instance_id | The row was created by this workflow instance | FK workflow_instance | Yes |
| owner_lock | A guid to set when trying to send to that address, to ensure no other ejsender also try to send it | String(255) | Yes |
Indexes
| Fields | Types | Description |
|---|---|---|
| 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.