> ## 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.

# invitation table

> Invitations to events

## invitation Table (496)

Invitations to events

## Fields

| Name                      | Description                                                                                                                                     | Type                                | Nullable |
| ------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------- | ----------------------------------- | :------: |
| invitation\_id            | Primary key                                                                                                                                     | PK                                  |    No    |
| event\_uid                | The UID associated with this event, all integrators should refer to this UID when referring to the event                                        | String(255)                         |    Yes   |
| event\_sequence           | The current sequence number of the event info, so we know if we got a new or old event update                                                   | Int                                 |    Yes   |
| event\_dtstamp            | DTSTAMP so we know if we got a new or old event update when sequence is the same                                                                | DateTime                            |    Yes   |
| appointment\_id           | The id of the mother appointment record                                                                                                         | FK [appointment](./appointment.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    |
| organizer\_email          | The email address of the organizer of the event.                                                                                                | String(255)                         |    Yes   |
| organizer\_fullname       | The organizer's full name                                                                                                                       | String(255)                         |    Yes   |
| recurring\_end\_date      | The end date for a recurring event                                                                                                              | DateTime                            |    Yes   |
| recurring\_start\_date    | The start date for a recurring event                                                                                                            | DateTime                            |    Yes   |
| template\_language        | The SO-language used for email invitations (see PhysicalDocument.GetTemplateLanguages(), CultureDataFormatter.MapCultureToSuperOfficeLanguage() | String(16)                          |    Yes   |

<img src="https://mintcdn.com/superofficeas/6OcOTPa_ISkjXJg4/media/loc/en/database/tables/invitation.png?fit=max&auto=format&n=6OcOTPa_ISkjXJg4&q=85&s=8379c2981afa9ed9e326817c4d16d001" alt="invitation table relationship diagram" width="651" height="59" data-path="media/loc/en/database/tables/invitation.png" />

## Indexes

| Fields          | Types       | Description |
| --------------- | ----------- | ----------- |
| event\_uid      | String(255) | Index       |
| appointment\_id | FK          | Index       |

## Relationships

| Table                        | Description                                                                                                                                                                 |
| ---------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| [appointment](./appointment) | Tasks, appointments, followups, phone calls; and documents (document\_id != 0). An appointment always has a corresponding record in VisibleFor specifying who may see this. |
| [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

- [Invitation](/en/api/archive-providers/reference/invitation.md)
- [appointment table](/en/database/tables/appointment.md)
- [Save With Custom Invitation](/en/api/reference/restful/agent/appointment_agent/save-with-custom-invitation.md)
- [How to create an invitation (services)](/en/api/web-services/howto/diary/create-invitation-services.md)
- [What's new in version 10.3.9.718](/release-notes/database/changes-10.3.9.md)
- [What's new in version 10.5.1.1092](/release-notes/database/changes-10.5.1.md)