contact_address


If there is patient data for this table the file for this export will be found in the extracted zip folder location under the filename of contact_address.csv

If there are non-patient data column elements that are not part of the designated record set they will be marked in the Comment's column for that data element

Description

Contains information about a specific contact’s address

Columns

Column Type Size Nulls Auto Default Children Parents Comments
address_id Unknown 0 null

The id of the address this contact address belongs to
contact_id Unknown 0 null

The id of the contact this record belongs to
created_by Unknown 0 null
users.id Defined in XML R

The id of the user that initially created this record
is_primary Unknown 0 null

Is the primary address for the contact ‘1’ for yes, ‘0’ for no
status Unknown 0 null

‘A’ for active, ‘I’ for inactive
type Unknown 0 null
list_options.option_id Defined in XML R

fk to list_options.option_id WHERE list_options.list_id=‘address-types’
updated_by Unknown 0 null
users.id Defined in XML R

The id of the user that last updated this record
use Unknown 0 null
list_options.option_id Defined in XML R

fk to list_options.option_id WHERE list_options.list_id=‘address-uses’

Relationships

Close relationships within degrees of separation