| Primary Key | Field Type |
|---|---|
 ID |
int |
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 Confirmation |
int | Default = 0 | ||
| ConfirmationDate |
datetime |  |
||
| CreateDate |
datetime | Default = getutcdate() | ||
| UpdateDate |
datetime | Default = getutcdate() |
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 NetGroupID |
int | NetGroup.ID | ||
| NetAccountID |
int | NetAccount.ID | ||
| BlockedID |
int | |
NetAccount.ID |
| Index Name | Field(s) | Unique | Primary | Clustered |
|---|---|---|---|---|
 IX_NetGroupRelation_ID_NetGroupID_NetAccountID |
ID, NetGroupID, NetAccountID | |||
| IX_NetGroupRelation_NetAccountID_NetGroupID_BlockedID |
NetAccountID, NetGroupID, BlockedID | |||
| IX_NetGroupRelation_NetGroupID_NetAccountID_BlockedID_Confirmation |
ID, NetGroupID, NetAccountID, BlockedID, Confirmation | |||
| PK_NetGroupRelation |
ID | |
|