WPSEARCHHISTORYSELECTEDCONSTITUENT
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | uniqueidentifier |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| WPSEARCHHISTORYID | uniqueidentifier | WPSEARCHHISTORY.ID | ||
| CONSTITUENTID | uniqueidentifier | CONSTITUENT.LOCALID |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_WPSEARCHHISTORYSELECTEDCONSTITUENT_CONSTITUENTID | CONSTITUENTID | |||
| PK_WPSEARCHHISTORYSELECTEDCONSTITUENT | ID | yes | yes | yes |
| UIX_WPSEARCHHISTORYSELECTEDCONSTITUENT_WPSEARCHHISTORYID_CONSTITUENTID | WPSEARCHHISTORYID, CONSTITUENTID | yes |