ClientMemberships
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | int |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| OwnerID | int | |||
| Deleted | bit | Default = 0 | ||
| Guid | uniqueidentifier | Default = (newid()) | ||
| XMLData | ntext | yes | ||
| EmailTemplateID | int | yes | ||
| CartMessage | ntext | yes | ||
| CartSendMembershipAcknowledgementAlways | bit | Default = 0 | ||
| AcknowledgementBlock | nvarchar(max) | yes | ||
| RecurrenceOptionsTruePledge | ntext | yes |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| SiteContentID | int | SiteContent.ID | ||
| MerchantAccount | int | yes | ClientMerchantAccounts.ID | |
| ShoppingCartPageID | int | yes | SitePages.ID |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_ClientMemberships_SiteContentID | SiteContentID | |||
| PK_ClientMemberships | ID | yes | yes | yes |