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