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