Table transmart.i2b2demodata.qt_query_result_instance 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
result_instance_id numeric 5  √  nextval('i2b2demodata.qt_sq_qri_qriid'::regclass)
qt_patient_enc_collection.result_instance_id qt_fk_pec_ri R
qt_patient_set_collection.result_instance_id qt_fk_psc_ri R
qt_xml_result.result_instance_id qt_fk_xmlr_riid R
query_instance_id numeric 5  √  null
qt_query_instance.query_instance_id qt_fk_qri_rid R
result_type_id numeric 3
qt_query_result_type.result_type_id qt_fk_qri_rtid R
set_size numeric 10  √  null
start_date timestamp 29,6
end_date timestamp 29,6  √  null
delete_flag varchar 3  √  null
status_type_id numeric 3
qt_query_status_type.status_type_id qt_fk_qri_stid R
message text 2147483647  √  null
description varchar 200  √  null
real_set_size numeric 10  √  null
obfusc_method varchar 500  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
result_instance_id Primary key Asc qt_query_result_instance_pkey

Close relationships  within of separation: