Information pertaining to the tables created when UmbracoCMS is installed
- cmsMemberType : Member properties
- cmsPropertyType : Data of the member properties
- cmsMember2MemberGroup : The relationship between Members and MemberGroups
Stores information relating to Member
properties.
Columns
Name | Type | Description |
---|---|---|
pk | int | Primary Key |
NodeId | int | The Id of the property group for Members |
propertyTypeId | int | The Id of the cmsPropertyType |
memberCanEdit | bit | If set to 'true', allows members to edit their own property value |
viewOnProfile | bit | If set to 'true', allows members to see the property on their profile |
isSensitive | bit | If set to 'true', requires Umbraco users to have the 'View Sensitive Information' permission set in order to view. |
Stores the information relating to the CMS properties, such as properties assigned to Members
and CMS page properties.
Columns
Name | Type | Description |
---|---|---|
id | int | Primary Key |
dataTypeId | int | ?? |
contentTypeId | int | ?? |
propertyTypeGroupId | int | The Id of the Property Type Group, that this property belongs to |
Alias | nvarchar(255) | Alias of the property |
Name | nvarchar(255) | Name of the property |
sortOrder | int | Sort order of the property when displayed in the CMS |
mandatory | bit | If set to 'true', the property must have a value when saved in the CMS |
validationRegExp | nvarchar(255) | The regular expression to validate the property value against. (Value is null if not specified) |
Description | nvarchar(2000) | The description of the property |
variations | int | ?? |
UniqueID | uniqueidentifier | ?? |
mandatoryMessage | nvarchar(500) | The message to display to a user if mandatory is set to 'true' and a value is not supplied. (Value is null if not specified) |
validateRegExpMessage | nvarchar(500) | The message to display to a user if validationRegExp is set to 'true' and the value does not meet the regular expression pattern. |
Stores the relationship between Members
and MemberGroups
Columns
Name | Type | Description |
---|---|---|
Member | int | The Member Id |
MemberGroup | int | The Id of the cmsPropertyTypeGroup (MemberGroup ) |