Footprints Data Model

Table
Name cal_coll_item
Comment Holds calendar item collection relationships

Column
Name Datatype Comment Is PK Is FK
coll_cal_item bigint A Foreign Key to the Calendar Item table. Yes Yes
cal_item_id bigint A Foreign Key to the Calendar Item table. Yes Yes
create_date bigint
create date, stored as a long integer to avoid using date time classes that do
not handle timezone well.
No No
reln_type varchar(16) The value of a Calendar Collection Item, stored as a string. No No