> ## 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_messageblock table

> Contains a block of a mailing message, that can be reused in a mailing

## s\_messageblock Table (499)

Contains a block of a mailing message, that can be reused in a mailing

## Fields

| Name                      | Description                                                  | Type                            | Nullable |
| ------------------------- | ------------------------------------------------------------ | ------------------------------- | :------: |
| s\_messageblock\_id       | Primary key                                                  | PK                              |    No    |
| block                     | The block definition. Normally this will be a json structure | Clob                            |    Yes   |
| associateId               | The associate that owns this block                           | FK [associate](./associate.mdx) |    Yes   |
| registered                | Registered when                                              | UtcDateTime                     |    No    |
| registered\_associate\_id | Registered by whom                                           | FK [associate](./associate.mdx) |    No    |
| updated                   | Last updated when                                            | UtcDateTime                     |    No    |
| updated\_associate\_id    | Last updated by whom                                         | FK [associate](./associate.mdx) |    No    |
| updatedCount              | Number of updates made to this record                        | UShort                          |    No    |

<img src="https://mintcdn.com/superofficeas/8-OIGQQJR0VGDXy_/media/loc/en/database/tables/s_messageblock.png?fit=max&auto=format&n=8-OIGQQJR0VGDXy_&q=85&s=5f149c53be8949613b40461d5146e2ac" alt="s_messageblock table relationship diagram" width="458" height="59" data-path="media/loc/en/database/tables/s_messageblock.png" />

## Indexes

| Fields | Types | Description |
| ------ | ----- | ----------- |

## Relationships

| Table                    | Description                                                        |
| ------------------------ | ------------------------------------------------------------------ |
| [associate](./associate) | Employees, resources and other users - except for External persons |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.


## Related topics

- [Released database changes in version 9.8.7717.1401](/release-notes/database/changes-9.2.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)
- [What's new in version 10.2.1.1517](/release-notes/database/changes-10.2.1.md)
- [What's new in version 10.2.6.1248](/release-notes/database/changes-10.2.6.md)
- [What's new in version 10.2.7.5452](/release-notes/database/changes-10.2.7.md)