> ## Documentation Index > Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt > Use this file to discover all available pages before exploring further. # s_shipment_addr table > Addresses that are ready to be sent in a shipment. ## 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](./s-shipment.mdx) | 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](./person.mdx) | 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](./ticket.mdx) | No | | status | Status for sending to this particular recipient | Enum [ShipmentAddrStatus](./enums/shipmentaddrstatus.mdx) | Yes | | contact\_id | Id of contact bound to shipment address | FK [contact](./contact.mdx) | 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](./form-submission.mdx) | 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](./workflow-step.mdx) | Yes | | workflow\_instance\_id | The row was created by this workflow instance | FK [workflow\_instance](./workflow-instance.mdx) | 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 | s_shipment_addr table relationship diagram ## 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](./contact) | Companies and Organizations. | | [form\_submission](./form-submission) | A form submission | | [person](./person) | Persons | | [s\_shipment](./s-shipment) | Contains info about one shipment. The addresses are stored in s\_shipment\_addr | | [ticket](./ticket) | This table contains the tickets (requests) of the system. Its purpose should be evident. | | [workflow\_instance](./workflow-instance) | A set of properties related to the workflow instance of one participant going through the flow | | [workflow\_step](./workflow-step) | A set of steps related to a workflow. | ## Replication Flags * None ## Security Flags * No access control via user's Role. ## Related topics - [s_shipment table](/en/database/tables/s-shipment.md) - [s_bounce_shipment table](/en/database/tables/s-bounce-shipment.md) - [s_list_shipment table](/en/database/tables/s-list-shipment.md) - [ShipmentType table](/en/database/tables/shipmenttype.md) - [What's new in version 10.1.2.686](/release-notes/database/changes-10.1.2.md) - [What's new in version 10.1.5](/release-notes/database/changes-10.1.5.md)