Footprints Data Model

Table
Name cal_ticket
Comment 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.

Column
Name Datatype Comment Is PK Is FK
cal_ticket_id bigint The automatically generated primary key of the cal_ticket table. Yes No
create_date bigint Create date. No No
etag varchar(255) The value of a Calendar Ticket, stored as a string. No No
mdfy_date bigint Change date. No No
creatn_date datetime Create date. No No
ticket_key varchar(255) Authorization id. No No
app_user_id bigint A Foreign Key to the Application User table. No Yes
ticket_timeout varchar(255) Expiration of authority. No No
cal_item_id bigint A Foreign Key to the Calendar Item table. No Yes