Footprints Data Model

Table
Table Name Calendar Container Item
Table Definition 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.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Calendar Container Item Id The automatically generated primary key of the cal_cntnr_item table. LONG Yes
Item Definition Id 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. LONG Yes
Item Id 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. LONG Yes
Appointment Calendar Item Id 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. LONG Yes
Field Definition Id A Foreign Key to the Definition table. LONG No
Is Original Indicates if this is the original container for the item. BOOLEAN No
Occurence UID The value of a Calendar Container Item, stored as a string. VARCHAR(255) No