contact


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.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 records of contacts in the system

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
contact_address.contact_id Defined in XML R
contact_relation.contact_id Defined in XML R
contact_telecom.contact_id Defined in XML R
foreign_table_name VARCHAR 255 ''

The name of the table this contact belongs to. Can be patient_data or person
foreign_id BIGINT 19 0

The id of the table this contact belongs to. Can be patient_data.pid or person.id

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
foreign_id Performance Asc foreign_id

Relationships

Close relationships within degrees of separation