UserFieldChoices


Description

User field choice options defining selectable options for custom user fields with dropdown or selection capabilities. This table provides choice lists for custom user fields, enabling standardized data entry, consistent option selection, and controlled vocabulary for user profile customization and data collection.

Columns

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

Primary key - Unique identifier for each field choice option
fkUserFieldID int 4 √ null
UserFields.userFieldID FK__UserFieldCho__UserFields C

User field reference - Links to the custom user field (UserFields.userFieldID)
userFieldChoiceTitle varchar 30 √ null

Choice title - Display title for the choice option
userFieldChoiceDesc varchar 100 √ null

Choice description - Detailed description of the choice option

Indexes

Constraint Name Type Sort Column(s)
PK__UserFieldChoices__791ECF75 Primary key Asc userFieldChoiceID

Relationships

Close relationships within degrees of separation