Table: 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 | NOT NULL | The staff that can be logged in using this ticket.
ticket_guid | uniqueidentifier | NOT NULL | An identifier for the ticket, randomly generated.
expires_utc | datetime | 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 |
Indexes
Name | Columns | Description
IX_Login_Ticket$expires_utc | expires_utc | Supports efficient deletion of expired login tickets
IX_Login_Ticket$staff_KEY | staff_KEY | CLUSTERED We cluster by staff key for a minor savings in cascaded deletions.

Foreign keys
Name | Columns | Referenced table | Description
FK_Login_Ticket__Staff__staff_KEY | staff_KEY | Staff | on delete cascade;