Topic Last Modified: 2012-09-12
tblPrincipalRole 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. |
Keys
| Column | Description |
|---|---|
|
<prinRoleNodeID, prinRolePrinID, prinRoleTypeID> |
Primary key. |
|
prinRoleNodeID |
Foreign key with lookup in tblNode.nodeID table. |
|
prinRolePrinID |
Foreign key with lookup in tblPrincipal.prinID table. |
|
prinRoleTypeID |
Foreign key with lookup in tblRoleType.rtypeID table. |