DataSources
Primary Key
| Primary Key | Field Type |
|---|---|
| DataSourceID | int |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| Name | nvarchar(255) | |||
| TypeNamespace | nvarchar(255) | yes | Default = N'Blackbaud.Web.Content.Core.Data' | |
| TypeName | nvarchar(255) | yes | ||
| IsEmailListSource | bit | Default = 0 | ||
| BackOfficeSystemId | int | Default = 0 | ||
| Available | bit | Default = 1 | ||
| SubscriberProviderForSystemID | int | yes | ||
| ImportListID | int | yes | ||
| IsEmailTemplateSource | bit | Default = 1 | ||
| UploadOrigin | int | Default = 0 | ||
| Deleted | int | yes | Default = 0 | |
| DATAPROCESSOR | nvarchar(500) | yes | ||
| LISTPROCESSOR | nvarchar(500) | yes | ||
| FIELDPROVIDER | nvarchar(500) | yes |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| DataSources_SubscriberForSystemID__UniqueKey | SubscriberProviderForSystemID | |||
| PK_DataSources | DataSourceID | yes | yes | yes |
Referenced by
| Referenced by | Field |
|---|---|
| BBDM_Fields | DataSourceID |
| DATASOURCEPRODUCT | DATASOURCEID |