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) |