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