contact

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