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 |