Footprints Data Model

Table
Name cal_field
Comment
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.

Column
Name Datatype Comment Is PK Is FK
cal_field_id bigint The automatically generated primary key of the cal_field table. Yes No
attr_type varchar(255) attribute 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
local_name varchar(25) local name. No No
nmsp varchar(220) namespace. No No
binary_val image Object Identifier binary value No No
boolean_val bit generic boolean value. No No
date_val datetime generic date value No No
tz_val varchar(255) time zone value. No No
decimal_val numeric(19,6) generic decimal value No No
text_val varchar(max) The value of a Calendar Field, stored as a long text object. No No
integer_val bigint The value of a Calendar Field stored as Long. No No
string_val varchar(255) string value. No No
cal_item_id bigint A Foreign Key to the Calendar Item table. No Yes