Table transmart.i2b2demodata.qt_query_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
query_instance_id numeric 5  √  nextval('i2b2demodata.qt_sq_qi_qiid'::regclass)
qt_query_result_instance.query_instance_id qt_fk_qri_rid R
query_master_id numeric 5  √  null
qt_query_master.query_master_id qt_fk_qi_mid R
user_id varchar 50
group_id varchar 50
batch_mode varchar 50  √  null
start_date timestamp 29,6
end_date timestamp 29,6  √  null
delete_flag varchar 3  √  null
status_type_id numeric 5  √  null
qt_query_status_type.status_type_id qt_fk_qi_stid R
message text 2147483647  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
query_instance_id Primary key Asc qt_query_instance_pkey
query_master_id + start_date Performance Asc/Asc qt_idx_qi_mstartid
user_id + group_id Performance Asc/Asc qt_idx_qi_ugid

Close relationships  within of separation: