Topic Last Modified: 2011-01-27
The ScopePrincipal table contains scopes assigned to nodes.
Columns
| Column | Type | Description |
|---|---|---|
|
scopeNodeID |
int, not null |
Node ID that the scope applies to. |
|
scopePrinID |
int, not null |
Principal ID. |
|
scopeUpdatedBy |
int, not null |
ID of the principal that last updated this entry. |
Keys
| Column | Description |
|---|---|
|
<scopeNodeID, scopePrinID> |
Primary key. |
|
scopeNodeID |
Foreign key with lookup in tblNode.nodeID. |
|
scopePrinID |
Foreign key with lookup in tblPrincipal.prinID. |