Documentation/EHI_Export/docs/tables/contact_address.html
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| contact_id | BIGINT | 19 | null |
|
| contact.id | Defined in XML | R |
|
The id of the contact this record belongs to
| | address_id | BIGINT | 19 | | | null |
|
| addresses.id | Defined in XML | R |
|
The id of the address this contact address belongs to
| | created_by | Unknown | 0 | | | null |
|
| users.id | Defined in XML | R |
|
The id of the user that initially created this record
| | id | BIGINT | 19 | | √ | null |
|
| | | priority | INT | 10 | √ | | NULL |
|
| | | type | VARCHAR | 255 | √ | | NULL |
|
| list_options.option_id | Defined in XML | R |
|
fk to list_options.option_id WHERE list_options.list_id=‘address-types’
| | use | VARCHAR | 255 | √ | | NULL |
|
| list_options.option_id | Defined in XML | R |
|
fk to list_options.option_id WHERE list_options.list_id=‘address-uses’
| | notes | TINYTEXT | 255 | √ | | NULL |
|
| | | status | CHAR | 1 | √ | | NULL |
|
|
‘A’ for active, ‘I’ for inactive
| | is_primary | CHAR | 1 | √ | | NULL |
|
|
Is the primary address for the contact ‘1’ for yes, ‘0’ for no
| | created_date | DATETIME | 19 | | | current_timestamp() |
|
| | | period_start | DATETIME | 19 | √ | | NULL |
|
|
Date the address became active
| | period_end | DATETIME | 19 | √ | | NULL |
|
|
Date the address became deactivated
| | inactivated_reason | VARCHAR | 45 | √ | | NULL |
|
|
Values: Moved, Mail Returned, etc
| | updated_by | Unknown | 0 | | | null |
|
| users.id | Defined in XML | R |
|
The id of the user that last updated this record
|
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| address_id | Performance | Asc | address_id |
| contact_address_idx | Performance | Asc/Asc | contact_id + address_id |
| contact_id | Performance | Asc | contact_id |