transmart.searchapp contains 285 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
listsig_genes	gene_keyword_id	int8	19	√		null
listsig_genes	list_keyword_id	int8	19	√		null
pathway_genes	gene_biomarker_id	int8	19	√		null
pathway_genes	gene_keyword_id	int8	19	√		null
pathway_genes	pathway_keyword_id	int8	19	√		null
plugin	active	bpchar	1	√		null
plugin	default_link	varchar	70
plugin	form_link	varchar	70	√		null
plugin	form_page	varchar	100	√		null
plugin	has_form	bpchar	1			'N'::bpchar
plugin	has_modules	bpchar	1			'N'::bpchar
plugin	name	varchar	200
plugin	plugin_name	varchar	90
plugin	plugin_seq	int8	19
plugin_module	active	bpchar	1			'Y'::bpchar
plugin_module	category	varchar	50	√		null
plugin_module	form_link	varchar	90	√		null
plugin_module	form_page	varchar	90	√		null
plugin_module	has_form	bpchar	1			'N'::bpchar
plugin_module	module_name	varchar	50
plugin_module	module_seq	int8	19
plugin_module	name	varchar	70
plugin_module	params	text	2147483647
plugin_module	plugin_seq	int8	19
plugin_module	version	varchar	10			0.1
plugin_module_backup	active	bpchar	1
plugin_module_backup	category	varchar	50	√		null
plugin_module_backup	form_link	varchar	90	√		null
plugin_module_backup	form_page	varchar	90	√		null
plugin_module_backup	has_form	bpchar	1
plugin_module_backup	module_name	varchar	50
plugin_module_backup	module_seq	int8	19
plugin_module_backup	name	varchar	70
plugin_module_backup	params	text	2147483647
plugin_module_backup	plugin_seq	int8	19
plugin_module_backup	version	varchar	10
report	create_date	timestamp	29,6	√		null
report	creatinguser	varchar	200	√		null
report	description	varchar	1000	√		null
report	name	varchar	200	√		null
report	public_flag	varchar	20	√		null
report	report_id	int8	19	√		null
report	study	varchar	200	√		null
report_item	code	varchar	200	√		null
report_item	report_id	int8	19	√		null
report_item	report_item_id	int8	19	√		null
saved_faceted_search	analysis_ids	varchar	4000	√		null
saved_faceted_search	create_dt	date	13	√		now()
saved_faceted_search	keywords	varchar	4000
saved_faceted_search	modified_dt	date	13	√		null
saved_faceted_search	name	varchar	100
saved_faceted_search	saved_faceted_search_id	int8	19
saved_faceted_search	search_type	varchar	50			'FACETED_SEARCH'::character varying
saved_faceted_search	user_id	int8	19
search_app_access_log	access_time	timestamp	29,6	√		null
search_app_access_log	event	varchar	255	√		null
search_app_access_log	event_message	text	2147483647	√		null
search_app_access_log	id	int8	19	√		null
search_app_access_log	request_url	varchar	255	√		null
search_app_access_log	user_name	varchar	255	√		null
search_auth_group	group_category	varchar	255	√		null
search_auth_group	id	int8	19
search_auth_group_member	auth_group_id	int8	19	√		null
search_auth_group_member	auth_user_id	int8	19	√		null
search_auth_principal	date_created	timestamp	29,6
search_auth_principal	description	varchar	255	√		null
search_auth_principal	enabled	bool	1	√		null
search_auth_principal	id	int8	19
search_auth_principal	last_updated	timestamp	29,6
search_auth_principal	name	varchar	255	√		null
search_auth_principal	principal_type	varchar	255	√		null
search_auth_principal	unique_id	varchar	255	√		null
search_auth_sec_object_access	auth_principal_id	int8	19	√		null
search_auth_sec_object_access	auth_sec_obj_access_id	int8	19
search_auth_sec_object_access	secure_access_level_id	int8	19	√		null
search_auth_sec_object_access	secure_object_id	int8	19	√		null
search_auth_user	change_passwd	bool	1	√		null
search_auth_user	email	varchar	255	√		null
search_auth_user	email_show	bool	1	√		null
search_auth_user	federated_id	varchar	255	√		null
search_auth_user	id	int8	19
search_auth_user	passwd	varchar	255	√		null
search_auth_user	user_real_name	varchar	255	√		null
search_auth_user	username	varchar	255	√		null
search_auth_user_sec_access	search_auth_user_id	int8	19	√		null
search_auth_user_sec_access	search_auth_user_sec_access_id	int8	19
search_auth_user_sec_access	search_sec_access_level_id	int8	19	√		null
search_auth_user_sec_access	search_secure_object_id	int8	19	√		null
search_auth_user_sec_access_v	search_auth_user_id	int8	19	√		null
search_auth_user_sec_access_v	search_auth_user_sec_access_id	int8	19	√		null
search_auth_user_sec_access_v	search_sec_access_level_id	int8	19	√		null
search_auth_user_sec_access_v	search_secure_object_id	int8	19	√		null
search_bio_mkr_correl_fast_mv	asso_bio_marker_id	int8	19	√		null
search_bio_mkr_correl_fast_mv	correl_type	varchar	19	√		null
search_bio_mkr_correl_fast_mv	domain_object_id	int8	19
search_bio_mkr_correl_fast_mv	mv_id	int8	19	√		null
search_bio_mkr_correl_fast_mv	value_metric	int8	19	√		null
search_bio_mkr_correl_fast_view	asso_bio_marker_id	int8	19	√		null
search_bio_mkr_correl_fast_view	correl_type	varchar	40	√		null
search_bio_mkr_correl_fast_view	domain_object_id	int8	19	√		null
search_bio_mkr_correl_fast_view	mv_id	int4	10	√		null
search_bio_mkr_correl_fast_view	value_metric	int8	19	√		null
search_bio_mkr_correl_view	asso_bio_marker_id	int8	19	√		null
search_bio_mkr_correl_view	correl_type	text	2147483647	√		null
search_bio_mkr_correl_view	domain_object_id	int8	19	√		null
search_bio_mkr_correl_view	mv_id	int4	10	√		null
search_bio_mkr_correl_view	value_metric	int8	19	√		null
search_categories	category_id	int8	19	√		null
search_categories	category_name	varchar	900	√		null
search_custom_filter	description	varchar	2000	√		null
search_custom_filter	name	varchar	200
search_custom_filter	private	bpchar	1			'N'::bpchar
search_custom_filter	search_custom_filter_id	int8	19
search_custom_filter	search_user_id	int8	19
search_custom_filter_item	bio_data_type	varchar	100
search_custom_filter_item	search_custom_filter_id	int8	19
search_custom_filter_item	search_custom_filter_item_id	int8	19
search_custom_filter_item	unique_id	varchar	200
search_form_layout	data_type	varchar	50	√		null
search_form_layout	display	bpchar	1	√		null
search_form_layout	display_name	varchar	50	√		null
search_form_layout	form_column	varchar	50	√		null
search_form_layout	form_key	varchar	50	√		null
search_form_layout	form_layout_id	int8	19
search_form_layout	sequence	int8	19	√		null
search_gene_sig_file_schema	description	varchar	255	√		null
search_gene_sig_file_schema	name	varchar	100
search_gene_sig_file_schema	number_columns	int8	19			2
search_gene_sig_file_schema	search_gene_sig_file_schema_id	int8	19
search_gene_sig_file_schema	supported	bool	1	√		false
search_gene_signature	analysis_method_concept_id	int8	19	√		null
search_gene_signature	analysis_method_other	varchar	255	√		null
search_gene_signature	analyst_name	varchar	100	√		null
search_gene_signature	analytic_cat_concept_id	int8	19	√		null
search_gene_signature	analytic_cat_other	varchar	255	√		null
search_gene_signature	bio_assay_platform_id	int8	19
search_gene_signature	create_date	timestamp	29,6
search_gene_signature	created_by_auth_user_id	int8	19
search_gene_signature	custom_name1	varchar	255	√		null
search_gene_signature	custom_name2	varchar	255	√		null
search_gene_signature	custom_name3	varchar	255	√		null
search_gene_signature	custom_name4	varchar	255	√		null
search_gene_signature	custom_name5	varchar	255	√		null
search_gene_signature	custom_value1	varchar	255	√		null
search_gene_signature	custom_value2	varchar	255	√		null
search_gene_signature	custom_value3	varchar	255	√		null
search_gene_signature	custom_value4	varchar	255	√		null
search_gene_signature	custom_value5	varchar	255	√		null
search_gene_signature	data_source	varchar	255	√		null
search_gene_signature	deleted_flag	bool	1	√		false
search_gene_signature	description	varchar	1000	√		null
search_gene_signature	experiment_type_atcc_ref	varchar	255	√		null
search_gene_signature	experiment_type_cell_line_id	int8	19	√		null
search_gene_signature	experiment_type_concept_id	int8	19	√		null
search_gene_signature	experiment_type_in_vivo_descr	varchar	255	√		null
search_gene_signature	fold_chg_metric_concept_id	int8	19
search_gene_signature	last_modified_date	timestamp	29,6	√		null
search_gene_signature	modified_by_auth_user_id	int8	19	√		null
search_gene_signature	multiple_testing_correction	bool	1	√		null
search_gene_signature	name	varchar	100
search_gene_signature	norm_method_concept_id	int8	19	√		null
search_gene_signature	norm_method_other	varchar	255	√		null
search_gene_signature	owner_concept_id	int8	19	√		null
search_gene_signature	p_value_cutoff_concept_id	int8	19
search_gene_signature	parent_gene_signature_id	int8	19	√		null
search_gene_signature	pmid_list	varchar	255	√		null
search_gene_signature	public_flag	bool	1	√		false
search_gene_signature	qc_date	date	13	√		null
search_gene_signature	qc_info	varchar	255	√		null
search_gene_signature	qc_performed	numeric	1	√		null
search_gene_signature	search_gene_sig_file_schema_id	int8	19			1
search_gene_signature	search_gene_signature_id	int8	19
search_gene_signature	source_concept_id	int8	19	√		null
search_gene_signature	source_other	varchar	255	√		null
search_gene_signature	species_concept_id	int8	19
search_gene_signature	species_mouse_detail	varchar	255	√		null
search_gene_signature	species_mouse_src_concept_id	int8	19	√		null
search_gene_signature	stimulus_description	varchar	1000	√		null
search_gene_signature	stimulus_dosing	varchar	255	√		null
search_gene_signature	tissue_type_concept_id	int8	19	√		null
search_gene_signature	treatment_bio_compound_id	int8	19	√		null
search_gene_signature	treatment_description	varchar	1000	√		null
search_gene_signature	treatment_dosing	varchar	255	√		null
search_gene_signature	treatment_protocol_number	varchar	50	√		null
search_gene_signature	unique_id	varchar	50	√		null
search_gene_signature	upload_file	varchar	255
search_gene_signature	version	varchar	255	√		null
search_gene_signature	version_number	varchar	50	√		null
search_gene_signature_item	bio_assay_feature_group_id	int8	19	√		null
search_gene_signature_item	bio_data_unique_id	varchar	200	√		null
search_gene_signature_item	bio_marker_id	int8	19	√		null
search_gene_signature_item	fold_chg_metric	int8	19	√		null
search_gene_signature_item	id	int8	19
search_gene_signature_item	probeset_id	int8	19	√		null
search_gene_signature_item	search_gene_signature_id	int8	19
search_keyword	bio_data_id	int8	19	√		null
search_keyword	data_category	varchar	200
search_keyword	display_data_category	varchar	200	√		null
search_keyword	keyword	varchar	400	√		null
search_keyword	owner_auth_user_id	int8	19	√		null
search_keyword	search_keyword_id	int8	19
search_keyword	source_code	varchar	100	√		null
search_keyword	unique_id	varchar	500
search_keyword_term	keyword_term	varchar	200	√		null
search_keyword_term	owner_auth_user_id	int8	19	√		null
search_keyword_term	rank	int8	19	√		null
search_keyword_term	search_keyword_id	int8	19	√		null
search_keyword_term	search_keyword_term_id	int8	19
search_keyword_term	term_length	int8	19	√		null
search_request_map	config_attribute	varchar	255	√		null
search_request_map	id	int8	19	√		null
search_request_map	url	varchar	255	√		null
search_request_map	version	int8	19	√		null
search_required_upload_field	field	varchar	50	√		null
search_required_upload_field	required_upload_field_id	int8	19
search_required_upload_field	type	varchar	50	√		null
search_role	authority	varchar	255	√		null
search_role	description	varchar	255	√		null
search_role	id	int8	19
search_role	version	int8	19	√		null
search_role_auth_user	authorities_id	int8	19	√		null
search_role_auth_user	people_id	int8	19	√		null
search_sec_access_level	access_level_name	varchar	200	√		null
search_sec_access_level	access_level_value	int8	19	√		null
search_sec_access_level	search_sec_access_level_id	int8	19
search_secure_object	bio_data_id	int8	19	√		null	Id of the data restricted by this token.
search_secure_object	bio_data_unique_id	varchar	200	√		null	The unique id used to refer to the token. E.g., EXP:SHDCSCP.
search_secure_object	data_type	varchar	200	√		null	Data type. E.g., BIO_CLINICAL_TRIAL.
search_secure_object	display_name	varchar	100	√		null	The name used to display this token. E.g., Private Studies - SHARED_HD_CONCEPTS_STUDY_C_PR.
search_secure_object	search_secure_object_id	int8	19				Primary key. Id of the token.
search_secure_object_path	i2b2_concept_path	varchar	2000	√		null
search_secure_object_path	search_secure_obj_path_id	int8	19
search_secure_object_path	search_secure_object_id	int8	19	√		null
search_taxonomy	import_date	timestamp	25,1	√		now()
search_taxonomy	search_keyword_id	int8	19	√		null
search_taxonomy	source_cd	varchar	900	√		null
search_taxonomy	term_id	int8	19
search_taxonomy	term_name	varchar	900
search_taxonomy_level1	category_name	varchar	900	√		null
search_taxonomy_level1	term_id	int8	19	√		null
search_taxonomy_level1	term_name	varchar	900	√		null
search_taxonomy_level2	category_name	varchar	900	√		null
search_taxonomy_level2	term_id	int8	19	√		null
search_taxonomy_level2	term_name	varchar	900	√		null
search_taxonomy_level3	category_name	varchar	900	√		null
search_taxonomy_level3	term_id	int8	19	√		null
search_taxonomy_level3	term_name	varchar	900	√		null
search_taxonomy_level4	category_name	varchar	900	√		null
search_taxonomy_level4	term_id	int8	19	√		null
search_taxonomy_level4	term_name	varchar	900	√		null
search_taxonomy_level5	category_name	varchar	900	√		null
search_taxonomy_level5	term_id	int8	19	√		null
search_taxonomy_level5	term_name	varchar	900	√		null
search_taxonomy_lineage	child_id	int8	19	√		null
search_taxonomy_lineage	parent1	int8	19	√		null
search_taxonomy_lineage	parent2	int8	19	√		null
search_taxonomy_lineage	parent3	int8	19	√		null
search_taxonomy_lineage	parent4	int8	19	√		null
search_taxonomy_rels	child_id	int8	19
search_taxonomy_rels	parent_id	int8	19	√		null
search_taxonomy_rels	search_taxonomy_rels_id	int8	19
search_taxonomy_terms_cats	category_name	varchar	900	√		null
search_taxonomy_terms_cats	term_id	int8	19	√		null
search_taxonomy_terms_cats	term_name	varchar	900	√		null
search_user_feedback	app_version	varchar	100	√		null
search_user_feedback	create_date	timestamp	29,6	√		null
search_user_feedback	feedback_text	varchar	2000	√		null
search_user_feedback	search_user_feedback_id	int8	19
search_user_feedback	search_user_id	int8	19	√		null
search_user_settings	id	int8	19
search_user_settings	setting_name	varchar	255
search_user_settings	setting_value	varchar	1024
search_user_settings	user_id	int8	19
solr_keywords_lineage	ancestor_id	int8	19	√		null
solr_keywords_lineage	search_keyword_id	int8	19	√		null
solr_keywords_lineage	term_id	int8	19	√		null
subset	create_date	date	13
subset	creating_user	varchar	200
subset	deleted_flag	bool	1
subset	description	varchar	1000
subset	public_flag	bool	1
subset	query_master_id_1	int8	19
subset	query_master_id_2	int8	19	√		null
subset	study	varchar	200	√		null
subset	subset_id	int8	19