CONSTITUENTHOUSEHOLD
This table stores the current household information for a constituent.
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | uniqueidentifier |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| HOUSEHOLDID | uniqueidentifier | yes | The household that the constituent belongs to. This is an ID from the GROUPDATA table. | |
| ISPRIMARYMEMBER | bit | Default = 0 | Whether or not the constituent is the primary member of the household. | |
| ISHOUSEHOLD | bit | Default = 0 | Whether or not the row is a household. |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| ID | uniqueidentifier | CONSTITUENT.LOCALID | Primary Key. |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_CONSTITUENTHOUSEHOLD_HOUSEHOLDID | HOUSEHOLDID | |||
| PK_CONSTITUENTHOUSEHOLD | ID | yes | yes | yes |
| UIX_CONSTITUENTHOUSEHOLD_ID | ID | yes |