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 |