UserFieldLevels


Description

User field access levels that define the access levels and permissions required to view or modify user-defined fields based on user roles and security requirements.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
AccessLevel Unknown 0 null

Access level - Required access level for this field

CanDelete Unknown 0 null

Delete permission - Whether users at this level can delete field data

CanEdit Unknown 0 null

Edit permission - Whether users at this level can edit the field

CanView Unknown 0 null

View permission - Whether users at this level can view the field

FieldName Unknown 0 null

Field name - Name of the user field

levelID int identity 4 null

Reference identifier - Foreign key reference to related entity or lookup table

UserFieldLevelDes varchar 50 null

Text field - UserFieldLevelDes text information for UserFieldLevels records

Indexes

Constraint Name Type Sort Column(s)
PK__UserFieldLevels__69D19EED Primary key Asc levelID

Relationships