Table transmart.i2b2demodata.relation
Represents relationships between subjects. e.g. pedigree.

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
left_subject_id numeric 38
patient_dimension.patient_num left_subject_id_fk R
Id of the left subject in the relation.
relation_type_id int4 10
relation_type.id relation_type_id_fk R
Relation type id.
right_subject_id numeric 38
patient_dimension.patient_num right_subject_id_fk R
Id of the right subject in the relation.
biological bool 1  √  null Specifies whether relation biological.
share_household bool 1  √  null Specifies whether subjects share household.

Table contained 0 rows at Wed Jun 26 00:11 CEST 2019

Indexes:
Column(s) Type Sort Constraint Name
left_subject_id + relation_type_id + right_subject_id Primary key Asc/Asc/Asc relation_pk
relation_type_id Performance Asc relation_type_id_idx

Close relationships  within of separation: