| 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 |
|---|---|---|---|---|
 NetAccountID |
int | NetAccount.ID | ||
| RelationAccountID |
int | NetAccount.ID | ||
| BlockedID |
int | |
NetAccount.ID |
| Index Name | Field(s) | Unique | Primary | Clustered |
|---|---|---|---|---|
 IX_NetAccountRelation_ID_NetAccountID_RelationAccountID |
ID, NetAccountID, RelationAccountID | |||
| IX_NetAccountRelation_ID_NetAccountID_RelationAccountID_BlockedID_Confirmation |
ID, NetAccountID, RelationAccountID, BlockedID, Confirmation | |||
| PK_NetAccountRelation |
ID | |
|