Footprints Data Model

Table
Name cal_item
Comment 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.

Column
Name Datatype Comment Is PK Is FK
cal_item_id bigint The automatically generated primary key of the cal_item table. Yes No
intrnl_id varchar(255) Internal Id. No No
item_type varchar(16) item type. No No
create_date bigint create date, stored as a long integer to avoid using date time classes that do not handle timezone well. No No
etag varchar(255) etag. No No
mdfy_date bigint modify date, stored as a long integer to avoid using date time classes that do not handle timezone well. No No
client_create_date bigint client create date, stored as a long integer to avoid using date time classes that do not handle timezone well. No No
client_mod_date bigint client modified date, stored as a long integer to avoid using date time classes that do not handle timezone well. No No
display_name varchar(255) display name. No No
item_name varchar(255) item name. No No
last_modf int The value of a Calendar Item, stored as a date. No No
last_mod_by varchar(255) last modified by. No No
needs_reply bit Indicates if needs reply. No No
sent bit Indicates if sent. No No
ical_uid varchar(255) ical uid. No No
content_encoding varchar(32) content encoding. No No
content_language varchar(32) content language. No No
content_length bigint The value of a Calendar Item stored as Long. No No
content_type varchar(64) content type. No No
has_modfs bit Indicates if has modifications. No No
cal_content_data_id bigint A Foreign Key to the Calendar Content Data table. No Yes
modifies_cal_item_id bigint A Foreign Key to the Calendar Item table. No No
app_user_id bigint A Foreign Key to the Application User table. No Yes
delete_date datetime The value of a Calendar Item, stored as a date. No No