CalendarTable table
The CalendarTable table maintains information about the time series calendars used by the database.
When you create a calendar, you insert a row into the CalendarTable table.The CalendarTable table contains seven predefined calendars that you can use instead of creating calendars. You can change a calendar by running an UPDATE statement on a row in the CalendarTable table.
The following table contains the columns in the CalendarTable table.
Column name | Data type | Description |
---|---|---|
c_version | INTEGER | Internal. The version of the calendar. Currently, only version 0 is supported. |
c_refcount | INTEGER | Internal. Counts the number of in-row time series that reference this calendar. The c_refcount column is maintained by the Assign and Destroy functions on TimeSeries. Rules attached to this table allow updates only if c_refcount is 0; this restriction ensures that referential integrity is not violated. |
c_name | VARCHAR(255) | The name of the calendar. |
c_calendar | Calendar | The Calendar type for the calendar. |
c_id | SERIAL | Internal. The serial number of the calendar. |