Footprints Data Model

Table
Table Name Calendar Ticket
Table Definition This is unrelated and different than an ITSM ticket. See the Calendar Container Item table for ITSM tickets. A calendar ticket is an authorization object that grants some level of access to a calendar item and its descendents based on a unique ticket key. If a client has this key, then the client can gain access to the item and its descendants with the ticket key. May not be used in the FootPrints integration of calendaring code, because the calendar permissions are subordinate to the application security model.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Calendar Ticket Id The automatically generated primary key of the cal_ticket table. LONG Yes
Create Date Create date. LONG Yes
etag The value of a Calendar Ticket, stored as a string. VARCHAR(255) No
Modify Date Change date. LONG No
Creation Date Create date. DATE No
Ticket Key Authorization id. VARCHAR(255) Yes
Application User Id A Foreign Key to the Application User table. LONG No
Ticket Timeout Expiration of authority. VARCHAR(255) No
Calendar Item Id A Foreign Key to the Calendar Item table. LONG No