transmart.tm_wz contains 575 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
bio_assay_analysis_data_new	adjusted_p_value_code	varchar	100	√		null
bio_assay_analysis_data_new	adjusted_pvalue	float8	17,17	√		null
bio_assay_analysis_data_new	bio_assay_analysis_id	int8	19	√		null
bio_assay_analysis_data_new	bio_assay_feature_group_id	int8	19	√		null
bio_assay_analysis_data_new	bio_assay_platform_id	int8	19	√		null
bio_assay_analysis_data_new	bio_asy_analysis_data_id	int8	19	√		null
bio_assay_analysis_data_new	bio_experiment_id	int8	19	√		null
bio_assay_analysis_data_new	cut_value	float8	17,17	√		null
bio_assay_analysis_data_new	etl_id	varchar	100	√		null
bio_assay_analysis_data_new	feature_group_name	varchar	100	√		null
bio_assay_analysis_data_new	fold_change_ratio	int8	19	√		null
bio_assay_analysis_data_new	lsmean1	float8	17,17	√		null
bio_assay_analysis_data_new	lsmean2	float8	17,17	√		null
bio_assay_analysis_data_new	numeric_value	float8	17,17	√		null
bio_assay_analysis_data_new	numeric_value_code	varchar	50	√		null
bio_assay_analysis_data_new	preferred_pvalue	float8	17,17	√		null
bio_assay_analysis_data_new	r_value	float8	17,17	√		null
bio_assay_analysis_data_new	raw_pvalue	float8	17,17	√		null
bio_assay_analysis_data_new	results_value	varchar	100	√		null
bio_assay_analysis_data_new	rho_value	float8	17,17	√		null
bio_assay_analysis_data_new	tea_normalized_pvalue	float8	17,17	√		null
tmp_assay_analysis_metrics	bio_assay_analysis_id	int8	19
tmp_assay_analysis_metrics	data_ct	int8	19	√		null
tmp_assay_analysis_metrics	fc_mean	int8	19	√		null
tmp_assay_analysis_metrics	fc_stddev	int8	19	√		null
wrk_clinical_data	category_cd	varchar	250	√		null
wrk_clinical_data	category_path	varchar	1000	√		null
wrk_clinical_data	ctrl_vocab_code	varchar	200	√		null
wrk_clinical_data	data_label	varchar	500	√		null
wrk_clinical_data	data_label_components	varchar	1000	√		null
wrk_clinical_data	data_label_ctrl_vocab_code	varchar	200	√		null
wrk_clinical_data	data_type	varchar	10	√		null
wrk_clinical_data	data_value	varchar	500	√		null
wrk_clinical_data	data_value_ctrl_vocab_code	varchar	500	√		null
wrk_clinical_data	date_ind	bpchar	1	√		null
wrk_clinical_data	date_timestamp	timestamp	29,6	√		null
wrk_clinical_data	end_date	varchar	50	√		null
wrk_clinical_data	etl_date	timestamp	29,6	√		null
wrk_clinical_data	etl_job_id	numeric	22	√		null
wrk_clinical_data	leaf_node	varchar	2000	√		null
wrk_clinical_data	link_type	varchar	20	√		null
wrk_clinical_data	link_value	varchar	200	√		null
wrk_clinical_data	modifier_cd	varchar	100	√		null
wrk_clinical_data	node_name	varchar	1000	√		null
wrk_clinical_data	obs_string	varchar	100	√		null
wrk_clinical_data	rec_num	numeric	18	√		null
wrk_clinical_data	sample_cd	varchar	200	√		null
wrk_clinical_data	site_id	varchar	50	√		null
wrk_clinical_data	study_id	varchar	25	√		null
wrk_clinical_data	subject_id	varchar	100	√		null
wrk_clinical_data	units_cd	varchar	50	√		null
wrk_clinical_data	usubjid	varchar	200	√		null
wrk_clinical_data	valuetype_cd	varchar	50	√		null
wrk_clinical_data	visit_date	varchar	200	√		null
wrk_clinical_data	visit_name	varchar	100	√		null
wrk_clinical_data	visit_reference	varchar	100	√		null
wrk_mrna_data	expr_id	varchar	100	√		null
wrk_mrna_data	probeset	varchar	100	√		null
wrk_mrna_data	raw_intensity	varchar	50	√		null
wt_clinical_data_dups	category_cd	varchar	250	√		null
wt_clinical_data_dups	data_label	varchar	500	√		null
wt_clinical_data_dups	link_value	varchar	500	√		null
wt_clinical_data_dups	modifier_cd	varchar	100	√		null
wt_clinical_data_dups	site_id	varchar	50	√		null
wt_clinical_data_dups	subject_id	varchar	30	√		null
wt_clinical_data_dups	visit_name	varchar	100	√		null
wt_clinical_encounter	encounter_num	numeric	131089	√		null
wt_clinical_encounter	link_type	varchar	20	√		null
wt_clinical_encounter	link_value	varchar	500	√		null
wt_del_nodes	c_basecode	varchar	500	√		null
wt_del_nodes	c_fullname	varchar	1000	√		null
wt_folder_nodes	folder_name	varchar	2000	√		null
wt_folder_nodes	folder_path	varchar	700	√		null
wt_metabolomic_node_values	attribute_1	varchar	2000	√		null
wt_metabolomic_node_values	attribute_2	varchar	2000	√		null
wt_metabolomic_node_values	category_cd	varchar	2000	√		null
wt_metabolomic_node_values	platform	varchar	2000	√		null
wt_metabolomic_node_values	tissue_type	varchar	2000	√		null
wt_metabolomic_node_values	title	varchar	2000	√		null
wt_metabolomic_node_values	transform_method	varchar	2000	√		null
wt_metabolomic_nodes	attribute_1	varchar	2000	√		null
wt_metabolomic_nodes	attribute_2	varchar	2000	√		null
wt_metabolomic_nodes	category_cd	varchar	2000	√		null
wt_metabolomic_nodes	concept_cd	varchar	100	√		null
wt_metabolomic_nodes	leaf_node	varchar	2000	√		null
wt_metabolomic_nodes	node_name	varchar	2000	√		null
wt_metabolomic_nodes	node_type	varchar	50	√		null
wt_metabolomic_nodes	platform	varchar	2000	√		null
wt_metabolomic_nodes	tissue_type	varchar	2000	√		null
wt_metabolomic_nodes	title	varchar	2000	√		null
wt_metabolomic_nodes	transform_method	varchar	2000	√		null
wt_mixed_types	category_cd	varchar	250	√		null
wt_mixed_types	data_label	varchar	500	√		null
wt_mixed_types	visit_name	varchar	100	√		null
wt_mrna_data	expr_id	varchar	100	√		null
wt_mrna_data	intensity_value	varchar	50	√		null
wt_mrna_data	probeset	varchar	100	√		null
wt_mrna_node_values	attribute_1	varchar	2000	√		null
wt_mrna_node_values	attribute_2	varchar	2000	√		null
wt_mrna_node_values	category_cd	varchar	2000	√		null
wt_mrna_node_values	platform	varchar	2000	√		null
wt_mrna_node_values	tissue_type	varchar	2000	√		null
wt_mrna_node_values	title	varchar	2000	√		null
wt_mrna_node_values	transform_method	varchar	2000	√		null
wt_mrna_nodes	attribute_1	varchar	2000	√		null
wt_mrna_nodes	attribute_2	varchar	2000	√		null
wt_mrna_nodes	category_cd	varchar	2000	√		null
wt_mrna_nodes	concept_cd	varchar	100	√		null
wt_mrna_nodes	leaf_node	varchar	2000	√		null
wt_mrna_nodes	node_name	varchar	2000	√		null
wt_mrna_nodes	node_type	varchar	50	√		null
wt_mrna_nodes	orig_category_cd	varchar	2000	√		null
wt_mrna_nodes	platform	varchar	2000	√		null
wt_mrna_nodes	tissue_type	varchar	2000	√		null
wt_mrna_nodes	title	varchar	2000	√		null
wt_mrna_nodes	transform_method	varchar	2000	√		null
wt_mrna_subj_sample_map	attribute_1	varchar	256	√		null
wt_mrna_subj_sample_map	attribute_2	varchar	200	√		null
wt_mrna_subj_sample_map	category_cd	varchar	200	√		null
wt_mrna_subj_sample_map	platform	varchar	100	√		null
wt_mrna_subj_sample_map	sample_cd	varchar	100	√		null
wt_mrna_subj_sample_map	site_id	varchar	100	√		null
wt_mrna_subj_sample_map	subject_id	varchar	100	√		null
wt_mrna_subj_sample_map	tissue_type	varchar	100	√		null
wt_mrna_subj_sample_map	trial_name	varchar	100	√		null
wt_num_data_types	category_cd	varchar	200	√		null
wt_num_data_types	data_label	varchar	500	√		null
wt_num_data_types	sample_type	varchar	100	√		null
wt_num_data_types	visit_name	varchar	100	√		null
wt_proteomics_node_values	attribute_1	varchar	2000	√		null
wt_proteomics_node_values	attribute_2	varchar	2000	√		null
wt_proteomics_node_values	category_cd	varchar	2000	√		null
wt_proteomics_node_values	platform	varchar	2000	√		null
wt_proteomics_node_values	tissue_type	varchar	2000	√		null
wt_proteomics_node_values	title	varchar	2000	√		null
wt_proteomics_node_values	transform_method	varchar	2000	√		null
wt_proteomics_nodes	attribute_1	varchar	2000	√		null
wt_proteomics_nodes	attribute_2	varchar	2000	√		null
wt_proteomics_nodes	category_cd	varchar	2000	√		null
wt_proteomics_nodes	concept_cd	varchar	100	√		null
wt_proteomics_nodes	leaf_node	varchar	2000	√		null
wt_proteomics_nodes	node_name	varchar	2000	√		null
wt_proteomics_nodes	node_type	varchar	50	√		null
wt_proteomics_nodes	platform	varchar	2000	√		null
wt_proteomics_nodes	tissue_type	varchar	2000	√		null
wt_proteomics_nodes	title	varchar	2000	√		null
wt_proteomics_nodes	transform_method	varchar	2000	√		null
wt_qpcr_mirna_node_values	attribute_1	varchar	2000	√		null
wt_qpcr_mirna_node_values	attribute_2	varchar	2000	√		null
wt_qpcr_mirna_node_values	category_cd	varchar	2000	√		null
wt_qpcr_mirna_node_values	platform	varchar	2000	√		null
wt_qpcr_mirna_node_values	tissue_type	varchar	2000	√		null
wt_qpcr_mirna_node_values	title	varchar	2000	√		null
wt_qpcr_mirna_node_values	transform_method	varchar	2000	√		null
wt_qpcr_mirna_nodes	attribute_1	varchar	2000	√		null
wt_qpcr_mirna_nodes	attribute_2	varchar	2000	√		null
wt_qpcr_mirna_nodes	category_cd	varchar	2000	√		null
wt_qpcr_mirna_nodes	concept_cd	varchar	100	√		null
wt_qpcr_mirna_nodes	leaf_node	varchar	2000	√		null
wt_qpcr_mirna_nodes	node_name	varchar	2000	√		null
wt_qpcr_mirna_nodes	node_type	varchar	50	√		null
wt_qpcr_mirna_nodes	platform	varchar	2000	√		null
wt_qpcr_mirna_nodes	tissue_type	varchar	2000	√		null
wt_qpcr_mirna_nodes	title	varchar	2000	√		null
wt_qpcr_mirna_nodes	transform_method	varchar	2000	√		null
wt_rbm_node_values	attribute_1	varchar	2000	√		null
wt_rbm_node_values	attribute_2	varchar	2000	√		null
wt_rbm_node_values	category_cd	varchar	2000	√		null
wt_rbm_node_values	platform	varchar	2000	√		null
wt_rbm_node_values	tissue_type	varchar	2000	√		null
wt_rbm_node_values	title	varchar	2000	√		null
wt_rbm_node_values	transform_method	varchar	2000	√		null
wt_rbm_nodes	attribute_1	varchar	2000	√		null
wt_rbm_nodes	attribute_2	varchar	2000	√		null
wt_rbm_nodes	category_cd	varchar	2000	√		null
wt_rbm_nodes	concept_cd	varchar	100	√		null
wt_rbm_nodes	leaf_node	varchar	2000	√		null
wt_rbm_nodes	node_name	varchar	2000	√		null
wt_rbm_nodes	node_type	varchar	50	√		null
wt_rbm_nodes	platform	varchar	2000	√		null
wt_rbm_nodes	tissue_type	varchar	2000	√		null
wt_rbm_nodes	title	varchar	2000	√		null
wt_rbm_nodes	transform_method	varchar	2000	√		null
wt_rna_seq_node_values	attribute_1	varchar	2000	√		null
wt_rna_seq_node_values	attribute_2	varchar	2000	√		null
wt_rna_seq_node_values	category_cd	varchar	2000	√		null
wt_rna_seq_node_values	platform	varchar	2000	√		null
wt_rna_seq_node_values	tissue_type	varchar	2000	√		null
wt_rna_seq_node_values	title	varchar	2000	√		null
wt_rna_seq_node_values	transform_method	varchar	2000	√		null
wt_rna_seq_nodes	attribute_1	varchar	2000	√		null
wt_rna_seq_nodes	attribute_2	varchar	2000	√		null
wt_rna_seq_nodes	category_cd	varchar	2000	√		null
wt_rna_seq_nodes	concept_cd	varchar	100	√		null
wt_rna_seq_nodes	leaf_node	varchar	2000	√		null
wt_rna_seq_nodes	node_name	varchar	2000	√		null
wt_rna_seq_nodes	node_type	varchar	50	√		null
wt_rna_seq_nodes	platform	varchar	2000	√		null
wt_rna_seq_nodes	tissue_type	varchar	2000	√		null
wt_rna_seq_nodes	title	varchar	2000	√		null
wt_rna_seq_nodes	transform_method	varchar	2000	√		null
wt_subject_acgh_region	assay_id	int8	19	√		null
wt_subject_acgh_region	chip	float8	17,17	√		null
wt_subject_acgh_region	expr_id	varchar	500	√		null
wt_subject_acgh_region	flag	int2	5	√		null
wt_subject_acgh_region	num_calls	int8	19	√		null
wt_subject_acgh_region	patient_id	int8	19	√		null
wt_subject_acgh_region	platform	varchar	200	√		null
wt_subject_acgh_region	probamp	float8	17,17	√		null
wt_subject_acgh_region	probgain	float8	17,17	√		null
wt_subject_acgh_region	probhomloss	float8	17,17	√		null
wt_subject_acgh_region	probloss	float8	17,17	√		null
wt_subject_acgh_region	probnorm	float8	17,17	√		null
wt_subject_acgh_region	pvalue	float8	17,17	√		null
wt_subject_acgh_region	region_id	int8	19	√		null
wt_subject_acgh_region	sample_id	int8	19	√		null
wt_subject_acgh_region	sample_type	varchar	200	√		null
wt_subject_acgh_region	segmented	float8	17,17	√		null
wt_subject_acgh_region	subject_id	varchar	100	√		null
wt_subject_acgh_region	timepoint	varchar	200	√		null
wt_subject_acgh_region	tissue_type	varchar	200	√		null
wt_subject_acgh_region	trial_name	varchar	200	√		null
wt_subject_info	age_in_years_num	int2	5	√		null
wt_subject_info	race_cd	varchar	50	√		null
wt_subject_info	sex_cd	varchar	50	√		null
wt_subject_info	usubjid	varchar	107	√		null
wt_subject_mbolomics_probeset	assay_id	int8	19	√		null
wt_subject_mbolomics_probeset	expr_id	varchar	500	√		null
wt_subject_mbolomics_probeset	intensity_value	int8	19	√		null
wt_subject_mbolomics_probeset	num_calls	int8	19	√		null
wt_subject_mbolomics_probeset	patient_id	int8	19	√		null
wt_subject_mbolomics_probeset	platform	varchar	200	√		null
wt_subject_mbolomics_probeset	probeset	varchar	500	√		null
wt_subject_mbolomics_probeset	pvalue	int8	19	√		null
wt_subject_mbolomics_probeset	sample_id	varchar	100	√		null
wt_subject_mbolomics_probeset	sample_type	varchar	200	√		null
wt_subject_mbolomics_probeset	subject_id	varchar	100	√		null
wt_subject_mbolomics_probeset	timepoint	varchar	200	√		null
wt_subject_mbolomics_probeset	tissue_type	varchar	200	√		null
wt_subject_mbolomics_probeset	trial_name	varchar	200	√		null
wt_subject_metabolomics_calcs	mean_intensity	int8	19	√		null
wt_subject_metabolomics_calcs	median_intensity	int8	19	√		null
wt_subject_metabolomics_calcs	probeset	varchar	500	√		null
wt_subject_metabolomics_calcs	stddev_intensity	int8	19	√		null
wt_subject_metabolomics_calcs	trial_name	varchar	50	√		null
wt_subject_metabolomics_logs	assay_id	int8	19	√		null
wt_subject_metabolomics_logs	intensity_value	int8	19	√		null
wt_subject_metabolomics_logs	log_intensity	int8	19	√		null
wt_subject_metabolomics_logs	num_calls	int8	19	√		null
wt_subject_metabolomics_logs	patient_id	int8	19	√		null
wt_subject_metabolomics_logs	probeset	varchar	500	√		null
wt_subject_metabolomics_logs	pvalue	float8	17,17	√		null
wt_subject_metabolomics_logs	sample_id	int8	19	√		null
wt_subject_metabolomics_logs	subject_id	varchar	50	√		null
wt_subject_metabolomics_logs	timepoint	varchar	100	√		null
wt_subject_metabolomics_logs	trial_name	varchar	50	√		null
wt_subject_metabolomics_med	assay_id	int8	19	√		null
wt_subject_metabolomics_med	intensity_value	int8	19	√		null
wt_subject_metabolomics_med	log_intensity	int8	19	√		null
wt_subject_metabolomics_med	mean_intensity	int8	19	√		null
wt_subject_metabolomics_med	median_intensity	int8	19	√		null
wt_subject_metabolomics_med	num_calls	int8	19	√		null
wt_subject_metabolomics_med	patient_id	int8	19	√		null
wt_subject_metabolomics_med	probeset	varchar	500	√		null
wt_subject_metabolomics_med	pvalue	float8	17,17	√		null
wt_subject_metabolomics_med	sample_id	int8	19	√		null
wt_subject_metabolomics_med	stddev_intensity	int8	19	√		null
wt_subject_metabolomics_med	subject_id	varchar	50	√		null
wt_subject_metabolomics_med	timepoint	varchar	100	√		null
wt_subject_metabolomics_med	trial_name	varchar	50	√		null
wt_subject_metabolomics_med	zscore	int8	19	√		null
wt_subject_microarray_calcs	mean_intensity	numeric	131089	√		null
wt_subject_microarray_calcs	median_intensity	numeric	131089	√		null
wt_subject_microarray_calcs	probeset_id	int8	19	√		null
wt_subject_microarray_calcs	stddev_intensity	numeric	131089	√		null
wt_subject_microarray_calcs	trial_name	varchar	50	√		null
wt_subject_microarray_logs	assay_id	int8	19	√		null
wt_subject_microarray_logs	intensity_value	numeric	131089	√		null
wt_subject_microarray_logs	log_intensity	float8	17,17	√		null
wt_subject_microarray_logs	num_calls	numeric	131089	√		null
wt_subject_microarray_logs	patient_id	int8	19	√		null
wt_subject_microarray_logs	probeset_id	int8	19	√		null
wt_subject_microarray_logs	pvalue	float8	17,17	√		null
wt_subject_microarray_logs	raw_intensity	float8	17,17	√		null
wt_subject_microarray_logs	sample_id	int8	19	√		null
wt_subject_microarray_logs	subject_id	varchar	50	√		null
wt_subject_microarray_logs	timepoint	varchar	100	√		null
wt_subject_microarray_logs	trial_name	varchar	50	√		null
wt_subject_microarray_med	assay_id	int8	19	√		null
wt_subject_microarray_med	intensity_value	numeric	131089	√		null
wt_subject_microarray_med	log_intensity	numeric	131089	√		null
wt_subject_microarray_med	mean_intensity	numeric	131089	√		null
wt_subject_microarray_med	median_intensity	numeric	131089	√		null
wt_subject_microarray_med	num_calls	numeric	131089	√		null
wt_subject_microarray_med	patient_id	int8	19	√		null
wt_subject_microarray_med	probeset_id	int8	19	√		null
wt_subject_microarray_med	pvalue	float8	17,17	√		null
wt_subject_microarray_med	sample_id	int8	19	√		null
wt_subject_microarray_med	stddev_intensity	numeric	131089	√		null
wt_subject_microarray_med	subject_id	varchar	50	√		null
wt_subject_microarray_med	timepoint	varchar	100	√		null
wt_subject_microarray_med	trial_name	varchar	50	√		null
wt_subject_microarray_med	zscore	float8	17,17	√		null
wt_subject_mirna_calcs	mean_intensity	numeric	131089	√		null
wt_subject_mirna_calcs	median_intensity	numeric	131089	√		null
wt_subject_mirna_calcs	probeset_id	varchar	1000	√		null
wt_subject_mirna_calcs	stddev_intensity	numeric	131089	√		null
wt_subject_mirna_calcs	trial_name	varchar	50	√		null
wt_subject_mirna_logs	assay_id	numeric	18	√		null
wt_subject_mirna_logs	intensity_value	numeric	131089	√		null
wt_subject_mirna_logs	log_intensity	numeric	131089	√		null
wt_subject_mirna_logs	num_calls	numeric	131089	√		null
wt_subject_mirna_logs	patient_id	numeric	18	√		null
wt_subject_mirna_logs	probeset_id	varchar	1000	√		null
wt_subject_mirna_logs	pvalue	float8	17,17	√		null
wt_subject_mirna_logs	sample_id	numeric	18	√		null
wt_subject_mirna_logs	subject_id	varchar	50	√		null
wt_subject_mirna_logs	timepoint	varchar	100	√		null
wt_subject_mirna_logs	trial_name	varchar	50	√		null
wt_subject_mirna_med	assay_id	numeric	18	√		null
wt_subject_mirna_med	intensity_value	numeric	131089	√		null
wt_subject_mirna_med	log_intensity	numeric	131089	√		null
wt_subject_mirna_med	mean_intensity	numeric	131089	√		null
wt_subject_mirna_med	median_intensity	numeric	131089	√		null
wt_subject_mirna_med	num_calls	numeric	131089	√		null
wt_subject_mirna_med	patient_id	numeric	18	√		null
wt_subject_mirna_med	probeset_id	varchar	1000	√		null
wt_subject_mirna_med	pvalue	float8	17,17	√		null
wt_subject_mirna_med	sample_id	numeric	18	√		null
wt_subject_mirna_med	stddev_intensity	numeric	131089	√		null
wt_subject_mirna_med	subject_id	varchar	50	√		null
wt_subject_mirna_med	timepoint	varchar	100	√		null
wt_subject_mirna_med	trial_name	varchar	50	√		null
wt_subject_mirna_med	zscore	numeric	131089	√		null
wt_subject_mirna_probeset	assay_id	numeric	18	√		null
wt_subject_mirna_probeset	expr_id	varchar	500	√		null
wt_subject_mirna_probeset	intensity_value	numeric	131089	√		null
wt_subject_mirna_probeset	num_calls	numeric	131089	√		null
wt_subject_mirna_probeset	patient_id	numeric	22	√		null
wt_subject_mirna_probeset	platform	varchar	200	√		null
wt_subject_mirna_probeset	probeset_id	numeric	38	√		null
wt_subject_mirna_probeset	pvalue	numeric	131089	√		null
wt_subject_mirna_probeset	sample_id	numeric	18	√		null
wt_subject_mirna_probeset	sample_type	varchar	200	√		null
wt_subject_mirna_probeset	subject_id	varchar	100	√		null
wt_subject_mirna_probeset	timepoint	varchar	200	√		null
wt_subject_mirna_probeset	tissue_type	varchar	200	√		null
wt_subject_mirna_probeset	trial_name	varchar	200	√		null
wt_subject_mrna_data	assay_id	int8	19	√		null
wt_subject_mrna_data	expr_id	varchar	500	√		null
wt_subject_mrna_data	intensity_value	numeric	131089	√		null
wt_subject_mrna_data	patient_id	int8	19	√		null
wt_subject_mrna_data	platform	varchar	200	√		null
wt_subject_mrna_data	probeset	varchar	500	√		null
wt_subject_mrna_data	sample_id	int8	19	√		null
wt_subject_mrna_data	sample_type	varchar	200	√		null
wt_subject_mrna_data	subject_id	varchar	100	√		null
wt_subject_mrna_data	timepoint	varchar	200	√		null
wt_subject_mrna_data	tissue_type	varchar	200	√		null
wt_subject_mrna_data	trial_name	varchar	200	√		null
wt_subject_mrna_probeset	assay_id	int8	19	√		null
wt_subject_mrna_probeset	expr_id	varchar	500	√		null
wt_subject_mrna_probeset	intensity_value	float8	17,17	√		null
wt_subject_mrna_probeset	num_calls	int8	19	√		null
wt_subject_mrna_probeset	patient_id	int8	19	√		null
wt_subject_mrna_probeset	platform	varchar	200	√		null
wt_subject_mrna_probeset	probeset_id	int8	19	√		null
wt_subject_mrna_probeset	pvalue	numeric	131089	√		null
wt_subject_mrna_probeset	sample_id	int8	19	√		null
wt_subject_mrna_probeset	sample_type	varchar	200	√		null
wt_subject_mrna_probeset	subject_id	varchar	100	√		null
wt_subject_mrna_probeset	timepoint	varchar	200	√		null
wt_subject_mrna_probeset	tissue_type	varchar	200	√		null
wt_subject_mrna_probeset	trial_name	varchar	200	√		null
wt_subject_proteomics_calcs	mean_intensity	numeric	131089	√		null
wt_subject_proteomics_calcs	median_intensity	numeric	131089	√		null
wt_subject_proteomics_calcs	probeset_id	varchar	500	√		null
wt_subject_proteomics_calcs	stddev_intensity	numeric	131089	√		null
wt_subject_proteomics_calcs	trial_name	varchar	50	√		null
wt_subject_proteomics_logs	assay_id	numeric	18	√		null
wt_subject_proteomics_logs	intensity_value	numeric	131089	√		null
wt_subject_proteomics_logs	log_intensity	numeric	131089	√		null
wt_subject_proteomics_logs	num_calls	numeric	131089	√		null
wt_subject_proteomics_logs	patient_id	numeric	18	√		null
wt_subject_proteomics_logs	probeset_id	varchar	500	√		null
wt_subject_proteomics_logs	pvalue	float8	17,17	√		null
wt_subject_proteomics_logs	sample_id	numeric	18	√		null
wt_subject_proteomics_logs	subject_id	varchar	50	√		null
wt_subject_proteomics_logs	timepoint	varchar	100	√		null
wt_subject_proteomics_logs	trial_name	varchar	50	√		null
wt_subject_proteomics_med	assay_id	numeric	18	√		null
wt_subject_proteomics_med	intensity_value	numeric	131089	√		null
wt_subject_proteomics_med	log_intensity	numeric	131089	√		null
wt_subject_proteomics_med	mean_intensity	numeric	131089	√		null
wt_subject_proteomics_med	median_intensity	numeric	131089	√		null
wt_subject_proteomics_med	num_calls	numeric	131089	√		null
wt_subject_proteomics_med	patient_id	numeric	18	√		null
wt_subject_proteomics_med	probeset_id	varchar	500	√		null
wt_subject_proteomics_med	pvalue	float8	17,17	√		null
wt_subject_proteomics_med	sample_id	numeric	18	√		null
wt_subject_proteomics_med	stddev_intensity	numeric	131089	√		null
wt_subject_proteomics_med	subject_id	varchar	50	√		null
wt_subject_proteomics_med	timepoint	varchar	100	√		null
wt_subject_proteomics_med	trial_name	varchar	50	√		null
wt_subject_proteomics_med	zscore	numeric	131089	√		null
wt_subject_proteomics_probeset	assay_id	numeric	18	√		null
wt_subject_proteomics_probeset	expr_id	varchar	500	√		null
wt_subject_proteomics_probeset	intensity_value	numeric	131089	√		null
wt_subject_proteomics_probeset	num_calls	numeric	131089	√		null
wt_subject_proteomics_probeset	patient_id	numeric	22	√		null
wt_subject_proteomics_probeset	platform	varchar	200	√		null
wt_subject_proteomics_probeset	probeset	varchar	500	√		null
wt_subject_proteomics_probeset	pvalue	numeric	131089	√		null
wt_subject_proteomics_probeset	sample_id	varchar	100	√		null
wt_subject_proteomics_probeset	sample_type	varchar	200	√		null
wt_subject_proteomics_probeset	subject_id	varchar	100	√		null
wt_subject_proteomics_probeset	timepoint	varchar	200	√		null
wt_subject_proteomics_probeset	tissue_type	varchar	200	√		null
wt_subject_proteomics_probeset	trial_name	varchar	200	√		null
wt_subject_rbm_calcs	mean_intensity	int8	19	√		null
wt_subject_rbm_calcs	median_intensity	int8	19	√		null
wt_subject_rbm_calcs	probeset_id	varchar	1000	√		null
wt_subject_rbm_calcs	stddev_intensity	int8	19	√		null
wt_subject_rbm_calcs	trial_name	varchar	50	√		null
wt_subject_rbm_logs	assay_id	int8	19	√		null
wt_subject_rbm_logs	intensity_value	int8	19	√		null
wt_subject_rbm_logs	log_intensity	int8	19	√		null
wt_subject_rbm_logs	num_calls	int8	19	√		null
wt_subject_rbm_logs	patient_id	int8	19	√		null
wt_subject_rbm_logs	probeset_id	varchar	1000	√		null
wt_subject_rbm_logs	pvalue	float8	17,17	√		null
wt_subject_rbm_logs	sample_id	int8	19	√		null
wt_subject_rbm_logs	subject_id	varchar	50	√		null
wt_subject_rbm_logs	timepoint	varchar	100	√		null
wt_subject_rbm_logs	trial_name	varchar	50	√		null
wt_subject_rbm_med	assay_id	int8	19	√		null
wt_subject_rbm_med	intensity_value	int8	19	√		null
wt_subject_rbm_med	log_intensity	int8	19	√		null
wt_subject_rbm_med	mean_intensity	int8	19	√		null
wt_subject_rbm_med	median_intensity	int8	19	√		null
wt_subject_rbm_med	num_calls	int8	19	√		null
wt_subject_rbm_med	patient_id	int8	19	√		null
wt_subject_rbm_med	probeset_id	varchar	1000	√		null
wt_subject_rbm_med	pvalue	float8	17,17	√		null
wt_subject_rbm_med	sample_id	int8	19	√		null
wt_subject_rbm_med	stddev_intensity	int8	19	√		null
wt_subject_rbm_med	subject_id	varchar	50	√		null
wt_subject_rbm_med	timepoint	varchar	100	√		null
wt_subject_rbm_med	trial_name	varchar	50	√		null
wt_subject_rbm_med	zscore	int8	19	√		null
wt_subject_rbm_probeset	assay_id	int8	19	√		null
wt_subject_rbm_probeset	expr_id	varchar	500	√		null
wt_subject_rbm_probeset	intensity_value	int8	19	√		null
wt_subject_rbm_probeset	num_calls	int8	19	√		null
wt_subject_rbm_probeset	patient_id	int8	19	√		null
wt_subject_rbm_probeset	platform	varchar	200	√		null
wt_subject_rbm_probeset	probeset	varchar	1000	√		null
wt_subject_rbm_probeset	pvalue	int8	19	√		null
wt_subject_rbm_probeset	sample_id	varchar	100	√		null
wt_subject_rbm_probeset	sample_type	varchar	200	√		null
wt_subject_rbm_probeset	subject_id	varchar	100	√		null
wt_subject_rbm_probeset	timepoint	varchar	200	√		null
wt_subject_rbm_probeset	tissue_type	varchar	200	√		null
wt_subject_rbm_probeset	trial_name	varchar	200	√		null
wt_subject_rna_calcs	mean_intensity	int8	19	√		null
wt_subject_rna_calcs	median_intensity	int8	19	√		null
wt_subject_rna_calcs	probeset_id	varchar	200	√		null
wt_subject_rna_calcs	stddev_intensity	int8	19	√		null
wt_subject_rna_calcs	trial_name	varchar	50	√		null
wt_subject_rna_logs	assay_id	int8	19	√		null
wt_subject_rna_logs	intensity_value	int8	19	√		null
wt_subject_rna_logs	log_intensity	int8	19	√		null
wt_subject_rna_logs	num_calls	int8	19	√		null
wt_subject_rna_logs	patient_id	int8	19	√		null
wt_subject_rna_logs	probeset_id	varchar	200	√		null
wt_subject_rna_logs	pvalue	float8	17,17	√		null
wt_subject_rna_logs	sample_id	int8	19	√		null
wt_subject_rna_logs	subject_id	varchar	50	√		null
wt_subject_rna_logs	timepoint	varchar	100	√		null
wt_subject_rna_logs	trial_name	varchar	50	√		null
wt_subject_rna_med	assay_id	int8	19	√		null
wt_subject_rna_med	intensity_value	int8	19	√		null
wt_subject_rna_med	log_intensity	int8	19	√		null
wt_subject_rna_med	mean_intensity	int8	19	√		null
wt_subject_rna_med	median_intensity	int8	19	√		null
wt_subject_rna_med	num_calls	int8	19	√		null
wt_subject_rna_med	patient_id	int8	19	√		null
wt_subject_rna_med	probeset_id	varchar	200	√		null
wt_subject_rna_med	pvalue	float8	17,17	√		null
wt_subject_rna_med	sample_id	int8	19	√		null
wt_subject_rna_med	stddev_intensity	int8	19	√		null
wt_subject_rna_med	subject_id	varchar	50	√		null
wt_subject_rna_med	timepoint	varchar	100	√		null
wt_subject_rna_med	trial_name	varchar	50	√		null
wt_subject_rna_med	zscore	int8	19	√		null
wt_subject_rna_probeset	assay_id	int8	19	√		null
wt_subject_rna_probeset	expr_id	varchar	500	√		null
wt_subject_rna_probeset	intensity_value	int8	19	√		null
wt_subject_rna_probeset	num_calls	int8	19	√		null
wt_subject_rna_probeset	patient_id	int8	19	√		null
wt_subject_rna_probeset	platform	varchar	200	√		null
wt_subject_rna_probeset	probeset_id	varchar	200	√		null
wt_subject_rna_probeset	pvalue	int8	19	√		null
wt_subject_rna_probeset	sample_id	int8	19	√		null
wt_subject_rna_probeset	sample_type	varchar	200	√		null
wt_subject_rna_probeset	subject_id	varchar	100	√		null
wt_subject_rna_probeset	timepoint	varchar	200	√		null
wt_subject_rna_probeset	tissue_type	varchar	200	√		null
wt_subject_rna_probeset	trial_name	varchar	200	√		null
wt_subject_rnaseq_calcs	mean_readcount	numeric	131089	√		null
wt_subject_rnaseq_calcs	median_readcount	numeric	131089	√		null
wt_subject_rnaseq_calcs	region_id	int8	19	√		null
wt_subject_rnaseq_calcs	stddev_readcount	numeric	131089	√		null
wt_subject_rnaseq_logs	assay_id	int8	19	√		null
wt_subject_rnaseq_logs	log_readcount	numeric	131089	√		null
wt_subject_rnaseq_logs	patient_id	int8	19	√		null
wt_subject_rnaseq_logs	raw_readcount	numeric	131089	√		null
wt_subject_rnaseq_logs	readcount	int8	19	√		null
wt_subject_rnaseq_logs	region_id	int8	19	√		null
wt_subject_rnaseq_logs	trial_name	varchar	200	√		null
wt_subject_rnaseq_region	assay_id	int8	19	√		null
wt_subject_rnaseq_region	expr_id	varchar	500	√		null
wt_subject_rnaseq_region	normalized_readcount	float8	17,17	√		null
wt_subject_rnaseq_region	patient_id	int8	19	√		null
wt_subject_rnaseq_region	platform	varchar	200	√		null
wt_subject_rnaseq_region	readcount	int8	19	√		null
wt_subject_rnaseq_region	region_id	int8	19	√		null
wt_subject_rnaseq_region	sample_id	int8	19	√		null
wt_subject_rnaseq_region	sample_type	varchar	200	√		null
wt_subject_rnaseq_region	subject_id	varchar	100	√		null
wt_subject_rnaseq_region	timepoint	varchar	200	√		null
wt_subject_rnaseq_region	tissue_type	varchar	200	√		null
wt_subject_rnaseq_region	trial_name	varchar	200	√		null
wt_subject_sample_mapping	category_cd	varchar	1000	√		null
wt_subject_sample_mapping	concept_code	varchar	50	√		null
wt_subject_sample_mapping	data_uid	varchar	100	√		null
wt_subject_sample_mapping	gpl_id	varchar	20	√		null
wt_subject_sample_mapping	patient_num	numeric	38	√		null
wt_subject_sample_mapping	platform	varchar	50	√		null
wt_subject_sample_mapping	platform_cd	varchar	50	√		null
wt_subject_sample_mapping	sample_cd	varchar	200	√		null
wt_subject_sample_mapping	sample_type	varchar	100	√		null
wt_subject_sample_mapping	sample_type_cd	varchar	100	√		null
wt_subject_sample_mapping	site_id	varchar	100	√		null
wt_subject_sample_mapping	subject_id	varchar	100	√		null
wt_subject_sample_mapping	timepoint	varchar	100	√		null
wt_subject_sample_mapping	timepoint_cd	varchar	50	√		null
wt_subject_sample_mapping	tissue_type	varchar	100	√		null
wt_subject_sample_mapping	tissue_type_cd	varchar	50	√		null
wt_trial_nodes	category_cd	varchar	250	√		null
wt_trial_nodes	data_label	varchar	500	√		null
wt_trial_nodes	data_label_components	varchar	1000	√		null
wt_trial_nodes	data_label_ctrl_vocab_code	varchar	500	√		null
wt_trial_nodes	data_type	varchar	20	√		null
wt_trial_nodes	data_value	varchar	500	√		null
wt_trial_nodes	data_value_ctrl_vocab_code	varchar	500	√		null
wt_trial_nodes	leaf_node	varchar	4000	√		null
wt_trial_nodes	link_type	varchar	50	√		null
wt_trial_nodes	node_name	varchar	500	√		null
wt_trial_nodes	obs_string	varchar	100	√		null
wt_trial_nodes	rec_num	numeric	131089	√		null
wt_trial_nodes	sample_type	varchar	100	√		null
wt_trial_nodes	valuetype_cd	varchar	50	√		null
wt_trial_nodes	visit_name	varchar	100	√		null
wt_vocab_nodes	label_instance	numeric	18	√		null
wt_vocab_nodes	label_node	varchar	1000	√		null
wt_vocab_nodes	leaf_node	varchar	1000	√		null
wt_vocab_nodes	modifier_cd	varchar	100	√		null
wt_vocab_nodes	value_instance	numeric	18	√		null
wt_xtrial_nodes	concept_cd	varchar	200	√		null
wt_xtrial_nodes	data_type	varchar	10	√		null
wt_xtrial_nodes	leaf_name	varchar	200	√		null
wt_xtrial_nodes	leaf_node	varchar	2000	√		null
wt_xtrial_nodes	trial_name	varchar	200	√		null
wt_xtrial_nodes	xtrial_cd	varchar	200	√		null