gprelations


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 gprelations.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

general purpose relations

Columns

Column Type Size Nulls Auto Default Children Parents Comments
type1 INT 10 null
id1 BIGINT 19 null
type2 INT 10 null
id2 BIGINT 19 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc/Asc/Asc type1 + id1 + type2 + id2
key2 Performance Asc/Asc type2 + id2

Relationships

Close relationships within degrees of separation