> ## 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_message table > A message used in a shipment. Can be html and/or plain text ## s\_message Table (335) A message used in a shipment. Can be html and/or plain text ## Fields | Name | Description | Type | Nullable | | ------------------------- | ------------------------------------------------------------------------------------------------------------------------ | ----------------------------------------------------------- | :------: | | id | Primary key | PK | No | | plain\_message | Plain message text of this message | Clob | Yes | | html\_message | HTML formatted text of this message | Clob | Yes | | sms\_message | SMS version of this message | Clob | Yes | | description | Describes this message | String(255) | Yes | | subject | The mail subject field of the message | String(255) | Yes | | header\_field | Extra header fields added to mail. Must be formatted correctly | Clob | Yes | | flags | Identifies if HTML or plain message is included in message. | Enum [ShipmentMessageType](./enums/shipmentmessagetype.mdx) | No | | folder\_id | The folder which this message belongs to. -1 indicates that the message is on the root | Int | No | | inline\_images | Should images be included inline? | Bool | Yes | | register\_views | Register message views? | Bool | Yes | | access\_key | Key used for access verification | String(255) | Yes | | registered | Registered when | UtcDateTime | Yes | | registered\_associate\_id | Registered by whom | FK [associate](./associate.mdx) | Yes | | updated | Last updated when | UtcDateTime | Yes | | updated\_associate\_id | Last updated by whom | FK [associate](./associate.mdx) | Yes | | updatedCount | Number of updates made to this record | UShort | Yes | | document\_message | The SM document used as template for this mailing | FK [document](./document.mdx) | Yes | | long\_description | A field for a long description of this template | String(4000) | Yes | | design | Will contain the design part of a message. The format will vary based on the type of designer used to create the message | Clob | Yes | | designtype | Enum containing the type of the design | Enum [DesignType](./enums/designtype.mdx) | No | s_message table relationship diagram ## Indexes | Fields | Types | Description | | ------ | ----- | ----------- | ## Relationships | Table | Description | | ------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | [associate](./associate) | Employees, resources and other users - except for External persons | | [document](./document) | Documents, this table is an extension of the Appointment table. There is always a corresponding appointment record; the relation between appointment and document is navigable in both directions. A document-type appointment record always has a corresponding document record and a record in VisibleFor specifying who may see this. | | [email\_flow](./email-flow) | A set of properties related to the email workflow. | | [email\_flow\_content\_link](./email-flow-content-link) | Links content to an email workflow | | [external\_document](./external-document) | This table stores documents which can be viewed externaly, through the customer module | | [s\_attachment](./s-attachment) | A connector between a message and attachments. One message can contain many attachments. | | [s\_link](./s-link) | Links in messages to measure success rate of a campaign. | | [s\_sent\_message](./s-sent-message) | Emarketeer message control | | [s\_shipment](./s-shipment) | Contains info about one shipment. The addresses are stored in s\_shipment\_addr | ## Replication Flags * None ## Security Flags * No access control via user's Role. ## Related topics - [s_sent_message table](/en/database/tables/s-sent-message.md) - [s_messageblock table](/en/database/tables/s-messageblock.md) - [external_document table](/en/database/tables/external-document.md) - [s_attachment table](/en/database/tables/s-attachment.md) - [email_flow_content_link table](/en/database/tables/email-flow-content-link.md) - [email_flow table](/en/database/tables/email-flow.md)