A recurring event is an description of a recurring pattern of events. One recurring event will result in a series of events, called recurring occurrences.
A pattern is used to describe the recurring event. Crontab is supported but other pattern types may be supported in the future.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| recurring_event_oid | varchar(20) | not null | Unique identity for the recurring event |
| start | integer | not null | Start time in epoch of the recurring event |
| expire | integer | with null | Expiry time in epoch of the recurring event. If NULL, the recurring event does not expire. |
| duration | integer | not null | Durations in seconds, of one recuring occurrence for this recurrring event series. |
| description | nvarchar(255) | not null | Description of all occurrences for this recurring event series. |
| value | nvarchar(255) | with null | Value of the event |
| timezone | varchar(50) | with null | Time zone id used to parse the pattern |
| pattern | varchar(255) | not null | Pattern of the recurring event, parsed by the patter type scheduler. |
| calendar_oid | varchar(20) | with null | The calendar oid to which the recurring event belongs |
| pattern_type_oid | varchar(20) | with null | The pattern type used to parse the recurring events |
| event_category_oid | varchar(20) | with null | The event category to which occurrences of this recurring event belongs. |
| event_category_value_oid | varchar(20) | with null | Unique identity of the event category value |
Product Name: Unicenter Service Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| recurring_event_oid | usm_event_category_value | recurring_event_oid |
| recurring_event_oid | usm_sm_event | recurring_event_oid |
| recurring_event_oid | usm_onetime_event | recurring_event_oid |
| recurring_event_oid | usm_service_event | recurring_event_oid |