Footprints Data Model

Table
Table Name Calendar Collection Item
Table Definition Holds calendar item collection relationships

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Collection Calendar item A Foreign Key to the Calendar Item table. LONG Yes
Calendar Item Id A Foreign Key to the Calendar Item table. LONG Yes
create date create date, stored as a long integer to avoid using date time classes that do not handle timezone well. LONG No
Relation Type The value of a Calendar Collection Item, stored as a string. VARCHAR(16) No