Table transmart.i2b2demodata.qt_analysis_plugin 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
plugin_id numeric 10
qt_analysis_plugin_result_type.plugin_id Implied Constraint R
qt_privilege.plugin_id Implied Constraint R
qt_query_master.plugin_id Implied Constraint R
plugin_name varchar 2000  √  null
description varchar 2000  √  null
version_cd varchar 50  √  null
parameter_info text 2147483647  √  null
parameter_info_xsd text 2147483647  √  null
command_line text 2147483647  √  null
working_folder text 2147483647  √  null
commandoption_cd text 2147483647  √  null
plugin_icon text 2147483647  √  null
status_cd varchar 50  √  null
user_id varchar 50  √  null
group_id varchar 50  √  null
create_date timestamp 29,6  √  null
update_date timestamp 29,6  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
plugin_id Primary key Asc analysis_plugin_pk
plugin_name + version_cd + group_id Performance Asc/Asc/Asc qt_apnamevergrp_idx

Close relationships: