| Primary Key | Field Type |
|---|---|
 ID |
uniqueidentifier |
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 HOUSEHOLDID |
uniqueidentifier |  |
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 Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 ID |
uniqueidentifier | CONSTITUENT.LOCALID | Primary Key. |
| Index Name | Field(s) | Unique | Primary | Clustered |
|---|---|---|---|---|
 IX_CONSTITUENTHOUSEHOLD_HOUSEHOLDID |
HOUSEHOLDID | |||
| PK_CONSTITUENTHOUSEHOLD |
ID | |
|
|
| UIX_CONSTITUENTHOUSEHOLD_ID |
ID | |