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