Table transmart.i2b2demodata.qt_query_master
This master table to the holds the client?s anaysis request information. i.e. the user_id, analysis definition , the i2b2 request_xml, etc..

 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_master_id numeric 5  √  nextval('i2b2demodata.qt_sq_qm_qmid'::regclass)
qt_pdo_query_master.query_master_id Implied Constraint R
qt_query_instance.query_master_id qt_fk_qi_mid R
name varchar 250
user_id varchar 50
group_id varchar 50
master_type_cd varchar 2000  √  null
plugin_id numeric 10  √  null
qt_analysis_plugin.plugin_id Implied Constraint R
create_date timestamp 29,6
delete_date timestamp 29,6  √  null
delete_flag varchar 3  √  null
generated_sql text 2147483647  √  null
request_xml text 2147483647  √  null
i2b2_request_xml text 2147483647  √  null
request_constraints text 2147483647  √  null
api_version text 2147483647  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
query_master_id Primary key Asc qt_query_master_pkey
user_id + group_id + master_type_cd Performance Asc/Asc/Asc qt_idx_qm_ugid

Close relationships  within of separation: