UserIDStatus


Description

User ID status definitions defining status values for user identification records and credentials. This table manages status classifications for user IDs such as Active, Expired, Pending, Suspended, supporting credential lifecycle management and compliance tracking for healthcare professional qualifications.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
pkStatusID int identity 4 √ null
UserIDList.fkStatusID FK__UserIDLis__fkSta__35548064 C

Primary key - Unique identifier for each status type
StatusDesc varchar 50 √ null

Status description - Description of the ID status (Active, Expired, Pending, etc.)

Indexes

Constraint Name Type Sort Column(s)
PK__UserIDStatus__3183EF80 Primary key Asc pkStatusID

Relationships

Close relationships within degrees of separation