Table: Login_Ticket
Single-use login tickets which can be used in lieu of a password for authentication.
Columns
NameTypeConstraintsDescription
staff_KEYintNOT NULLThe staff that can be logged in using this ticket.
ticket_guiduniqueidentifierNOT NULLAn identifier for the ticket, randomly generated.
expires_utcdatetimeNOT NULLA timestamp after which the ticket should be considered invalid and can be deleted.
Primary key
NameColumnsDescription
PK_Login_Ticket$ticket_guidticket_guid
Indexes
NameColumnsDescription
IX_Login_Ticket$expires_utcexpires_utcSupports efficient deletion of expired login tickets
IX_Login_Ticket$staff_KEYstaff_KEYCLUSTERED
We cluster by staff key for a minor savings in cascaded deletions.
Foreign keys
NameColumnsReferenced tableDescription
FK_Login_Ticket__Staff__staff_KEYstaff_KEYStaffon delete cascade;

Schema diagram