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. |