tblPrincipalInvites
tblPrincipalInvites contain invitations for all provisioned users for all nodes with autoinvite 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. |