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