Footprints Data Model

Table
Name cal_cntnr_item
Comment
The Container Item that is related to the Calendar Appointment Item.  For
Workspaces, the Workspace default calendar will have appointments between Issue
Assignee agents and the Customer Contact in order to resolve the Issue/Workspace
Item.  It is called Container Item in case there is a capability to relate the
appointment to a CMDB item or Knowledgebase Item.

Column
Name Datatype Comment Is PK Is FK
cal_cntnr_item_id bigint The automatically generated primary key of the cal_cntnr_item table. Yes No
item_defn_id bigint
A Foreign Key to the Definition table.  Identifies the Container Definition
which in turn identifies the dynamic object and table that contains the Item. 
This is the first part of a two-part identifier for the dynamic item.
No Yes
item_id bigint
A logical Foreign Key to the Item table. It is an actual primary key in the
dynamic object and table that contains the Item. This is the second part of a
two-part identifier for the dynamic item.
No Yes
appt_cal_item_id bigint
A Foreign Key to the Calendar Item table.  This is an appointment type of item
that has been set up related to the Workspace/Container Item.
No Yes
field_defn_id bigint A Foreign Key to the Definition table. No Yes
is_original bit Indicates if this is the original container for the item. No No
occurence_uid varchar(255) The value of a Calendar Container Item, stored as a string. No No