Footprints Data Model

Table
Table Name Calendar Field
Table Definition A name/value data field value for a calendar item. Calendar Item has a map of Attribute objects, indexed by a QName . An Attribute can be associated to a single Item . QName is a composite key that represents a qualified name (namespace and local name). There are several Attribute implementations (String, Binary, Integer, etc) that are used to store different types of values. The polymorphic mapping allows any number of and any mix of Attribute implementations to be associated to an item.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Calendar Field Id The automatically generated primary key of the cal_field table. LONG Yes
attribute type attribute type. VARCHAR(255) Yes
create date create date, stored as a long integer to avoid using date time classes that do not handle timezone well. LONG No
etag etag. VARCHAR(255) No
modify date modify date, stored as a long integer to avoid using date time classes that do not handle timezone well. LONG No
local name local name. VARCHAR(25) Yes
namespace namespace. VARCHAR(220) Yes
binary value Object Identifier binary value OID No
boolean value generic boolean value. BOOLEAN No
date value generic date value DATE No
tz value time zone value. VARCHAR(255) No
decimal value generic decimal value NUMERIC(19,6) No
text value The value of a Calendar Field, stored as a long text object. TEXT No
integer value The value of a Calendar Field stored as Long. LONG No
string value string value. VARCHAR(255) No
Calendar Item Id A Foreign Key to the Calendar Item table. LONG Yes