AddressBookContacts
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | int |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| ClientData | ntext | yes | ||
| FirstName | nvarchar(100) | yes | ||
| LastName | nvarchar(100) | yes | ||
| nvarchar(100) | yes | |||
| REID | int | yes | ||
| EmailGreeting | ntext | yes | ||
| Deleted | bit | Default = 0 | ||
| OrgName | nvarchar(60) | yes | ||
| ContactType | int | yes | Default = NULL |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| ClientUsersID | int | ClientUsers.ID | ||
| ContactGroupID | int | yes | ContactGroup.ID |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_AddressbookContacts_Email_LastName_FirstName_ClientUsersID | Email, LastName, FirstName, ClientUsersID | |||
| IX_AddressbookContacts_ID_LastName | ID, LastName | |||
| IX_AddressBookContacts_REID | REID | |||
| PK_AddressBookContacts | ID | yes | yes | yes |
Referenced by
| Referenced by | Field |
|---|---|
| FundraiserSolicitorContact | AddressbookContactsID |
| FundraiserSolicitorContactAction | AddressbookContactsID |