Topic Last Modified: 2011-01-27

The PrincipalInvites table 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 LastInviteId 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 Principal.prinID table.

nodeID

Foreign key with lookup in Node.nodeID table.