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 |