Table transmart.i2b2demodata.relation_type
Dictionary of relations. e.g. "parent of" relation.

 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
id serial 10  √  nextval('i2b2demodata.relation_type_id_seq'::regclass)
relation.relation_type_id relation_type_id_fk R
set_type.id Implied Constraint R
label varchar 200 Short unique name of the relation.
description text 2147483647  √  null Detailed description of the relation.
symmetrical bool 1  √  null Whether relation is symmetrical. e.g. "sibling of" is symmetrical. "parent of" is not.
biological bool 1  √  null Whether relation is biological. e.g. "parent of" is biological. "spouse of" is not.

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc relation_type_pkey
label Must be unique Asc relation_type_label_unq

Close relationships  within of separation: