| Table: dbo.Login_Ticket | |||
| Single-use login tickets which can be used in lieu of a password for authentication. | |||
| Columns | |||
| Name | Type | Constraints | Description |
| staff_KEY | int (4) | NOT NULL | The staff that can be logged in using this ticket. |
| ticket_guid | uniqueidentifier (16) | NOT NULL | An identifier for the ticket, randomly generated. |
| expires_utc | datetime (8, 3) | NOT NULL | A timestamp after which the ticket should be considered invalid and can be deleted. |
| Primary key | |||
| Name | Columns | Description | |
| PK_Login_Ticket$ticket_guid | ticket_guid | ||
| Foreign keys | |||
| Name | Columns | Referenced table | Description |
| FK_Login_Ticket__Staff__staff_KEY | staff_KEY | Staff (staff_KEY) | |