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