LoginCode


Description

Authentication code management storing temporary authentication codes and access tokens for secure system login and authentication processes. This table manages authentication codes, temporary access tokens, and login verification codes with deletion tracking, supporting secure authentication workflows, two-factor authentication, and temporary access management for healthcare system security.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int identity 4 √ null

Primary key - Unique identifier for each authentication code record
AuthCode nvarchar 100 √ null

Authentication code - Temporary authentication code or access token for secure login
DeletedDate datetime 16,3 √ null

Deletion timestamp - Date and time when the authentication code was deleted or expired

Indexes

Constraint Name Type Sort Column(s)
PK__LoginCod__3214EC27324BC64C Primary key Asc ID

Relationships

Close relationships within degrees of separation