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