tblPrincipalInvites

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.