Footprints Data Model

Table
Table Name Calendar Item
Table Definition The main calendar item table for the calender service. This table is populated and maintained by the Calendar Service API. It is not very suitable for database query outside of the API. The calendar item can be a personal or workspace calendar, or an appointment within the calendar. The calendar item can be synched using the iCal format.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Calendar Item Id The automatically generated primary key of the cal_item table. LONG Yes
Internal Id Internal Id. VARCHAR(255) Yes
item type item type. VARCHAR(16) Yes
create date create date, stored as a long integer to avoid using date time classes that do not handle timezone well. LONG No
etag etag. VARCHAR(255) No
modify date modify date, stored as a long integer to avoid using date time classes that do not handle timezone well. LONG No
client create date client create date, stored as a long integer to avoid using date time classes that do not handle timezone well. LONG No
client modified date client modified date, stored as a long integer to avoid using date time classes that do not handle timezone well. LONG No
display name display name. VARCHAR(255) No
item name item name. VARCHAR(255) Yes
last modification The value of a Calendar Item, stored as a date. INTEGER No
last modified by last modified by. VARCHAR(255) No
needs reply Indicates if needs reply. BOOLEAN No
sent Indicates if sent. BOOLEAN No
ical uid ical uid. VARCHAR(255) No
content encoding content encoding. VARCHAR(32) No
content language content language. VARCHAR(32) No
content length The value of a Calendar Item stored as Long. LONG No
content type content type. VARCHAR(64) No
has modifications Indicates if has modifications. BOOLEAN No
Calendar Content Data Id A Foreign Key to the Calendar Content Data table. LONG No
Application User Id A Foreign Key to the Application User table. LONG No
Modifies Calendar Item Id A Foreign Key to the Calendar Item table. LONG No
Delete Date The value of a Calendar Item, stored as a date. DATE No