tblPrincipalRole in Lync Server 2013
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. |