AntMooreWebDev/Umbraco_Table_Descriptions.md

## Umbraco_Table_Descriptions.md

      
    Raw
  

              Umbraco_Table_Descriptions.md
            
          
    Umbraco Table Descriptions

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

cmsMemberType

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.


cmsPropertyType

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.


cmsMember2MemberGroup

Stores the relationship between Members and MemberGroups

  Columns


Name
Type
Description


Member
int
The Member Id


MemberGroup
int
The Id of the cmsPropertyTypeGroup (MemberGroup)
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.
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.
Name	Type	Description
Member	int	The `Member` Id
MemberGroup	int	The Id of the cmsPropertyTypeGroup (`MemberGroup`)