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 |