GivingHistory
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | int |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| Guid | uniqueidentifier | Default = (newid()) | ||
| GiftTypes | ntext | yes | ||
| Campaigns | ntext | yes | ||
| Funds | ntext | yes | ||
| Appeals | ntext | yes | ||
| ExcludeSC | bit | Default = 0 | ||
| SCText | nvarchar(256) | yes | ||
| GivingHistoryName | nvarchar(510) | yes | ||
| Message | nvarchar(2048) | yes |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| SiteContentID | int | SiteContent.ID |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_GivingHistory_1 | GivingHistoryName | |||
| IX_GivingHistory_GUID | Guid | |||
| IX_GivingHistory_SiteContentID | SiteContentID | |||
| PK_GivingHistory | ID | yes | yes | yes |