Footprints Data Model

Table
Name cal_stamp
Comment
Calendar Item has a set of Calendar Stamp objects. A Calendar stamp can be
associated to a single Calendar Item . A stamp associates a related set of
properties/attributes/methods to an Calendar Item. This is different from
Calendar Attribute , which generally represents a single value. For example
Event Stamp , contains properties and apis relating to an event and MessageStamp
contains properties related to an email message. The stamp model allows items to
be stamped and unstamped with these related sets of properties throughout its
life-cycle.

Column
Name Datatype Comment Is PK Is FK
cal_stamp_id bigint The automatically generated primary key of the cal_stamp table. Yes No
stamp_type varchar(16) stamp 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
cal_item_id bigint A Foreign Key to the Calendar Item table. No Yes