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.