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