Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| CUSTOMER_ID | int | 4 | √ | null |
|
|
The family member customer ID |
|
| FAMILY_ID | int | 4 | √ | null |
|
|
The family ID |
|
| FAMILY_NAME | varchar | 255 | √ | null |
|
|
The family name |
|
| IS_MAIN_CONTACT | varchar | 5 | √ | null |
|
|
Whether this customer is the main contact for the family (Yes/No) |
|
| HOH_CUSTOMER_ID | int | 4 | √ | null |
|
|
The head of household’s customer ID |
|
| HOH_FIRST_NAME | varchar | 255 | √ | null |
|
|
The head of household’s first name |
|
| HOH_LAST_NAME | varchar | 255 | √ | null |
|
|
The head of household’s last name |
|
| HOH_EMAIL | varchar | 255 | √ | null |
|
|
The head of household’s email address |
|
| HOH_ADDITIONAL_EMAIL | varchar | 255 | √ | null |
|
|
The head of household’s additional email address |
|
| HOH_CELLPHONE | varchar | 255 | √ | null |
|
|
The head of household’s cell phone number |
|
| HOH_HOMEPHONE | varchar | 255 | √ | null |
|
|
The head of household’s home phone number |
|
| HOH_WORKPHONE | varchar | 255 | √ | null |
|
|
The head of household’s work phone number |
|
| HOH_AGREE_RECEIVE_EMAIL | varchar | 5 | √ | null |
|
|
Whether the head of household agreed to receive emails (Yes/No) |
|
| HOH_AGREE_RECEIVE_POSTAL_MAIL | varchar | 5 | √ | null |
|
|
Whether the head of household agreed to receive postal mail (Yes/No) |
|
| HOH_AGREE_RECEIVE_TEXT_MESSAGE | varchar | 255 | √ | null |
|
|
Whether the head of household agreed to receive text messages (Yes/No) |
|
| HOH_IS_EMAIL_VALID | varchar | 3 | √ | null |
|
|
Whether the head of household’s email address has been provided and is a validly formatted email address (Yes/No) |
|
| HOH_IS_ADDITIONAL_EMAIL_VALID | varchar | 3 | √ | null |
|
|
Whether the head of household’s additional email address has been provided and is a validly formatted email address (Yes/No) |