Table: dbo.Login_Ticket
Single-use login tickets which can be used in lieu of a password for authentication.
Columns
NameTypeConstraintsDescription
staff_KEYint (4)NOT NULLThe staff that can be logged in using this ticket.
ticket_guiduniqueidentifier (16)NOT NULLAn identifier for the ticket, randomly generated.
expires_utcdatetime (8, 3)NOT NULLA timestamp after which the ticket should be considered invalid and can be deleted.
Primary key
NameColumnsDescription
PK_Login_Ticket$ticket_guidticket_guid
Foreign keys
NameColumnsReferenced tableDescription
FK_Login_Ticket__Staff__staff_KEYstaff_KEYStaff (staff_KEY)

Schema diagram