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 |