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.

Table 1. 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.