Topic Last Modified: 2012-06-25

tblPrincipalInvites contains invitations for all provisioned users for all nodes with auto-invite on.

Columns

Column Type Description

prinID

int, not null

Principal ID.

invID

int, not null

Unique sequential number (per principal ID) generated from tblLastInviteId table.

nodeID

int, not null

Node ID (chat room only).

createdOn

datetime, not null

Time of creation.

Keys

Column Description

<prinID, nodeID>

Primary key.

prinID

Foreign key with lookup in tblPrincipal.prinID table.

nodeID

Foreign key with lookup in tblNode.nodeID table.