ClientUserMailForwarding
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | int |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| ClientUsersID | int | yes | ||
| ClientsID | int | |||
| OptedIn | bit | Default = 0 | ||
| Enabled | bit | Default = 0 | ||
| Quota | int | yes | ||
| MailerServiceGUID | uniqueidentifier | yes | ||
| GUID | uniqueidentifier | Default = (newid()) | ||
| UpdateDate | datetime | yes | ||
| IncomingAddress | nvarchar(510) | yes | ||
| ForwardingAddress | nvarchar(510) | yes | ||
| CreateDate | datetime | yes | Default = getutcdate() |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| CreateID | int | yes | ClientUsers.ID | |
| UpdateID | int | yes | ClientUsers.ID |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_ClientUserMailForwarding_IncomingAddressUnique | IncomingAddress, ClientsID | yes | ||
| IX_ClientUserMailForwarding_UserUnique | ClientUsersID, ClientsID | yes | ||
| PK_ClientUserMailForwarding | ID | yes | yes | yes |
Triggers
| Trigger Name | Description |
|---|---|
| TR_CLIENTUSERMAILFORWARDING_DELETE |