UserInSupportLevel


Description

User support level associations linking users to their assigned support levels and subscription tiers. This junction table establishes the relationship between users and their support level subscriptions, enabling support tier management, billing calculations, and feature access control based on subscription levels.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
fkUserID int 4 √ null
AccessUser.UserID FK__UserInSupportLevel__AccessUser C

User reference - Links to the user account (AccessUser.UserID)
fkSuppOpt int 4 √ null
SupportLevel.pkSuppOpt FK__UserInSupportLevel__SupportLevel C

Support option reference - Links to the support level option (SupportLevel.pkSuppOpt)

Relationships

Close relationships within degrees of separation