Calendars

Contains individual calendar entries associated with users. Each record represents a calendar that can be used for scheduling events, setting reminders, and tracking availability.

テーブル固有の情報

Select

Id を指定するかすべてを選択することで、Calendars をクエリできます。

SELECT * FROM Calendars WHERE Id = 'your Calendar Id goes here'

エンティティから特定のカラムを選択して、そのカラムでフィルタします。

SELECT Name FROM Calendars WHERE Name LIKE 'John Calendar%'

Note：AlwaysRequstTableDependencies 接続プロパティを指定、あるいは参照CalendarGroupId で選択またはフィルタリングしない限り、CalendarGroupId の値はNull のままです。

Insert

新しいCalendar を作成するには、Name を最低限に指定します。

INSERT INTO Calendars (Name) VALUES ('John')

Columns


Name	Type	ReadOnly	Description
calendarGroupId	String	False	Unique identifier of the calendar group to which this calendar belongs. This helps organize multiple calendars under a single group for easier management.
canEdit	Bool	False	Indicates whether the current user has permissions to modify the contents of this calendar, such as adding or updating events.
canShare	Bool	False	Specifies whether the calendar can be shared with other users, allowing collaboration or visibility into scheduling.
id [KEY]	String	False	Unique identifier of the calendar. This value is used to reference the calendar in API calls and database queries.
canViewPrivateItems	Bool	False	Indicates whether the user has access to view private events or entries within the calendar, which are normally hidden.
changeKey	String	False	Version identifier for the calendar object. It changes every time the calendar is updated, ensuring synchronization and conflict resolution.
color	String	False	Represents the display color assigned to the calendar, typically used in calendar views to distinguish it visually from others.
name	String	False	The display name of the calendar. This name is shown in user interfaces and helps users recognize the calendar's purpose.
owner_name	String	False	The full name of the person or entity that owns the calendar. This is typically used for display purposes in shared calendar contexts.
owner_address	String	False	The email address of the calendar owner. This helps identify the calendar source and enables calendar sharing or integration.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。