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

# RecurrenceRule table

> The recurrency pattern for a recurring event. Each recurring event has an appointment.recurrenceRuleId pointing to its pattern.

## RecurrenceRule Table (207)

The recurrency pattern for a recurring event. Each recurring event has an appointment.recurrenceRuleId pointing to its pattern.

## Fields

| Name                      | Description                                                      | Type                                                          | Nullable |
| ------------------------- | ---------------------------------------------------------------- | ------------------------------------------------------------- | :------: |
| RecurrenceRule\_id        | Primary key                                                      | PK                                                            |    No    |
| pattern                   | Recurrence pattern (daily, weekly etc)                           | Enum [RecurrencePattern](./enums/recurrencepattern.mdx)       |    No    |
| subPattern                | Subpattern (workday, everyday, weekday etc)                      | Enum [RecurrenceSubPattern](./enums/recurrencesubpattern.mdx) |    No    |
| weekdays                  | Weekdays used, bitmask based on  ERecurrenceWeekDays enumeration | UShort                                                        |    No    |
| startDate                 | Start date for repetition pattern                                | DateTime                                                      |    No    |
| endDate                   | End date for repetition pattern                                  | DateTime                                                      |    No    |
| cyclicDay                 | Every nth day, in cyclic patterns                                | UShort                                                        |    No    |
| cyclicWeek                | Every nth week, in cyclic patterns                               | UShort                                                        |    No    |
| cyclicMonth               | Every nth month, in cyclic patterns                              | UShort                                                        |    No    |
| 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/3ZhivzBeXAvFeVZx/media/loc/en/database/tables/RecurrenceRule.png?fit=max&auto=format&n=3ZhivzBeXAvFeVZx&q=85&s=12ef3eaa2d0e2e85a607a38593949bdf" alt="RecurrenceRule table relationship diagram" width="706" height="59" data-path="media/loc/en/database/tables/RecurrenceRule.png" />

## Indexes

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

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

* Area Management controlled table. Contents replicated to satellites and traveller databases.
* Replicate changes UP from satellites and travellers back to central.
* Copy to satellite and travel prototypes.

## Security Flags

* No access control via user's Role.


## Related topics

- [Working with follow-ups (appointments) in API](/en/diary/dev/index.md)
- [Enum values for RecurrencePattern](/en/database/tables/enums/recurrencepattern.md)
- [Enum values for RecurrenceSubPattern](/en/database/tables/enums/recurrencesubpattern.md)
- [SuperOffice.WebApi.Data.RecurrencePattern](/en/api/reference/webapi/SuperOffice.WebApi.Data.RecurrencePattern.md)
- [appointment table](/en/database/tables/appointment.md)
- [Get follow-ups belonging to a series](/en/automation/crmscript/howto/diary/get-appointments-in-series.md)