transmart.biomart_user contains 110 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
bio_data_values_view	description	varchar	2147483647	√		null
bio_data_values_view	name	varchar	2147483647	√		null
bio_data_values_view	unique_id	varchar	300	√		null
browse_analyses_view	description	varchar	4000	√		null
browse_analyses_view	id	varchar	300	√		null
browse_analyses_view	measurement_type	text	2147483647	√		null
browse_analyses_view	platform_name	text	2147483647	√		null
browse_analyses_view	technology	text	2147483647	√		null
browse_analyses_view	title	varchar	500	√		null
browse_analyses_view	vendor	text	2147483647	√		null
browse_assays_view	biomarker_type	text	2147483647	√		null
browse_assays_view	description	varchar	2000	√		null
browse_assays_view	gene	text	2147483647	√		null
browse_assays_view	id	varchar	300	√		null
browse_assays_view	measurement_type	text	2147483647	√		null
browse_assays_view	mirna	text	2147483647	√		null
browse_assays_view	platform_name	text	2147483647	√		null
browse_assays_view	technology	text	2147483647	√		null
browse_assays_view	title	varchar	1000	√		null
browse_assays_view	vendor	text	2147483647	√		null
browse_folders_view	description	varchar	2000	√		null
browse_folders_view	file_type	text	2147483647	√		null
browse_folders_view	id	varchar	300	√		null
browse_folders_view	title	varchar	1000	√		null
browse_programs_view	description	varchar	2000	√		null
browse_programs_view	disease	text	2147483647	√		null
browse_programs_view	gene	text	2147483647	√		null
browse_programs_view	id	varchar	300	√		null
browse_programs_view	institution	text	2147483647	√		null
browse_programs_view	observation	text	2147483647	√		null
browse_programs_view	pathway	text	2147483647	√		null
browse_programs_view	target	text	2147483647	√		null
browse_programs_view	therapeutic_domain	text	2147483647	√		null
browse_programs_view	title	varchar	1000	√		null
browse_studies_view	access_type	varchar	100	√		null
browse_studies_view	accession	varchar	100	√		null
browse_studies_view	biomarker_type	varchar	255	√		null
browse_studies_view	compound	text	2147483647	√		null
browse_studies_view	country	varchar	1000	√		null
browse_studies_view	description	varchar	4000	√		null
browse_studies_view	design	varchar	2000	√		null
browse_studies_view	disease	text	2147483647	√		null
browse_studies_view	id	varchar	300	√		null
browse_studies_view	institution	varchar	400	√		null
browse_studies_view	organism	text	2147483647	√		null
browse_studies_view	study_objective	text	2147483647	√		null
browse_studies_view	study_phase	text	2147483647	√		null
browse_studies_view	title	varchar	1000	√		null
concept_patient_set_bitset	concept_cd	varchar	50	√		null
concept_patient_set_bitset	patient_count	int4	10	√		null
concept_patient_set_bitset	result_instance_id	numeric	5	√		null
folder_study_mapping	c_fullname	varchar	700	√		null
folder_study_mapping	folder_id	int8	19	√		null
folder_study_mapping	root	bool	1	√		null
folder_study_mapping	unique_id	varchar	300	√		null
gene_ontology	descr	varchar	500	√		null
gene_ontology	pathway	varchar	100	√		null
gene_ontology_data	gene_id	varchar	20	√		null
gene_ontology_data	gene_symbol	varchar	200	√		null
gene_ontology_data	organism	varchar	100	√		null
gene_ontology_data	pathway	varchar	100	√		null
ioe_temp_obj_reg2	kde_session	varchar	255	√		null
ioe_temp_obj_reg2	kde_username	varchar	64	√		null
ioe_temp_obj_reg2	object_created_timestamp	timestamp	22	√		null
ioe_temp_obj_reg2	object_name	varchar	32	√		null
ioe_temp_obj_reg2	object_schema	varchar	32	√		null
ioe_temp_obj_reg2	object_type	varchar	64	√		null
kde_temp_obj_reg3	kde_session	varchar	255	√		null
kde_temp_obj_reg3	kde_username	varchar	64	√		null
kde_temp_obj_reg3	object_created_timestamp	bpchar	15	√		null
kde_temp_obj_reg3	object_name	varchar	32	√		null
kde_temp_obj_reg3	object_schema	varchar	32	√		null
kde_temp_obj_reg3	object_type	varchar	64	√		null
patient_num_boundaries	diameter	numeric	131089	√		null
patient_num_boundaries	max_patient_num	numeric	131089	√		null
patient_num_boundaries	min_patient_num	numeric	131089	√		null
patient_set_bitset	patient_set	bit	-1	√		null
patient_set_bitset	result_instance_id	numeric	5	√		null
query	api_version	varchar	25	√		null	The version of the API the query was intended for.
query	bookmarked	bool	1	√		null	Flag to indicate if the user has bookmarked the query.
query	create_date	timestamp	29,6	√		null
query	deleted	bool	1	√		null	Flag to indicate if the query has been deleted.
query	id	serial	10		√	nextval('biomart_user.query_id_seq'::regclass)
query	name	varchar	1000				The query name.
query	observations_query	text	2147483647	√		null	The observation selection part of the query.
query	patients_query	text	2147483647	√		null	The patient selection part of the query.
query	query_blob	text	2147483647	√		null	Additional user preferences e.g. data table state
query	subscribed	bool	1	√		null	Flag to indicate if the user has subscribed to the query.
query	subscription_freq	varchar	25	√		null	Frequency of query notifications: "DAILY" or "WEEKLY".
query	update_date	timestamp	29,6	√		null
query	username	varchar	50				The username of the user that created the query.
query_set	create_date	timestamp	29,6				The date of the set creation.
query_set	id	serial	10		√	nextval('biomart_user.query_set_id_seq'::regclass)
query_set	query_id	int4	10				Foreign key to id in a query table.
query_set	set_size	numeric	10	√		null	The size of the set
query_set	set_type	varchar	25				The type of the set: [Patient | Sample].
query_set_diff	change_flag	varchar	7				The flag determining whether the object was added or removed from the related set
query_set_diff	id	serial	10		√	nextval('biomart_user.query_set_diff_id_seq'::regclass)
query_set_diff	object_id	numeric	38				The id of the object from the set that was updated, e.g. id of an i2b2demodata.patient_dimension instance.
query_set_diff	query_set_id	int4	10				Foreign key to id in query_set table.
query_set_instance	id	serial	10		√	nextval('biomart_user.query_set_instance_id_seq'::regclass)
query_set_instance	object_id	numeric	38				The id of the object that is being represented by the set instance, e.g. id of an i2b2demodata.patient_dimension instance.
query_set_instance	query_set_id	int4	10				Foreign key to id in query_set table.
study_concept_patient_set_bitset	concept_cd	varchar	50	√		null
study_concept_patient_set_bitset	patient_count	int4	10	√		null
study_concept_patient_set_bitset	result_instance_id	numeric	5	√		null
study_concept_patient_set_bitset	study_id	varchar	100	√		null
study_patient_set_bitset	patient_count	int4	10	√		null
study_patient_set_bitset	result_instance_id	numeric	5	√		null
study_patient_set_bitset	study_id	varchar	100	√		null