PrincipalRole Table

 

Topic Last Modified: 2011-01-27

The PrincipalRole table contains explicit roles assigned to nodes.

Columns

Column	Type	Description
prinRoleNodeID	int, not null	Node ID that the role applies to.
prinRolePrinID	int, not null	Principal ID.
prinRoleTypeID	int, not null	Role type ID (from tblRoleType).
prinRoleUpdatedBy	int, not null	ID of the principal that last updated this entry.
honorsOverride	bit, not null	True if the role can be overridden. False if it cannot. (This is copied from the similar column in tblRoleType.)
honorsScope	bit, not null	True if the role obeys the scope. False if does not. (This is copied from the similar column in RoleType table.)

Keys

Column	Description
<prinRoleNodeID, prinRolePrinID, prinRoleTypeID>	Primary key.
prinRoleNodeID	Foreign key with lookup in Node.nodeID table.
prinRolePrinID	Foreign key with lookup in Principal.prinID table.
prinRoleTypeID	Foreign key with lookup in RoleType.rtypeID table.