transmart.biomart contains 1933 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
annotation	gene_descr	varchar	4000	√		null
annotation	gene_id	varchar	50	√		null
annotation	gene_symbol	varchar	4000	√		null
annotation	id	int8	19
annotation	organism	varchar	200	√		null
annotation	platform	varchar	50	√		null
annotation	probeset	varchar	50	√		null
assay_analysis_data	adjusted_pvalue	float8	17,17	√		null
assay_analysis_data	bio_assay_analysis_id	int8	19	√		null
assay_analysis_data	bio_assay_feature_group_id	int8	19	√		null
assay_analysis_data	bio_assay_platform_id	int8	19	√		null
assay_analysis_data	bio_asy_analysis_data_id	int8	19
assay_analysis_data	bio_experiment_id	int8	19	√		null
assay_analysis_data	feature_group_name	varchar	100	√		null
assay_analysis_data	fold_change_ratio	int8	19	√		null
assay_analysis_data	preferred_pvalue	float8	17,17	√		null
assay_analysis_data	raw_pvalue	float8	17,17	√		null
assay_analysis_data	tea_normalized_pvalue	float8	17,17	√		null
bio_ad_hoc_property	ad_hoc_property_id	int8	19
bio_ad_hoc_property	bio_data_id	int8	19	√		null
bio_ad_hoc_property	property_key	varchar	50	√		null
bio_ad_hoc_property	property_value	varchar	2000	√		null
bio_analysis_attribute	bio_analysis_attribute_id	int8	19
bio_analysis_attribute	bio_assay_analysis_id	int8	19
bio_analysis_attribute	source_cd	varchar	255	√		null
bio_analysis_attribute	study_id	varchar	255	√		null
bio_analysis_attribute	term_id	int8	19	√		null
bio_analysis_attribute_lineage	ancestor_search_keyword_id	int8	19
bio_analysis_attribute_lineage	ancestor_term_id	int8	19
bio_analysis_attribute_lineage	bio_analysis_att_lineage_id	int8	19
bio_analysis_attribute_lineage	bio_analysis_attribute_id	int8	19
bio_analysis_cohort_xref	analysis_cd	varchar	255	√		null
bio_analysis_cohort_xref	bio_assay_analysis_id	int8	19
bio_analysis_cohort_xref	cohort_id	varchar	255	√		null
bio_analysis_cohort_xref	study_id	varchar	255	√		null
bio_assay	bio_assay_id	int8	19
bio_assay	bio_assay_platform_id	int8	19	√		null
bio_assay	bio_assay_type	varchar	200
bio_assay	biomarkers_studied	varchar	200	√		null
bio_assay	biomarkers_type	varchar	200	√		null
bio_assay	biosource	varchar	200	√		null
bio_assay	description	text	2147483647	√		null
bio_assay	etl_id	varchar	100
bio_assay	experiment_id	int8	19
bio_assay	measurement_type	varchar	200	√		null
bio_assay	platform_design	varchar	200	√		null
bio_assay	protocol	varchar	200	√		null
bio_assay	requestor	varchar	200	√		null
bio_assay	sample_receive_date	timestamp	29,6	√		null
bio_assay	sample_type	varchar	200	√		null
bio_assay	study	varchar	200	√		null
bio_assay	technology	varchar	200	√		null
bio_assay	test_date	timestamp	29,6	√		null
bio_assay	vendor	varchar	200	√		null
bio_assay_analysis	analysis_create_date	timestamp	29,6	√		null
bio_assay_analysis	analysis_method_cd	varchar	50	√		null
bio_assay_analysis	analysis_name	varchar	500	√		null
bio_assay_analysis	analysis_type	varchar	200	√		null
bio_assay_analysis	analysis_update_date	date	13	√		null
bio_assay_analysis	analysis_version	varchar	200	√		null
bio_assay_analysis	analyst_id	varchar	510	√		null
bio_assay_analysis	analyst_name	varchar	250	√		null
bio_assay_analysis	bio_assay_analysis_id	int8	19
bio_assay_analysis	bio_assay_data_type	varchar	50	√		null
bio_assay_analysis	bio_asy_analysis_pltfm_id	int8	19	√		null
bio_assay_analysis	bio_source_import_id	int8	19	√		null
bio_assay_analysis	created_by	varchar	30	√		null
bio_assay_analysis	data_count	int8	19	√		null
bio_assay_analysis	etl_id	varchar	100	√		null
bio_assay_analysis	etl_id_source	int8	19	√		null
bio_assay_analysis	fold_change_cutoff	float8	17,17	√		null
bio_assay_analysis	long_description	varchar	4000	√		null
bio_assay_analysis	lsmean_cutoff	float8	17,17	√		null
bio_assay_analysis	modified_by	varchar	30	√		null
bio_assay_analysis	pvalue_cutoff	float8	17,17	√		null
bio_assay_analysis	qa_criteria	varchar	4000	√		null
bio_assay_analysis	rvalue_cutoff	float8	17,17	√		null
bio_assay_analysis	short_description	varchar	510	√		null
bio_assay_analysis	tea_data_count	int8	19	√		null
bio_assay_analysis	update_of	numeric	18	√		null
bio_assay_analysis_data	adjusted_p_value_code	varchar	100	√		null
bio_assay_analysis_data	adjusted_pvalue	float8	17,17	√		null
bio_assay_analysis_data	bio_assay_analysis_id	int8	19
bio_assay_analysis_data	bio_assay_feature_group_id	int8	19	√		null
bio_assay_analysis_data	bio_assay_platform_id	int8	19	√		null
bio_assay_analysis_data	bio_asy_analysis_data_id	int8	19
bio_assay_analysis_data	bio_experiment_id	int8	19	√		null
bio_assay_analysis_data	cut_value	float8	17,17	√		null
bio_assay_analysis_data	etl_id	varchar	100	√		null
bio_assay_analysis_data	feature_group_name	varchar	100
bio_assay_analysis_data	fold_change_ratio	int8	19	√		null
bio_assay_analysis_data	lsmean1	float8	17,17	√		null
bio_assay_analysis_data	lsmean2	float8	17,17	√		null
bio_assay_analysis_data	numeric_value	float8	17,17	√		null
bio_assay_analysis_data	numeric_value_code	varchar	50	√		null
bio_assay_analysis_data	preferred_pvalue	float8	17,17	√		null
bio_assay_analysis_data	probeset_id	int8	19	√		null
bio_assay_analysis_data	r_value	float8	17,17	√		null
bio_assay_analysis_data	raw_pvalue	float8	17,17	√		null
bio_assay_analysis_data	results_value	varchar	100	√		null
bio_assay_analysis_data	rho_value	float8	17,17	√		null
bio_assay_analysis_data	tea_normalized_pvalue	float8	17,17	√		null
bio_assay_analysis_data_tea	adjusted_p_value_code	varchar	100	√		null
bio_assay_analysis_data_tea	adjusted_pvalue	float8	17,17	√		null
bio_assay_analysis_data_tea	bio_assay_analysis_id	int8	19
bio_assay_analysis_data_tea	bio_assay_feature_group_id	int8	19	√		null
bio_assay_analysis_data_tea	bio_assay_platform_id	int8	19	√		null
bio_assay_analysis_data_tea	bio_asy_analysis_data_id	int8	19
bio_assay_analysis_data_tea	bio_experiment_id	int8	19	√		null
bio_assay_analysis_data_tea	bio_experiment_type	varchar	50	√		null
bio_assay_analysis_data_tea	cut_value	float8	17,17	√		null
bio_assay_analysis_data_tea	etl_id	varchar	100	√		null
bio_assay_analysis_data_tea	feature_group_name	varchar	100
bio_assay_analysis_data_tea	fold_change_ratio	int8	19	√		null
bio_assay_analysis_data_tea	numeric_value	float8	17,17	√		null
bio_assay_analysis_data_tea	numeric_value_code	varchar	50	√		null
bio_assay_analysis_data_tea	preferred_pvalue	float8	17,17	√		null
bio_assay_analysis_data_tea	probeset_id	int8	19	√		null
bio_assay_analysis_data_tea	r_value	float8	17,17	√		null
bio_assay_analysis_data_tea	raw_pvalue	float8	17,17	√		null
bio_assay_analysis_data_tea	results_value	varchar	100	√		null
bio_assay_analysis_data_tea	rho_value	float8	17,17	√		null
bio_assay_analysis_data_tea	tea_normalized_pvalue	float8	17,17	√		null
bio_assay_analysis_data_tea	tea_rank	int8	19	√		null
bio_assay_analysis_eqtl	bio_assay_analysis_id	int8	19	√		null
bio_assay_analysis_eqtl	bio_asy_analysis_eqtl_id	int8	19
bio_assay_analysis_eqtl	cis_trans	varchar	10	√		null
bio_assay_analysis_eqtl	distance_from_gene	varchar	10	√		null
bio_assay_analysis_eqtl	etl_id	int8	19	√		null
bio_assay_analysis_eqtl	ext_data	varchar	4000	√		null
bio_assay_analysis_eqtl	gene	varchar	50	√		null
bio_assay_analysis_eqtl	log_p_value	float8	17,17	√		null
bio_assay_analysis_eqtl	p_value	float8	17,17	√		null
bio_assay_analysis_eqtl	p_value_char	varchar	100	√		null
bio_assay_analysis_eqtl	rs_id	varchar	50	√		null
bio_assay_analysis_ext	bio_assay_analysis_ext_id	int8	19
bio_assay_analysis_ext	bio_assay_analysis_id	int8	19
bio_assay_analysis_ext	cell_type	varchar	500	√		null
bio_assay_analysis_ext	data_owner	varchar	100	√		null
bio_assay_analysis_ext	effect_error1_type	varchar	100	√		null
bio_assay_analysis_ext	effect_error2_type	varchar	100	√		null
bio_assay_analysis_ext	effect_error_desc	varchar	1000	√		null
bio_assay_analysis_ext	effect_type	varchar	100	√		null
bio_assay_analysis_ext	effect_units	varchar	100	√		null
bio_assay_analysis_ext	genome_version	varchar	500	√		null
bio_assay_analysis_ext	model_desc	varchar	500	√		null
bio_assay_analysis_ext	model_name	varchar	100	√		null
bio_assay_analysis_ext	population	varchar	500	√		null
bio_assay_analysis_ext	requestor	varchar	100	√		null
bio_assay_analysis_ext	research_unit	varchar	500	√		null
bio_assay_analysis_ext	sample_size	varchar	500	√		null
bio_assay_analysis_ext	sd_trait_population	numeric	131089	√		null
bio_assay_analysis_ext	sensitive_desc	varchar	500	√		null
bio_assay_analysis_ext	sensitive_flag	int4	10	√		null
bio_assay_analysis_ext	tissue	varchar	500	√		null
bio_assay_analysis_ext	trait	varchar	255	√		null
bio_assay_analysis_ext	vendor	varchar	500	√		null
bio_assay_analysis_ext	vendor_type	varchar	500	√		null
bio_assay_analysis_gwas	beta	float8	17,17	√		null
bio_assay_analysis_gwas	beta_old	numeric	131089	√		null
bio_assay_analysis_gwas	bio_assay_analysis_id	int8	19	√		null
bio_assay_analysis_gwas	bio_asy_analysis_gwas_id	int8	19
bio_assay_analysis_gwas	bio_asy_geno_platform_probe_id	int8	19	√		null
bio_assay_analysis_gwas	created_by	varchar	30	√		null
bio_assay_analysis_gwas	created_date	date	13	√		null
bio_assay_analysis_gwas	effect_allele	varchar	30	√		null
bio_assay_analysis_gwas	effect_allele_clob	text	2147483647	√		null
bio_assay_analysis_gwas	etl_id	int8	19	√		null
bio_assay_analysis_gwas	ext_data	varchar	4000	√		null
bio_assay_analysis_gwas	geno_platform_probe_id	numeric	22	√		null
bio_assay_analysis_gwas	log_p_value	float8	17,17	√		null
bio_assay_analysis_gwas	modified_by	varchar	30	√		null
bio_assay_analysis_gwas	modified_date	date	13	√		null
bio_assay_analysis_gwas	other_allele	varchar	30	√		null
bio_assay_analysis_gwas	other_allele_clob	text	2147483647	√		null
bio_assay_analysis_gwas	p_value	float8	17,17	√		null
bio_assay_analysis_gwas	p_value_char	varchar	100	√		null
bio_assay_analysis_gwas	pass_fail	varchar	1	√		null
bio_assay_analysis_gwas	probe_name	varchar	100	√		null
bio_assay_analysis_gwas	rs_id	varchar	50	√		null
bio_assay_analysis_gwas	standard_error	float8	17,17	√		null
bio_assay_analysis_gwas	standard_error_old	numeric	131089	√		null
bio_assay_cohort	bio_assay_cohort_id	int8	19
bio_assay_cohort	cohort_id	varchar	500	√		null
bio_assay_cohort	cohort_title	varchar	500	√		null
bio_assay_cohort	disease	varchar	500	√		null
bio_assay_cohort	import_date	timestamp	29,6
bio_assay_cohort	long_desc	varchar	500	√		null
bio_assay_cohort	organism	varchar	500	√		null
bio_assay_cohort	pathology	varchar	500	√		null
bio_assay_cohort	sample_type	varchar	500	√		null
bio_assay_cohort	short_desc	varchar	500	√		null
bio_assay_cohort	study_id	varchar	500	√		null
bio_assay_cohort	treatment	varchar	500	√		null
bio_assay_data	bio_assay_data_id	int8	19
bio_assay_data	bio_assay_dataset_id	int8	19	√		null
bio_assay_data	bio_assay_id	int8	19	√		null
bio_assay_data	bio_experiment_id	int8	19	√		null
bio_assay_data	bio_sample_id	int8	19	√		null
bio_assay_data	etl_id	int8	19	√		null
bio_assay_data	feature_group_name	varchar	100
bio_assay_data	float_value	float8	17,17	√		null
bio_assay_data	log10_value	float8	17,17	√		null
bio_assay_data	log2_value	float8	17,17	√		null
bio_assay_data	numeric_value	int8	19	√		null
bio_assay_data	text_value	varchar	200	√		null
bio_assay_data_annotation	bio_assay_feature_group_id	int8	19	√		null
bio_assay_data_annotation	bio_marker_id	int8	19
bio_assay_data_annotation	data_table	bpchar	5	√		null
bio_assay_data_stats	bio_assay_data_stats_id	int8	19
bio_assay_data_stats	bio_assay_dataset_id	int8	19	√		null
bio_assay_data_stats	bio_assay_feature_group_id	int8	19
bio_assay_data_stats	bio_experiment_id	int8	19	√		null
bio_assay_data_stats	bio_sample_count	int8	19	√		null
bio_assay_data_stats	bio_sample_id	int8	19	√		null
bio_assay_data_stats	feature_group_name	varchar	120	√		null
bio_assay_data_stats	max_value	float8	17,17	√		null
bio_assay_data_stats	mean_value	float8	17,17	√		null
bio_assay_data_stats	min_value	float8	17,17	√		null
bio_assay_data_stats	quartile_1	float8	17,17	√		null
bio_assay_data_stats	quartile_2	float8	17,17	√		null
bio_assay_data_stats	quartile_3	float8	17,17	√		null
bio_assay_data_stats	std_dev_value	float8	17,17	√		null
bio_assay_data_stats	value_normalize_method	varchar	50	√		null
bio_assay_dataset	accession	varchar	50	√		null
bio_assay_dataset	bio_assay_dataset_id	int8	19
bio_assay_dataset	bio_assay_id	int8	19	√		null
bio_assay_dataset	bio_experiment_id	int8	19
bio_assay_dataset	create_date	timestamp	29,6	√		null
bio_assay_dataset	dataset_criteria	varchar	1000	√		null
bio_assay_dataset	dataset_description	varchar	1000	√		null
bio_assay_dataset	dataset_name	varchar	400	√		null
bio_assay_dataset	etl_id	varchar	100	√		null
bio_assay_feature_group	bio_assay_feature_group_id	int8	19
bio_assay_feature_group	feature_group_name	varchar	100
bio_assay_feature_group	feature_group_type	varchar	50
bio_assay_geno_platform_probe	bio_assay_platform_id	int8	19
bio_assay_geno_platform_probe	bio_asy_geno_platform_probe_id	numeric	18
bio_assay_geno_platform_probe	created_by	varchar	30	√		null
bio_assay_geno_platform_probe	created_date	date	13	√		null
bio_assay_geno_platform_probe	is_control	bool	1	√		null
bio_assay_geno_platform_probe	modified_by	varchar	30	√		null
bio_assay_geno_platform_probe	modified_date	date	13	√		null
bio_assay_geno_platform_probe	orig_chrom	varchar	5	√		null
bio_assay_geno_platform_probe	orig_genome_build	varchar	20	√		null
bio_assay_geno_platform_probe	orig_position	numeric	131089	√		null
bio_assay_geno_platform_probe	probe_name	varchar	200	√		null
bio_assay_platform	bio_assay_platform_id	int8	19
bio_assay_platform	created_by	varchar	30	√		null
bio_assay_platform	created_date	date	13	√		null
bio_assay_platform	modified_by	varchar	30	√		null
bio_assay_platform	modified_date	date	13	√		null
bio_assay_platform	platform_accession	varchar	20	√		null
bio_assay_platform	platform_array	varchar	50	√		null
bio_assay_platform	platform_description	varchar	2000	√		null
bio_assay_platform	platform_imputed	bool	1	√		null
bio_assay_platform	platform_imputed_algorithm	varchar	500	√		null
bio_assay_platform	platform_imputed_panel	varchar	200	√		null
bio_assay_platform	platform_name	varchar	200	√		null
bio_assay_platform	platform_organism	varchar	200	√		null
bio_assay_platform	platform_technology	varchar	200	√		null
bio_assay_platform	platform_type	varchar	200	√		null
bio_assay_platform	platform_vendor	varchar	200	√		null
bio_assay_platform	platform_version	varchar	200	√		null
bio_assay_sample	bio_assay_id	int8	19
bio_assay_sample	bio_clinic_trial_timepoint_id	int8	19
bio_assay_sample	bio_sample_id	int8	19
bio_asy_analysis_data_ext	bio_asy_analysis_data_id	int8	19
bio_asy_analysis_data_ext	ext_data	varchar	4000
bio_asy_analysis_data_ext	ext_type	varchar	20
bio_asy_analysis_data_idx	bio_asy_analysis_data_idx_id	int8	19
bio_asy_analysis_data_idx	display_idx	numeric	10
bio_asy_analysis_data_idx	display_name	varchar	255
bio_asy_analysis_data_idx	ext_type	varchar	255
bio_asy_analysis_data_idx	field_idx	numeric	10
bio_asy_analysis_data_idx	field_name	varchar	255
bio_asy_analysis_dataset	bio_assay_analysis_id	int8	19
bio_asy_analysis_dataset	bio_assay_dataset_id	int8	19
bio_asy_analysis_eqtl_top50	analysis	varchar	500	√		null
bio_asy_analysis_eqtl_top50	bio_assay_analysis_id	int8	19	√		null
bio_asy_analysis_eqtl_top50	chrom	varchar	4	√		null
bio_asy_analysis_eqtl_top50	extdata	varchar	4000	√		null
bio_asy_analysis_eqtl_top50	gene	varchar	50	√		null
bio_asy_analysis_eqtl_top50	intronexon	varchar	10	√		null
bio_asy_analysis_eqtl_top50	logpvalue	float8	17,17	√		null
bio_asy_analysis_eqtl_top50	pos	numeric	10	√		null
bio_asy_analysis_eqtl_top50	pvalue	float8	17,17	√		null
bio_asy_analysis_eqtl_top50	pvalue_char	varchar	100	√		null
bio_asy_analysis_eqtl_top50	recombinationrate	numeric	18,6	√		null
bio_asy_analysis_eqtl_top50	regulome	varchar	10	√		null
bio_asy_analysis_eqtl_top50	rnum	int8	19	√		null
bio_asy_analysis_eqtl_top50	rsgene	varchar	200	√		null
bio_asy_analysis_eqtl_top50	rsid	varchar	50	√		null
bio_asy_analysis_eqtl_top50	strand	bool	1	√		null
bio_asy_analysis_gwas_top50	analysis	varchar	500	√		null
bio_asy_analysis_gwas_top50	beta	float8	17,17	√		null
bio_asy_analysis_gwas_top50	bio_assay_analysis_id	int8	19	√		null
bio_asy_analysis_gwas_top50	chrom	varchar	4	√		null
bio_asy_analysis_gwas_top50	effect_allele	varchar	30	√		null
bio_asy_analysis_gwas_top50	extdata	varchar	4000	√		null
bio_asy_analysis_gwas_top50	intronexon	varchar	10	√		null
bio_asy_analysis_gwas_top50	logpvalue	float8	17,17	√		null
bio_asy_analysis_gwas_top50	other_allele	varchar	30	√		null
bio_asy_analysis_gwas_top50	pos	numeric	10	√		null
bio_asy_analysis_gwas_top50	pvalue	float8	17,17	√		null
bio_asy_analysis_gwas_top50	recombinationrate	numeric	18,6	√		null
bio_asy_analysis_gwas_top50	regulome	varchar	10	√		null
bio_asy_analysis_gwas_top50	rnum	int8	19	√		null
bio_asy_analysis_gwas_top50	rsgene	varchar	200	√		null
bio_asy_analysis_gwas_top50	rsid	varchar	50	√		null
bio_asy_analysis_gwas_top50	standard_error	float8	17,17	√		null
bio_asy_analysis_gwas_top50	strand	varchar	1	√		null
bio_asy_analysis_pltfm	bio_asy_analysis_pltfm_id	int8	19
bio_asy_analysis_pltfm	platform_description	varchar	1000	√		null
bio_asy_analysis_pltfm	platform_name	varchar	200	√		null
bio_asy_analysis_pltfm	platform_version	varchar	200	√		null
bio_asy_data_stats_all	bio_assay_data_stats_id	int8	19
bio_asy_data_stats_all	bio_assay_dataset_id	int8	19	√		null
bio_asy_data_stats_all	bio_experiment_id	int8	19	√		null
bio_asy_data_stats_all	bio_sample_count	int8	19	√		null
bio_asy_data_stats_all	bio_sample_id	int8	19	√		null
bio_asy_data_stats_all	feature_group_name	varchar	120	√		null
bio_asy_data_stats_all	max_value	float8	17,17	√		null
bio_asy_data_stats_all	mean_value	float8	17,17	√		null
bio_asy_data_stats_all	min_value	float8	17,17	√		null
bio_asy_data_stats_all	quartile_1	float8	17,17	√		null
bio_asy_data_stats_all	quartile_2	float8	17,17	√		null
bio_asy_data_stats_all	quartile_3	float8	17,17	√		null
bio_asy_data_stats_all	std_dev_value	float8	17,17	√		null
bio_asy_data_stats_all	value_normalize_method	varchar	50	√		null
bio_asy_platform_probe_anno	bio_assay_platform_id	int8	19
bio_asy_platform_probe_anno	bio_asy_geno_platform_probe_id	numeric	22
bio_asy_platform_probe_anno	bio_asy_platform_probe_anno_id	numeric	22
bio_asy_platform_probe_anno	created_by	varchar	30	√		null
bio_asy_platform_probe_anno	created_date	date	13	√		null
bio_asy_platform_probe_anno	genome_build	varchar	10	√		null
bio_asy_platform_probe_anno	genotype_probe_annotation_id	numeric	22
bio_asy_platform_probe_anno	modified_by	varchar	30	√		null
bio_asy_platform_probe_anno	modified_date	date	13	√		null
bio_cell_line	attc_number	varchar	510	√		null
bio_cell_line	bio_cell_line_id	int8	19
bio_cell_line	bio_disease_id	int8	19	√		null
bio_cell_line	cell_line_name	varchar	510	√		null
bio_cell_line	description	varchar	500	√		null
bio_cell_line	disease	varchar	510	√		null
bio_cell_line	disease_stage	varchar	100	√		null
bio_cell_line	disease_subtype	varchar	200	√		null
bio_cell_line	etl_reference_link	varchar	300	√		null
bio_cell_line	metastatic_site	varchar	510	√		null
bio_cell_line	origin	varchar	200	√		null
bio_cell_line	primary_site	varchar	510	√		null
bio_cell_line	species	varchar	510	√		null
bio_cgdcp_data	bio_data_id	int8	19
bio_cgdcp_data	cell_line_id	int8	19	√		null
bio_cgdcp_data	evidence_code	varchar	200	√		null
bio_cgdcp_data	nci_disease_concept_code	varchar	200	√		null
bio_cgdcp_data	nci_drug_concept_code	varchar	200	√		null
bio_cgdcp_data	nci_role_code	varchar	200	√		null
bio_cgdcp_data	negation_indicator	bpchar	1	√		null
bio_clinc_trial_attr	bio_clinc_trial_attr_id	int8	19
bio_clinc_trial_attr	bio_experiment_id	int8	19
bio_clinc_trial_attr	property_code	varchar	200
bio_clinc_trial_attr	property_value	varchar	200	√		null
bio_clinc_trial_pt_group	bio_clinical_trial_p_group_id	int8	19
bio_clinc_trial_pt_group	bio_experiment_id	int8	19
bio_clinc_trial_pt_group	description	varchar	1000	√		null
bio_clinc_trial_pt_group	name	varchar	510	√		null
bio_clinc_trial_pt_group	number_of_patients	int4	10	√		null
bio_clinc_trial_pt_group	patient_group_type_code	varchar	200	√		null
bio_clinc_trial_time_pt	bio_clinc_trial_tm_pt_id	int8	19
bio_clinc_trial_time_pt	bio_experiment_id	int8	19
bio_clinc_trial_time_pt	end_date	timestamp	29,6	√		null
bio_clinc_trial_time_pt	start_date	timestamp	29,6	√		null
bio_clinc_trial_time_pt	time_point	varchar	200	√		null
bio_clinc_trial_time_pt	time_point_code	varchar	200	√		null
bio_clinical_trial	bio_experiment_id	int8	19
bio_clinical_trial	blinding_procedure	varchar	1000	√		null
bio_clinical_trial	completion_date	timestamp	29,6	√		null
bio_clinical_trial	development_partner	varchar	100	√		null
bio_clinical_trial	dosing_regimen	varchar	3500	√		null
bio_clinical_trial	duration_of_study_weeks	int4	10	√		null
bio_clinical_trial	exclusion_criteria	text	2147483647	√		null
bio_clinical_trial	gender_restriction_mfb	varchar	510	√		null
bio_clinical_trial	geo_platform	varchar	30	√		null
bio_clinical_trial	group_assignment	varchar	510	√		null
bio_clinical_trial	inclusion_criteria	text	2147483647	√		null
bio_clinical_trial	main_findings	varchar	2000	√		null
bio_clinical_trial	max_age	int4	10	√		null
bio_clinical_trial	min_age	int4	10	√		null
bio_clinical_trial	number_of_patients	int4	10	√		null
bio_clinical_trial	number_of_sites	int4	10	√		null
bio_clinical_trial	platform_name	varchar	200	√		null
bio_clinical_trial	primary_end_points	varchar	2000	√		null
bio_clinical_trial	route_of_administration	varchar	510	√		null
bio_clinical_trial	search_area	varchar	100	√		null
bio_clinical_trial	secondary_end_points	varchar	3500	√		null
bio_clinical_trial	secondary_ids	varchar	510	√		null
bio_clinical_trial	study_owner	varchar	510	√		null
bio_clinical_trial	study_phase	varchar	100	√		null
bio_clinical_trial	studytype	varchar	510	√		null
bio_clinical_trial	subjects	varchar	2000	√		null
bio_clinical_trial	trial_number	varchar	510	√		null
bio_clinical_trial	type_of_control	varchar	510	√		null
bio_clinical_trial_design	abs_change_from_baseline	varchar	4000	√		null
bio_clinical_trial_design	adverse_effects	varchar	4000	√		null
bio_clinical_trial_design	arm	varchar	4000	√		null
bio_clinical_trial_design	arm_age	varchar	4000	√		null
bio_clinical_trial_design	arm_asthma_duration	varchar	4000	√		null
bio_clinical_trial_design	arm_classification_type	varchar	4000	√		null
bio_clinical_trial_design	arm_classification_value	varchar	4000	√		null
bio_clinical_trial_design	arm_former_smokers_pct	varchar	4000	√		null
bio_clinical_trial_design	arm_gender	varchar	4000	√		null
bio_clinical_trial_design	arm_geographic_region	varchar	4000	√		null
bio_clinical_trial_design	arm_nbr_of_patients_studied	varchar	4000	√		null
bio_clinical_trial_design	arm_never_smokers_pct	varchar	4000	√		null
bio_clinical_trial_design	arm_pack_years	varchar	4000	√		null
bio_clinical_trial_design	arm_smokers_pct	varchar	4000	√		null
bio_clinical_trial_design	asthma_diagnosis	varchar	4000	√		null
bio_clinical_trial_design	asthma_phenotype	varchar	4000	√		null
bio_clinical_trial_design	average_over_treatment_period	varchar	4000	√		null
bio_clinical_trial_design	baseline_expr_number	varchar	4000	√		null
bio_clinical_trial_design	baseline_expr_pct	varchar	4000	√		null
bio_clinical_trial_design	baseline_expr_sd	varchar	4000	√		null
bio_clinical_trial_design	baseline_expr_sem	varchar	4000	√		null
bio_clinical_trial_design	baseline_expr_unit	varchar	4000	√		null
bio_clinical_trial_design	baseline_expr_value_fold_mean	varchar	4000	√		null
bio_clinical_trial_design	baseline_rescue_medication_use	varchar	4000	√		null
bio_clinical_trial_design	baseline_symptom_score	varchar	4000	√		null
bio_clinical_trial_design	beneficial_effects	varchar	4000	√		null
bio_clinical_trial_design	biomarker	varchar	4000	√		null
bio_clinical_trial_design	biomarker_name	varchar	4000	√		null
bio_clinical_trial_design	biomarker_pct	varchar	4000	√		null
bio_clinical_trial_design	biomarker_type	varchar	4000	√		null
bio_clinical_trial_design	biomarkervalue	varchar	4000	√		null
bio_clinical_trial_design	biomolecule_id	varchar	4000	√		null
bio_clinical_trial_design	biomolecule_name	varchar	4000	√		null
bio_clinical_trial_design	biomolecule_type	varchar	4000	√		null
bio_clinical_trial_design	biopsy	varchar	4000	√		null
bio_clinical_trial_design	blinded_trial	varchar	4000	√		null
bio_clinical_trial_design	blinding_procedure	varchar	4000	√		null
bio_clinical_trial_design	cellinfo_count	varchar	4000	√		null
bio_clinical_trial_design	cellinfo_source	varchar	4000	√		null
bio_clinical_trial_design	cellinfo_type	varchar	4000	√		null
bio_clinical_trial_design	clinical_correlation	varchar	4000	√		null
bio_clinical_trial_design	clinical_variable	varchar	4000	√		null
bio_clinical_trial_design	clinical_variable_name	varchar	4000	√		null
bio_clinical_trial_design	clinical_variable_pct	varchar	4000	√		null
bio_clinical_trial_design	clinical_variable_value	varchar	4000	√		null
bio_clinical_trial_design	common_name	varchar	4000	√		null
bio_clinical_trial_design	comparator_dose	varchar	4000	√		null
bio_clinical_trial_design	comparator_name	varchar	4000	√		null
bio_clinical_trial_design	comparator_route_of_admin	varchar	4000	√		null
bio_clinical_trial_design	comparator_time_period	varchar	4000	√		null
bio_clinical_trial_design	concomitant_med	varchar	4000	√		null
bio_clinical_trial_design	control_details	varchar	4000	√		null
bio_clinical_trial_design	definition_of_the_event	varchar	4000	√		null
bio_clinical_trial_design	description	varchar	4000	√		null
bio_clinical_trial_design	difficult_to_treat	varchar	4000	√		null
bio_clinical_trial_design	discontinuation_rate	varchar	4000	√		null
bio_clinical_trial_design	disease_severity	varchar	4000	√		null
bio_clinical_trial_design	disease_type	varchar	4000	√		null
bio_clinical_trial_design	dlco	varchar	4000	√		null
bio_clinical_trial_design	downstream_signaling_effects	varchar	4000	√		null
bio_clinical_trial_design	drug_inhibitor_cas_id	varchar	4000	√		null
bio_clinical_trial_design	drug_inhibitor_common_name	varchar	4000	√		null
bio_clinical_trial_design	drug_inhibitor_dose	varchar	4000	√		null
bio_clinical_trial_design	drug_inhibitor_route_of_admin	varchar	4000	√		null
bio_clinical_trial_design	drug_inhibitor_standard_name	varchar	4000	√		null
bio_clinical_trial_design	drug_inhibitor_trtmt_regime	varchar	4000	√		null
bio_clinical_trial_design	dyspnea_on_exertion	varchar	4000	√		null
bio_clinical_trial_design	effect_description	varchar	4000	√		null
bio_clinical_trial_design	event_description	varchar	4000	√		null
bio_clinical_trial_design	event_p_value	varchar	4000	√		null
bio_clinical_trial_design	event_pct_reduction	varchar	4000	√		null
bio_clinical_trial_design	event_rate	varchar	4000	√		null
bio_clinical_trial_design	exclusion_criteria	varchar	4000	√		null
bio_clinical_trial_design	experiment_description	varchar	4000	√		null
bio_clinical_trial_design	expr_after_trtmt_number	varchar	4000	√		null
bio_clinical_trial_design	expr_after_trtmt_pct	varchar	4000	√		null
bio_clinical_trial_design	expr_after_trtmt_sd	varchar	4000	√		null
bio_clinical_trial_design	expr_after_trtmt_sem	varchar	4000	√		null
bio_clinical_trial_design	expr_after_trtmt_unit	varchar	4000	√		null
bio_clinical_trial_design	expr_aftertrtmt_valuefold_mean	varchar	4000	√		null
bio_clinical_trial_design	expr_chg_description	varchar	4000	√		null
bio_clinical_trial_design	expr_chg_source_type	varchar	4000	√		null
bio_clinical_trial_design	expr_chg_technique	varchar	4000	√		null
bio_clinical_trial_design	fev1	varchar	4000	√		null
bio_clinical_trial_design	fev1_fvc	varchar	4000	√		null
bio_clinical_trial_design	fev1_reversibility	varchar	4000	√		null
bio_clinical_trial_design	fvc	varchar	4000	√		null
bio_clinical_trial_design	hrct	varchar	4000	√		null
bio_clinical_trial_design	icd10	varchar	4000	√		null
bio_clinical_trial_design	inhaled_steroid_dose	varchar	4000	√		null
bio_clinical_trial_design	laba	varchar	4000	√		null
bio_clinical_trial_design	ltra_inhibitors	varchar	4000	√		null
bio_clinical_trial_design	mesh	varchar	4000	√		null
bio_clinical_trial_design	minimal_symptoms	varchar	4000	√		null
bio_clinical_trial_design	minority_participation	varchar	4000	√		null
bio_clinical_trial_design	nature_of_trial	varchar	4000	√		null
bio_clinical_trial_design	number_of_arms	varchar	4000	√		null
bio_clinical_trial_design	number_of_events	varchar	4000	√		null
bio_clinical_trial_design	ocs	varchar	4000	√		null
bio_clinical_trial_design	open_label_extension	varchar	4000	√		null
bio_clinical_trial_design	pct_change_from_baseline	varchar	4000	√		null
bio_clinical_trial_design	physiology_name	varchar	4000	√		null
bio_clinical_trial_design	pk_pd_parameter	varchar	4000	√		null
bio_clinical_trial_design	pk_pd_value	varchar	4000	√		null
bio_clinical_trial_design	placebo	varchar	4000	√		null
bio_clinical_trial_design	primary_endpoint_change	varchar	4000	√		null
bio_clinical_trial_design	primary_endpoint_definition	varchar	4000	√		null
bio_clinical_trial_design	primary_endpoint_p_value	varchar	4000	√		null
bio_clinical_trial_design	primary_endpoint_stat_test	varchar	4000	√		null
bio_clinical_trial_design	primary_endpoint_time_period	varchar	4000	√		null
bio_clinical_trial_design	primary_endpoint_type	varchar	4000	√		null
bio_clinical_trial_design	prior_med_drug_name	varchar	4000	√		null
bio_clinical_trial_design	prior_med_pct	varchar	4000	√		null
bio_clinical_trial_design	prior_med_value	varchar	4000	√		null
bio_clinical_trial_design	pulmonary_pathology_name	varchar	4000	√		null
bio_clinical_trial_design	pulmpath_method	varchar	4000	√		null
bio_clinical_trial_design	pulmpath_patient_pct	varchar	4000	√		null
bio_clinical_trial_design	pulmpath_value_unit	varchar	4000	√		null
bio_clinical_trial_design	randomization	varchar	4000	√		null
bio_clinical_trial_design	rate_of_change_from_baseline	varchar	4000	√		null
bio_clinical_trial_design	ref_article_pmid	varchar	4000	√		null
bio_clinical_trial_design	ref_back_reference	varchar	4000	√		null
bio_clinical_trial_design	ref_id	varchar	4000	√		null
bio_clinical_trial_design	ref_protocol_id	varchar	4000	√		null
bio_clinical_trial_design	ref_record_id	varchar	4000	√		null
bio_clinical_trial_design	ref_title	varchar	4000	√		null
bio_clinical_trial_design	rescue_medication_use	varchar	4000	√		null
bio_clinical_trial_design	response_rate	varchar	4000	√		null
bio_clinical_trial_design	run_n_period	varchar	4000	√		null
bio_clinical_trial_design	runin_anti_fibrotics	varchar	4000	√		null
bio_clinical_trial_design	runin_corticosteroids	varchar	4000	√		null
bio_clinical_trial_design	runin_cytotoxic	varchar	4000	√		null
bio_clinical_trial_design	runin_description	varchar	4000	√		null
bio_clinical_trial_design	runin_ics	varchar	4000	√		null
bio_clinical_trial_design	runin_immunosuppressive	varchar	4000	√		null
bio_clinical_trial_design	runin_laba	varchar	4000	√		null
bio_clinical_trial_design	runin_ltra	varchar	4000	√		null
bio_clinical_trial_design	runin_ocs	varchar	4000	√		null
bio_clinical_trial_design	secondary_type	varchar	4000	√		null
bio_clinical_trial_design	secondary_type_change	varchar	4000	√		null
bio_clinical_trial_design	secondary_type_definition	varchar	4000	√		null
bio_clinical_trial_design	secondary_type_p_value	varchar	4000	√		null
bio_clinical_trial_design	secondary_type_stat_test	varchar	4000	√		null
bio_clinical_trial_design	secondary_type_time_period	varchar	4000	√		null
bio_clinical_trial_design	sgrq	varchar	4000	√		null
bio_clinical_trial_design	source_type	varchar	4000	√		null
bio_clinical_trial_design	sponsor	varchar	4000	√		null
bio_clinical_trial_design	stat_measure_p_value	varchar	4000	√		null
bio_clinical_trial_design	statistical_coefficient_value	varchar	4000	√		null
bio_clinical_trial_design	statistical_test	varchar	4000	√		null
bio_clinical_trial_design	statistical_test_description	varchar	4000	√		null
bio_clinical_trial_design	statistical_test_p_value	varchar	4000	√		null
bio_clinical_trial_design	study_type	varchar	4000	√		null
bio_clinical_trial_design	time_to_event	varchar	4000	√		null
bio_clinical_trial_design	tlc	varchar	4000	√		null
bio_clinical_trial_design	treatment_period	varchar	4000	√		null
bio_clinical_trial_design	treatment_regime	varchar	4000	√		null
bio_clinical_trial_design	trial_age	varchar	4000	√		null
bio_clinical_trial_design	trial_former_smokers_pct	varchar	4000	√		null
bio_clinical_trial_design	trial_nbr_of_patients_studied	varchar	4000	√		null
bio_clinical_trial_design	trial_never_smokers_pct	varchar	4000	√		null
bio_clinical_trial_design	trial_pack_years	varchar	4000	√		null
bio_clinical_trial_design	trial_phase	varchar	4000	√		null
bio_clinical_trial_design	trial_smokers_pct	varchar	4000	√		null
bio_clinical_trial_design	trial_status	varchar	4000	√		null
bio_clinical_trial_design	trial_type	varchar	4000	√		null
bio_clinical_trial_design	trtmt_anti_fibrotics	varchar	4000	√		null
bio_clinical_trial_design	trtmt_corticosteroids	varchar	4000	√		null
bio_clinical_trial_design	trtmt_cytotoxic	varchar	4000	√		null
bio_clinical_trial_design	trtmt_description	varchar	4000	√		null
bio_clinical_trial_design	trtmt_ics	varchar	4000	√		null
bio_clinical_trial_design	trtmt_immunosuppressive	varchar	4000	√		null
bio_clinical_trial_design	trtmt_laba	varchar	4000	√		null
bio_clinical_trial_design	trtmt_ltra	varchar	4000	√		null
bio_clinical_trial_design	trtmt_ocs	varchar	4000	√		null
bio_clinical_trial_design	washout_period	varchar	4000	√		null
bio_clinical_trial_design	within_group_changes	varchar	4000	√		null
bio_clinical_trial_design	xolair	varchar	4000	√		null
bio_cohort_exp_xref	cohort_id	varchar	255	√		null
bio_cohort_exp_xref	exp_id	varchar	255	√		null
bio_cohort_exp_xref	study_id	varchar	255	√		null
bio_compound	bio_compound_id	int8	19
bio_compound	brand_name	varchar	200	√		null
bio_compound	cas_registry	varchar	400	√		null
bio_compound	chemical_name	varchar	1000	√		null
bio_compound	cnto_number	varchar	200	√		null
bio_compound	code_name	varchar	300	√		null
bio_compound	description	varchar	1000	√		null
bio_compound	etl_id	varchar	50	√		null
bio_compound	etl_id_retired	int8	19	√		null
bio_compound	generic_name	varchar	200	√		null
bio_compound	jnj_number	varchar	200	√		null
bio_compound	mechanism	varchar	400	√		null
bio_compound	product_category	varchar	200	√		null
bio_compound	source_cd	varchar	100	√		null
bio_concept_code	bio_concept_code	varchar	200	√		null
bio_concept_code	bio_concept_code_id	int8	19
bio_concept_code	code_description	varchar	1000	√		null
bio_concept_code	code_name	varchar	200	√		null
bio_concept_code	code_type_name	varchar	200	√		null
bio_concept_code	filter_flag	bpchar	1	√		0
bio_content	abstract	varchar	2000	√		null
bio_content	bio_file_content_id	int8	19
bio_content	cel_file_suffix	varchar	30	√		null
bio_content	cel_location	varchar	300	√		null
bio_content	etl_id	int8	19	√		null
bio_content	etl_id_c	varchar	30	√		null
bio_content	file_name	varchar	1000	√		null
bio_content	file_type	varchar	200
bio_content	location	varchar	400	√		null
bio_content	repository_id	int8	19	√		null
bio_content	study_name	varchar	30	√		null
bio_content	title	varchar	1000	√		null
bio_content_reference	bio_content_id	int8	19
bio_content_reference	bio_content_reference_id	int8	19
bio_content_reference	bio_data_id	int8	19
bio_content_reference	content_reference_type	varchar	200
bio_content_reference	etl_id	int8	19	√		null
bio_content_reference	etl_id_c	varchar	30	√		null
bio_content_repository	active_y_n	bpchar	1	√		null
bio_content_repository	bio_content_repo_id	int8	19
bio_content_repository	location	varchar	510	√		null
bio_content_repository	location_type	varchar	200	√		null
bio_content_repository	repository_type	varchar	200
bio_curated_data	bio_curation_dataset_id	int8	19
bio_curated_data	bio_data_id	int8	19
bio_curated_data	data_type	varchar	200	√		null
bio_curated_data	reference_id	int8	19	√		null
bio_curated_data	statement	text	2147483647	√		null
bio_curated_data	statement_status	varchar	200	√		null
bio_curation_dataset	bio_asy_analysis_pltfm_id	int8	19	√		null
bio_curation_dataset	bio_curation_dataset_id	int8	19
bio_curation_dataset	bio_curation_name	varchar	500	√		null
bio_curation_dataset	bio_curation_type	varchar	200
bio_curation_dataset	bio_source_import_id	int8	19	√		null
bio_curation_dataset	create_date	timestamp	29,6	√		null
bio_curation_dataset	creator	int8	19	√		null
bio_curation_dataset	data_type	varchar	100	√		null
bio_data_attribute	bio_data_attribute_id	int8	19
bio_data_attribute	bio_data_id	int8	19
bio_data_attribute	property_code	varchar	200
bio_data_attribute	property_unit	varchar	100	√		null
bio_data_attribute	property_value	varchar	200	√		null
bio_data_compound	bio_compound_id	int8	19
bio_data_compound	bio_data_id	int8	19
bio_data_compound	etl_source	varchar	100	√		null
bio_data_correl_descr	bio_data_correl_descr_id	int8	19
bio_data_correl_descr	correlation	varchar	510	√		null
bio_data_correl_descr	description	varchar	1000	√		null
bio_data_correl_descr	source	varchar	100	√		null
bio_data_correl_descr	source_code	varchar	200	√		null
bio_data_correl_descr	status	varchar	200	√		null
bio_data_correl_descr	type_name	varchar	200	√		null
bio_data_correlation	asso_bio_data_id	int8	19
bio_data_correlation	bio_data_correl_descr_id	int8	19
bio_data_correlation	bio_data_correl_id	int8	19
bio_data_correlation	bio_data_id	int8	19
bio_data_disease	bio_data_id	int8	19
bio_data_disease	bio_disease_id	int8	19
bio_data_disease	etl_source	varchar	100	√		null
bio_data_ext_code	bio_data_ext_code_id	int8	19
bio_data_ext_code	bio_data_id	int8	19
bio_data_ext_code	bio_data_type	varchar	100	√		null
bio_data_ext_code	code	varchar	500
bio_data_ext_code	code_source	varchar	200	√		null
bio_data_ext_code	code_type	varchar	200	√		null
bio_data_ext_code	etl_id	varchar	50	√		null
bio_data_literature	bio_curation_dataset_id	int8	19
bio_data_literature	bio_data_id	int8	19
bio_data_literature	bio_lit_ref_data_id	int8	19	√		null
bio_data_literature	data_type	varchar	200	√		null
bio_data_literature	statement	text	2147483647	√		null
bio_data_literature	statement_status	varchar	200	√		null
bio_data_observation	bio_data_id	int8	19	√		null
bio_data_observation	bio_observation_id	int8	19	√		null
bio_data_observation	etl_source	varchar	100	√		null
bio_data_omic_marker	bio_data_id	int8	19	√		null
bio_data_omic_marker	bio_marker_id	int8	19
bio_data_omic_marker	data_table	varchar	5	√		null
bio_data_platform	bio_assay_platform_id	int8	19	√		null
bio_data_platform	bio_data_id	int8	19	√		null
bio_data_platform	etl_source	varchar	100	√		null
bio_data_taxonomy	bio_data_id	int8	19
bio_data_taxonomy	bio_taxonomy_id	int8	19
bio_data_taxonomy	etl_source	varchar	100	√		null
bio_data_uid	bio_data_id	int8	19
bio_data_uid	bio_data_type	varchar	100
bio_data_uid	unique_id	varchar	300
bio_disease	bio_disease_id	int8	19
bio_disease	ccs_category	varchar	510	√		null
bio_disease	disease	varchar	510
bio_disease	etl_id	varchar	50	√		null
bio_disease	etl_id_retired	int8	19	√		null
bio_disease	icd10_code	varchar	510	√		null
bio_disease	icd9_code	varchar	510	√		null
bio_disease	mesh_code	varchar	510	√		null
bio_disease	prefered_name	varchar	510	√		null
bio_disease	primary_source_cd	varchar	30	√		null
bio_experiment	access_type	varchar	100	√		null
bio_experiment	accession	varchar	100	√		null
bio_experiment	bio_experiment_id	int8	19
bio_experiment	bio_experiment_type	varchar	200	√		null
bio_experiment	biomarker_type	varchar	255	√		null
bio_experiment	completion_date	timestamp	29,6	√		null
bio_experiment	contact_field	varchar	400	√		null
bio_experiment	country	varchar	1000	√		null
bio_experiment	description	varchar	4000	√		null
bio_experiment	design	varchar	2000	√		null
bio_experiment	entrydt	timestamp	29,6	√		null
bio_experiment	etl_id	varchar	100	√		null
bio_experiment	institution	varchar	400	√		null
bio_experiment	overall_design	varchar	2000	√		null
bio_experiment	primary_investigator	varchar	400	√		null
bio_experiment	start_date	timestamp	29,6	√		null
bio_experiment	status	varchar	100	√		null
bio_experiment	target	varchar	255	√		null
bio_experiment	title	varchar	1000	√		null
bio_experiment	updated	timestamp	29,6	√		null
bio_lit_alt_data	alteration_type	varchar	50	√		null
bio_lit_alt_data	bio_lit_alt_data_id	int8	19
bio_lit_alt_data	bio_lit_ref_data_id	int8	19
bio_lit_alt_data	clin_asm_marker_type	varchar	250	√		null
bio_lit_alt_data	clin_asm_unit	varchar	250	√		null
bio_lit_alt_data	clin_asm_value	varchar	250	√		null
bio_lit_alt_data	clin_atopy	varchar	250	√		null
bio_lit_alt_data	clin_baseline_percent	varchar	250	√		null
bio_lit_alt_data	clin_baseline_value	varchar	250	√		null
bio_lit_alt_data	clin_baseline_variable	varchar	250	√		null
bio_lit_alt_data	clin_cellular_count	varchar	250	√		null
bio_lit_alt_data	clin_cellular_source	varchar	250	√		null
bio_lit_alt_data	clin_cellular_type	varchar	250	√		null
bio_lit_alt_data	clin_prior_med_dose	varchar	250	√		null
bio_lit_alt_data	clin_prior_med_name	varchar	250	√		null
bio_lit_alt_data	clin_prior_med_percent	varchar	250	√		null
bio_lit_alt_data	clin_smoker	varchar	250	√		null
bio_lit_alt_data	clin_submucosa_marker_type	varchar	250	√		null
bio_lit_alt_data	clin_submucosa_unit	varchar	250	√		null
bio_lit_alt_data	clin_submucosa_value	varchar	250	√		null
bio_lit_alt_data	control	varchar	1000	√		null
bio_lit_alt_data	control_exp_number	varchar	50	√		null
bio_lit_alt_data	control_exp_percent	varchar	50	√		null
bio_lit_alt_data	control_exp_sd	varchar	50	√		null
bio_lit_alt_data	control_exp_unit	varchar	100	√		null
bio_lit_alt_data	control_exp_value	varchar	50	√		null
bio_lit_alt_data	description	varchar	1000	√		null
bio_lit_alt_data	effect	varchar	500	√		null
bio_lit_alt_data	epigenetic_region	varchar	250	√		null
bio_lit_alt_data	epigenetic_type	varchar	250	√		null
bio_lit_alt_data	etl_id	varchar	50	√		null
bio_lit_alt_data	glc_control_percent	varchar	250	√		null
bio_lit_alt_data	glc_molecular_change	varchar	250	√		null
bio_lit_alt_data	glc_number	varchar	100	√		null
bio_lit_alt_data	glc_percent	varchar	100	√		null
bio_lit_alt_data	glc_type	varchar	50	√		null
bio_lit_alt_data	in_vitro_model_id	int8	19	√		null
bio_lit_alt_data	in_vivo_model_id	int8	19	√		null
bio_lit_alt_data	loh_loci	varchar	250	√		null
bio_lit_alt_data	loss_exp_number	varchar	50	√		null
bio_lit_alt_data	loss_exp_percent	varchar	50	√		null
bio_lit_alt_data	loss_exp_sd	varchar	50	√		null
bio_lit_alt_data	loss_exp_unit	varchar	100	√		null
bio_lit_alt_data	loss_exp_value	varchar	50	√		null
bio_lit_alt_data	mutation_change	varchar	250	√		null
bio_lit_alt_data	mutation_sites	varchar	250	√		null
bio_lit_alt_data	mutation_type	varchar	250	√		null
bio_lit_alt_data	over_exp_number	varchar	50	√		null
bio_lit_alt_data	over_exp_percent	varchar	50	√		null
bio_lit_alt_data	over_exp_sd	varchar	50	√		null
bio_lit_alt_data	over_exp_unit	varchar	100	√		null
bio_lit_alt_data	over_exp_value	varchar	50	√		null
bio_lit_alt_data	patients_number	varchar	500	√		null
bio_lit_alt_data	patients_percent	varchar	500	√		null
bio_lit_alt_data	pop_body_substance	varchar	250	√		null
bio_lit_alt_data	pop_cell_type	varchar	250	√		null
bio_lit_alt_data	pop_description	varchar	1000	√		null
bio_lit_alt_data	pop_exclusion_criteria	varchar	1000	√		null
bio_lit_alt_data	pop_experimental_model	varchar	250	√		null
bio_lit_alt_data	pop_inclusion_criteria	varchar	1000	√		null
bio_lit_alt_data	pop_localization	varchar	1000	√		null
bio_lit_alt_data	pop_number	varchar	250	√		null
bio_lit_alt_data	pop_phase	varchar	250	√		null
bio_lit_alt_data	pop_status	varchar	250	√		null
bio_lit_alt_data	pop_tissue	varchar	250	√		null
bio_lit_alt_data	pop_type	varchar	250	√		null
bio_lit_alt_data	pop_value	varchar	250	√		null
bio_lit_alt_data	ptm_change	varchar	250	√		null
bio_lit_alt_data	ptm_region	varchar	250	√		null
bio_lit_alt_data	ptm_type	varchar	250	√		null
bio_lit_alt_data	techniques	varchar	1000	√		null
bio_lit_alt_data	total_exp_number	varchar	50	√		null
bio_lit_alt_data	total_exp_percent	varchar	50	√		null
bio_lit_alt_data	total_exp_sd	varchar	50	√		null
bio_lit_alt_data	total_exp_unit	varchar	100	√		null
bio_lit_alt_data	total_exp_value	varchar	50	√		null
bio_lit_amd_data	bio_lit_alt_data_id	int8	19
bio_lit_amd_data	bio_lit_amd_data_id	int8	19
bio_lit_amd_data	co_exp_number	varchar	100	√		null
bio_lit_amd_data	co_exp_percent	varchar	50	√		null
bio_lit_amd_data	co_exp_sd	varchar	50	√		null
bio_lit_amd_data	co_exp_unit	varchar	50	√		null
bio_lit_amd_data	co_exp_value	varchar	100	√		null
bio_lit_amd_data	description	varchar	1000	√		null
bio_lit_amd_data	etl_id	varchar	50	√		null
bio_lit_amd_data	molecule	varchar	50	√		null
bio_lit_amd_data	molecule_type	varchar	50	√		null
bio_lit_amd_data	mutation_change	varchar	50	√		null
bio_lit_amd_data	mutation_number	varchar	100	√		null
bio_lit_amd_data	mutation_percent	varchar	50	√		null
bio_lit_amd_data	mutation_sites	varchar	50	√		null
bio_lit_amd_data	mutation_type	varchar	50	√		null
bio_lit_amd_data	over_exp_number	varchar	100	√		null
bio_lit_amd_data	over_exp_percent	varchar	50	√		null
bio_lit_amd_data	over_exp_sd	varchar	50	√		null
bio_lit_amd_data	over_exp_unit	varchar	50	√		null
bio_lit_amd_data	over_exp_value	varchar	100	√		null
bio_lit_amd_data	target_exp_number	varchar	100	√		null
bio_lit_amd_data	target_exp_percent	varchar	50	√		null
bio_lit_amd_data	target_exp_sd	varchar	50	√		null
bio_lit_amd_data	target_exp_unit	varchar	50	√		null
bio_lit_amd_data	target_exp_value	varchar	100	√		null
bio_lit_amd_data	target_over_exp_number	varchar	100	√		null
bio_lit_amd_data	target_over_exp_percent	varchar	50	√		null
bio_lit_amd_data	target_over_exp_sd	varchar	50	√		null
bio_lit_amd_data	target_over_exp_unit	varchar	50	√		null
bio_lit_amd_data	target_over_exp_value	varchar	100	√		null
bio_lit_amd_data	techniques	varchar	250	√		null
bio_lit_amd_data	total_exp_number	varchar	100	√		null
bio_lit_amd_data	total_exp_percent	varchar	50	√		null
bio_lit_amd_data	total_exp_sd	varchar	50	√		null
bio_lit_amd_data	total_exp_unit	varchar	50	√		null
bio_lit_amd_data	total_exp_value	varchar	100	√		null
bio_lit_inh_data	administration	varchar	250	√		null
bio_lit_inh_data	bio_lit_inh_data_id	int8	19
bio_lit_inh_data	bio_lit_ref_data_id	int8	19	√		null
bio_lit_inh_data	casid	varchar	250	√		null
bio_lit_inh_data	concentration	varchar	250	√		null
bio_lit_inh_data	description	varchar	1000	√		null
bio_lit_inh_data	effect_adverse	varchar	2000	√		null
bio_lit_inh_data	effect_beneficial	varchar	2000	√		null
bio_lit_inh_data	effect_description	varchar	2000	√		null
bio_lit_inh_data	effect_downstream	varchar	2000	√		null
bio_lit_inh_data	effect_molecular	varchar	250	√		null
bio_lit_inh_data	effect_number	varchar	50	√		null
bio_lit_inh_data	effect_percent	varchar	250	√		null
bio_lit_inh_data	effect_pharmacos	varchar	2000	√		null
bio_lit_inh_data	effect_potentials	varchar	2000	√		null
bio_lit_inh_data	effect_response_rate	varchar	250	√		null
bio_lit_inh_data	effect_sd	varchar	250	√		null
bio_lit_inh_data	effect_unit	varchar	250	√		null
bio_lit_inh_data	effect_value	varchar	250	√		null
bio_lit_inh_data	etl_id	varchar	50	√		null
bio_lit_inh_data	inhibitor	varchar	250	√		null
bio_lit_inh_data	inhibitor_standard_name	varchar	250	√		null
bio_lit_inh_data	techniques	varchar	1000	√		null
bio_lit_inh_data	time_exposure	varchar	500	√		null
bio_lit_inh_data	treatment	varchar	2000	√		null
bio_lit_inh_data	trial_body_substance	varchar	250	√		null
bio_lit_inh_data	trial_cell_line	varchar	250	√		null
bio_lit_inh_data	trial_cell_type	varchar	250	√		null
bio_lit_inh_data	trial_description	varchar	1000	√		null
bio_lit_inh_data	trial_designs	varchar	250	√		null
bio_lit_inh_data	trial_experimental_model	varchar	250	√		null
bio_lit_inh_data	trial_inclusion_criteria	varchar	2000	√		null
bio_lit_inh_data	trial_patients_number	varchar	100	√		null
bio_lit_inh_data	trial_phase	varchar	250	√		null
bio_lit_inh_data	trial_status	varchar	250	√		null
bio_lit_inh_data	trial_tissue	varchar	250	√		null
bio_lit_inh_data	trial_type	varchar	250	√		null
bio_lit_int_data	bio_lit_int_data_id	int8	19
bio_lit_int_data	bio_lit_ref_data_id	int8	19
bio_lit_int_data	effect	varchar	500	√		null
bio_lit_int_data	etl_id	varchar	50	√		null
bio_lit_int_data	in_vitro_model_id	int8	19	√		null
bio_lit_int_data	in_vivo_model_id	int8	19	√		null
bio_lit_int_data	interaction_mode	varchar	250	√		null
bio_lit_int_data	localization	varchar	500	√		null
bio_lit_int_data	mechanism	varchar	250	√		null
bio_lit_int_data	region	varchar	250	√		null
bio_lit_int_data	regulation	varchar	1000	√		null
bio_lit_int_data	source_component	varchar	100	√		null
bio_lit_int_data	source_gene_id	varchar	50	√		null
bio_lit_int_data	target_component	varchar	100	√		null
bio_lit_int_data	target_gene_id	varchar	50	√		null
bio_lit_int_data	techniques	varchar	1000	√		null
bio_lit_int_model_mv	bio_lit_int_data_id	int8	19	√		null
bio_lit_int_model_mv	experimental_model	varchar	250	√		null
bio_lit_int_model_view	bio_lit_int_data_id	int8	19	√		null
bio_lit_int_model_view	experimental_model	varchar	250	√		null
bio_lit_model_data	animal_wild_type	varchar	250	√		null
bio_lit_model_data	bio_lit_model_data_id	int8	19
bio_lit_model_data	body_substance	varchar	250	√		null
bio_lit_model_data	cell_line	varchar	250	√		null
bio_lit_model_data	cell_type	varchar	250	√		null
bio_lit_model_data	challenge	varchar	1000	√		null
bio_lit_model_data	component	varchar	250	√		null
bio_lit_model_data	control_challenge	varchar	500	√		null
bio_lit_model_data	description	varchar	1000	√		null
bio_lit_model_data	etl_id	varchar	50	√		null
bio_lit_model_data	experimental_model	varchar	250	√		null
bio_lit_model_data	gene_id	varchar	250	√		null
bio_lit_model_data	model_type	varchar	50	√		null
bio_lit_model_data	sentization	varchar	1000	√		null
bio_lit_model_data	stimulation	varchar	1000	√		null
bio_lit_model_data	tissue	varchar	250	√		null
bio_lit_model_data	zygosity	varchar	250	√		null
bio_lit_pe_data	bio_lit_pe_data_id	int8	19
bio_lit_pe_data	bio_lit_ref_data_id	int8	19
bio_lit_pe_data	description	varchar	2000	√		null
bio_lit_pe_data	etl_id	varchar	50	√		null
bio_lit_pe_data	in_vitro_model_id	int8	19	√		null
bio_lit_pe_data	in_vivo_model_id	int8	19	√		null
bio_lit_ref_data	back_references	varchar	1000	√		null
bio_lit_ref_data	bio_lit_ref_data_id	int8	19
bio_lit_ref_data	component	varchar	100	√		null
bio_lit_ref_data	component_class	varchar	250	√		null
bio_lit_ref_data	disease	varchar	250	√		null
bio_lit_ref_data	disease_description	varchar	1000	√		null
bio_lit_ref_data	disease_grade	varchar	250	√		null
bio_lit_ref_data	disease_icd10	varchar	250	√		null
bio_lit_ref_data	disease_mesh	varchar	250	√		null
bio_lit_ref_data	disease_site	varchar	250	√		null
bio_lit_ref_data	disease_stage	varchar	250	√		null
bio_lit_ref_data	disease_types	varchar	250	√		null
bio_lit_ref_data	etl_id	varchar	50	√		null
bio_lit_ref_data	gene_id	varchar	50	√		null
bio_lit_ref_data	molecule_type	varchar	50	√		null
bio_lit_ref_data	physiology	varchar	250	√		null
bio_lit_ref_data	reference_id	varchar	250	√		null
bio_lit_ref_data	reference_title	varchar	2000	√		null
bio_lit_ref_data	reference_type	varchar	50	√		null
bio_lit_ref_data	stat_clinical	varchar	500	√		null
bio_lit_ref_data	stat_clinical_correlation	varchar	250	√		null
bio_lit_ref_data	stat_coefficient	varchar	500	√		null
bio_lit_ref_data	stat_description	varchar	1000	√		null
bio_lit_ref_data	stat_p_value	varchar	100	√		null
bio_lit_ref_data	stat_tests	varchar	500	√		null
bio_lit_ref_data	study_type	varchar	250	√		null
bio_lit_ref_data	variant	varchar	250	√		null
bio_lit_sum_data	alteration_type	varchar	100	√		null
bio_lit_sum_data	bio_lit_sum_data_id	int8	19
bio_lit_sum_data	data_type	varchar	50	√		null
bio_lit_sum_data	disease_site	varchar	250	√		null
bio_lit_sum_data	etl_id	varchar	50	√		null
bio_lit_sum_data	summary	varchar	1000	√		null
bio_lit_sum_data	target	varchar	50	√		null
bio_lit_sum_data	total_affected_cases	varchar	50	√		null
bio_lit_sum_data	total_frequency	varchar	50	√		null
bio_lit_sum_data	variant	varchar	50	√		null
bio_marker	bio_marker_description	varchar	1000	√		null
bio_marker	bio_marker_id	int8	19
bio_marker	bio_marker_name	varchar	200	√		null
bio_marker	bio_marker_type	varchar	200
bio_marker	organism	varchar	200	√		null
bio_marker	primary_external_id	varchar	200	√		null
bio_marker	primary_source_code	varchar	200	√		null
bio_marker_correl_mv	asso_bio_marker_id	int8	19	√		null
bio_marker_correl_mv	bio_marker_id	int8	19	√		null
bio_marker_correl_mv	correl_type	text	2147483647	√		null
bio_marker_correl_mv	mv_id	int4	10	√		null
bio_marker_correl_view	asso_bio_marker_id	int8	19	√		null
bio_marker_correl_view	bio_marker_id	int8	19	√		null
bio_marker_correl_view	correl_type	text	2147483647	√		null
bio_marker_correl_view	mv_id	int4	10	√		null
bio_marker_exp_analysis_mv	bio_assay_analysis_id	int8	19	√		null
bio_marker_exp_analysis_mv	bio_experiment_id	int8	19	√		null
bio_marker_exp_analysis_mv	bio_marker_id	int8	19	√		null
bio_marker_exp_analysis_mv	mv_id	int8	19	√		null
bio_marker_exp_analysis_mv_10	bio_assay_analysis_id	int8	19	√		null
bio_marker_exp_analysis_mv_10	bio_experiment_id	int8	19	√		null
bio_marker_exp_analysis_mv_10	bio_marker_id	int8	19	√		null
bio_marker_exp_analysis_mv_10	T1.BIO_ASSAY_ANALYSIS_ID*100	int8	19	√		null
bio_metab_subpathway_view	asso_bio_marker_id	int8	19	√		null
bio_metab_subpathway_view	correl_type	text	2147483647	√		null
bio_metab_subpathway_view	subpathway_id	int8	19	√		null
bio_metab_superpathway_view	asso_bio_marker_id	int8	19	√		null
bio_metab_superpathway_view	correl_type	text	2147483647	√		null
bio_metab_superpathway_view	superpathway_id	int8	19	√		null
bio_observation	bio_observation_id	int8	19
bio_observation	etl_id	varchar	50	√		null
bio_observation	obs_code	varchar	50	√		null
bio_observation	obs_code_source	varchar	20	√		null
bio_observation	obs_descr	varchar	1000	√		null
bio_observation	obs_name	varchar	200	√		null
bio_observation	obs_type	varchar	20	√		null
bio_patient	address_zip_code	varchar	200	√		null
bio_patient	bio_clinical_trial_p_group_id	int8	19	√		null
bio_patient	bio_experiment_id	int8	19	√		null
bio_patient	bio_patient_id	int8	19
bio_patient	birth_date	timestamp	29,6	√		null
bio_patient	birth_date_orig	varchar	200	√		null
bio_patient	country_code	varchar	200	√		null
bio_patient	ethnic_group_code	varchar	200	√		null
bio_patient	first_name	varchar	200	√		null
bio_patient	gender_code	varchar	200	√		null
bio_patient	informed_consent_code	varchar	200	√		null
bio_patient	last_name	varchar	200	√		null
bio_patient	middle_name	varchar	200	√		null
bio_patient	race_code	varchar	200	√		null
bio_patient_event	bio_clinic_trial_timepoint_id	int8	19
bio_patient_event	bio_patient_event_id	int8	19
bio_patient_event	bio_patient_id	int8	19
bio_patient_event	event_code	varchar	200	√		null
bio_patient_event	event_date	timestamp	29,6	√		null
bio_patient_event	event_type_code	varchar	200	√		null
bio_patient_event	site	varchar	400	√		null
bio_patient_event_attr	attribute_numeric_value	varchar	200	√		null
bio_patient_event_attr	attribute_text_value	varchar	200	√		null
bio_patient_event_attr	bio_clinic_trial_attr_id	int8	19
bio_patient_event_attr	bio_patient_attr_code	varchar	200
bio_patient_event_attr	bio_patient_attribute_id	int8	19
bio_patient_event_attr	bio_patient_event_id	int8	19
bio_recombination_rates	chromosome	varchar	20	√		null
bio_recombination_rates	map	numeric	18,6	√		null
bio_recombination_rates	position	numeric	18	√		null
bio_recombination_rates	rate	numeric	18,6	√		null
bio_regulome_score	chromosome	varchar	20	√		null
bio_regulome_score	position	numeric	18	√		null
bio_regulome_score	rs_id	varchar	100	√		null
bio_regulome_score	score	varchar	10	√		null
bio_sample	bio_bank_id	int8	19	√		null
bio_sample	bio_cell_line_id	int8	19	√		null
bio_sample	bio_patient_event_id	int8	19	√		null
bio_sample	bio_sample_id	int8	19
bio_sample	bio_sample_name	varchar	100	√		null
bio_sample	bio_sample_type	varchar	200
bio_sample	bio_subject_id	int8	19	√		null
bio_sample	characteristics	varchar	1000	√		null
bio_sample	experiment_id	int8	19	√		null
bio_sample	source	varchar	200	√		null
bio_sample	source_code	varchar	200	√		null
bio_species_organism	id	int8	19	√		null
bio_species_organism	organism	varchar	200	√		null
bio_species_organism	species	varchar	200	√		null
bio_stats_exp_marker	bio_experiment_id	int8	19
bio_stats_exp_marker	bio_marker_id	int8	19
bio_stats_exp_marker	bio_stats_exp_marker_id	int8	19	√		null
bio_subject	bio_subject_id	int8	19
bio_subject	bio_subject_type	varchar	200
bio_subject	organism	varchar	200	√		null
bio_subject	site_subject_id	int8	19	√		null
bio_subject	source	varchar	200	√		null
bio_subject	source_code	varchar	200	√		null
bio_subject	status	varchar	200	√		null
bio_taxonomy	bio_taxonomy_id	int8	19
bio_taxonomy	ncbi_tax_id	varchar	200	√		null
bio_taxonomy	taxon_label	varchar	200
bio_taxonomy	taxon_name	varchar	200
biobank_sample	accession_number	varchar	255
biobank_sample	client_sample_tube_id	varchar	255
biobank_sample	container_id	varchar	255
biobank_sample	import_date	timestamp	29,6	√		null
biobank_sample	sample_tube_id	varchar	255
biobank_sample	source_type	varchar	255
cta_results	bio_assay_analysis_id	int8	19	√		null
cta_results	bio_marker_id	int8	19	√		null
cta_results	bio_marker_name	varchar	200	√		null
cta_results	fold_change	float8	17,17	√		null
cta_results	gene_id	varchar	200	√		null
cta_results	keyword	varchar	400	√		null
cta_results	organism	varchar	100	√		null
cta_results	preferred_pvalue	float8	17,17	√		null
cta_results	probe_id	varchar	100	√		null
cta_results	search_keyword_id	int8	19	√		null
ctd2_clin_inhib_effect	adverse_effect_name	varchar	4000	√		null
ctd2_clin_inhib_effect	beneficial_effect_name	varchar	4000	√		null
ctd2_clin_inhib_effect	ce_p_value	varchar	250	√		null
ctd2_clin_inhib_effect	ce_reduction	varchar	250	√		null
ctd2_clin_inhib_effect	ce_sm_event_rate	varchar	250	√		null
ctd2_clin_inhib_effect	ce_sm_no	varchar	250	√		null
ctd2_clin_inhib_effect	ce_time_to_event	varchar	250	√		null
ctd2_clin_inhib_effect	clinical_correlation	varchar	2000	√		null
ctd2_clin_inhib_effect	clinical_variable_name	varchar	250	√		null
ctd2_clin_inhib_effect	coefficient_value	varchar	250	√		null
ctd2_clin_inhib_effect	ctd_cie_seq	int8	19	√		null
ctd2_clin_inhib_effect	ctd_study_id	int8	19	√		null
ctd2_clin_inhib_effect	discontinuation_rate_value	varchar	250	√		null
ctd2_clin_inhib_effect	drug_effect	varchar	4000	√		null
ctd2_clin_inhib_effect	event_definition_name	varchar	4000	√		null
ctd2_clin_inhib_effect	event_description_name	varchar	4000	√		null
ctd2_clin_inhib_effect	pharmaco_parameter_name	varchar	500	√		null
ctd2_clin_inhib_effect	primary_endpoint_change	varchar	2000	√		null
ctd2_clin_inhib_effect	primary_endpoint_definition	varchar	4000	√		null
ctd2_clin_inhib_effect	primary_endpoint_p_value	varchar	2000	√		null
ctd2_clin_inhib_effect	primary_endpoint_test_name	varchar	2000	√		null
ctd2_clin_inhib_effect	primary_endpoint_time_period	varchar	2000	√		null
ctd2_clin_inhib_effect	primary_endpoint_type	varchar	250	√		null
ctd2_clin_inhib_effect	qp_sm_absolute_change	varchar	250	√		null
ctd2_clin_inhib_effect	qp_sm_group_change	varchar	250	√		null
ctd2_clin_inhib_effect	qp_sm_p_value	varchar	250	√		null
ctd2_clin_inhib_effect	qp_sm_percentage_change	varchar	250	√		null
ctd2_clin_inhib_effect	qp_sm_rate_of_change	varchar	250	√		null
ctd2_clin_inhib_effect	qp_sm_treatment_period	varchar	250	√		null
ctd2_clin_inhib_effect	secondary_endpoint_change	varchar	4000	√		null
ctd2_clin_inhib_effect	secondary_endpoint_definition	varchar	4000	√		null
ctd2_clin_inhib_effect	secondary_endpoint_p_value	varchar	4000	√		null
ctd2_clin_inhib_effect	secondary_endpoint_test_name	varchar	2000	√		null
ctd2_clin_inhib_effect	secondary_endpoint_time_period	varchar	4000	√		null
ctd2_clin_inhib_effect	secondary_endpoint_type	varchar	2000	√		null
ctd2_clin_inhib_effect	signal_effect_name	varchar	4000	√		null
ctd2_clin_inhib_effect	statistics_description	varchar	4000	√		null
ctd2_clin_inhib_effect	statistics_p_value	varchar	250	√		null
ctd2_disease	ctd_disease_seq	int8	19	√		null
ctd2_disease	ctd_study_id	int8	19	√		null
ctd2_disease	disease_common_name	varchar	500	√		null
ctd2_disease	disease_type_name	varchar	500	√		null
ctd2_disease	icd10_name	varchar	250	√		null
ctd2_disease	mesh_name	varchar	250	√		null
ctd2_disease	physiology_name	varchar	500	√		null
ctd2_disease	study_type_name	varchar	2000	√		null
ctd2_inhib_details	common_name_name	varchar	500	√		null
ctd2_inhib_details	comp_admin_route	varchar	4000	√		null
ctd2_inhib_details	comp_dose	varchar	2000	√		null
ctd2_inhib_details	comp_exposure_period	varchar	2000	√		null
ctd2_inhib_details	comp_treatment_name	varchar	4000	√		null
ctd2_inhib_details	comparator_name_name	varchar	250	√		null
ctd2_inhib_details	ctd_inhib_seq	int8	19	√		null
ctd2_inhib_details	ctd_study_id	int8	19	√		null
ctd2_inhib_details	exp_detail_admin_route	varchar	4000	√		null
ctd2_inhib_details	exp_detail_description	varchar	4000	√		null
ctd2_inhib_details	exp_detail_exposure_period	varchar	4000	√		null
ctd2_inhib_details	exp_detail_placebo	varchar	250	√		null
ctd2_inhib_details	exp_detail_treatment_name	varchar	4000	√		null
ctd2_inhib_details	experimental_detail_dose	varchar	4000	√		null
ctd2_inhib_details	standard_name_name	varchar	500	√		null
ctd2_study	ctd_study_id	int8	19	√		null
ctd2_study	protocol_id	varchar	1000	√		null
ctd2_study	protocol_title	varchar	2000	√		null
ctd2_study	pubmed_id	varchar	250	√		null
ctd2_study	pubmed_title	varchar	2000	√		null
ctd2_study	ref_article_protocol_id	varchar	1000	√		null
ctd2_study	reference_id	int4	10
ctd2_trial_details	age	varchar	100	√		null
ctd2_trial_details	allow_med_therapy_cortster	varchar	1000	√		null
ctd2_trial_details	allow_med_therapy_cyto	varchar	1000	√		null
ctd2_trial_details	allow_med_therapy_desc	varchar	4000	√		null
ctd2_trial_details	allow_med_therapy_ics	varchar	1000	√		null
ctd2_trial_details	allow_med_therapy_immuno	varchar	1000	√		null
ctd2_trial_details	allow_med_therapy_laba	varchar	1000	√		null
ctd2_trial_details	allow_med_therapy_ltra	varchar	1000	√		null
ctd2_trial_details	allow_med_therapy_ocs	varchar	1000	√		null
ctd2_trial_details	allow_med_treat_cortster	varchar	1000	√		null
ctd2_trial_details	allow_med_treat_cyto	varchar	1000	√		null
ctd2_trial_details	allow_med_treat_desc	varchar	4000	√		null
ctd2_trial_details	allow_med_treat_ics	varchar	1000	√		null
ctd2_trial_details	allow_med_treat_immuno	varchar	1000	√		null
ctd2_trial_details	allow_med_treat_laba	varchar	1000	√		null
ctd2_trial_details	allow_med_treat_ltra	varchar	1000	√		null
ctd2_trial_details	allow_med_treat_ocs	varchar	1000	√		null
ctd2_trial_details	arm_name	varchar	250	√		null
ctd2_trial_details	asthma_duration	varchar	250	√		null
ctd2_trial_details	biomarker_name_name	varchar	250	√		null
ctd2_trial_details	blinding_procedure	varchar	2000	√		null
ctd2_trial_details	class_type	varchar	250	√		null
ctd2_trial_details	class_value	varchar	250	√		null
ctd2_trial_details	control	varchar	2000	√		null
ctd2_trial_details	ctd_study_id	int8	19	√		null
ctd2_trial_details	ctd_td_seq	int8	19	√		null
ctd2_trial_details	disease_phenotype_name	varchar	1000	√		null
ctd2_trial_details	disease_severity_name	varchar	500	√		null
ctd2_trial_details	former_smokers	varchar	255	√		null
ctd2_trial_details	gender	varchar	100	√		null
ctd2_trial_details	incl_age	varchar	2000	√		null
ctd2_trial_details	incl_biopsy	varchar	2000	√		null
ctd2_trial_details	incl_concomitant_med	varchar	2000	√		null
ctd2_trial_details	incl_difficult_to_treat	varchar	2000	√		null
ctd2_trial_details	incl_disease_diagnosis	varchar	2000	√		null
ctd2_trial_details	incl_dlco	varchar	2000	√		null
ctd2_trial_details	incl_dypsnea_on_exertion	varchar	2000	√		null
ctd2_trial_details	incl_fev1	varchar	2000	√		null
ctd2_trial_details	incl_fev1_reversibility	varchar	2000	√		null
ctd2_trial_details	incl_fev_fvc	varchar	2000	√		null
ctd2_trial_details	incl_former_smokers	varchar	2000	√		null
ctd2_trial_details	incl_fvc	varchar	2000	√		null
ctd2_trial_details	incl_hrct	varchar	2000	√		null
ctd2_trial_details	incl_laba	varchar	2000	√		null
ctd2_trial_details	incl_ltra_inhibitor	varchar	2000	√		null
ctd2_trial_details	incl_never_smokers	varchar	2000	√		null
ctd2_trial_details	incl_ocs	varchar	2000	√		null
ctd2_trial_details	incl_sgrq	varchar	2000	√		null
ctd2_trial_details	incl_smoking	varchar	2000	√		null
ctd2_trial_details	incl_smoking_pack_years	varchar	2000	√		null
ctd2_trial_details	incl_steroid_dose	varchar	2000	√		null
ctd2_trial_details	incl_tlc	varchar	2000	√		null
ctd2_trial_details	incl_xolair	varchar	2000	√		null
ctd2_trial_details	minor_participation	varchar	100	√		null
ctd2_trial_details	never_smokers	varchar	255	√		null
ctd2_trial_details	no_of_arms	varchar	2000	√		null
ctd2_trial_details	pat_char_base_clin_var	varchar	500	√		null
ctd2_trial_details	pat_char_base_clin_var_pct	varchar	250	√		null
ctd2_trial_details	pat_char_base_clin_var_value	varchar	250	√		null
ctd2_trial_details	pat_char_biomarker_pct	varchar	250	√		null
ctd2_trial_details	pat_char_biomarker_value	varchar	250	√		null
ctd2_trial_details	pat_char_cellinfo_count	varchar	250	√		null
ctd2_trial_details	pat_char_cellinfo_name	varchar	250	√		null
ctd2_trial_details	pat_char_cellinfo_type	varchar	250	√		null
ctd2_trial_details	pat_char_priormed_dose	varchar	250	√		null
ctd2_trial_details	pat_char_priormed_name	varchar	250	√		null
ctd2_trial_details	pat_char_priormed_pct	varchar	500	√		null
ctd2_trial_details	patient_studied	varchar	2000	√		null
ctd2_trial_details	patient_study	varchar	250	√		null
ctd2_trial_details	pulm_path_method	varchar	255	√		null
ctd2_trial_details	pulm_path_name	varchar	255	√		null
ctd2_trial_details	pulm_path_pct	varchar	50	√		null
ctd2_trial_details	pulm_path_value	varchar	50	√		null
ctd2_trial_details	region	varchar	250	√		null
ctd2_trial_details	rescue_medication	varchar	2000	√		null
ctd2_trial_details	smokers	varchar	255	√		null
ctd2_trial_details	smoking_pack_years	varchar	255	√		null
ctd2_trial_details	source_type	varchar	2000	√		null
ctd2_trial_details	sponsor	varchar	2000	√		null
ctd2_trial_details	symptom_score	varchar	100	√		null
ctd2_trial_details	therapeutic_intervention	varchar	255	√		null
ctd2_trial_details	trial_des_blinded_status	varchar	250	√		null
ctd2_trial_details	trial_des_exclusion_criteria	varchar	4000	√		null
ctd2_trial_details	trial_des_minimal_symptom	varchar	2000	√		null
ctd2_trial_details	trial_des_nature_of_trial	varchar	250	√		null
ctd2_trial_details	trial_des_open_label_status	varchar	250	√		null
ctd2_trial_details	trial_des_random_status	varchar	250	√		null
ctd2_trial_details	trial_des_rescue_med	varchar	4000	√		null
ctd2_trial_details	trial_des_run_in_period	varchar	2000	√		null
ctd2_trial_details	trial_des_treatment	varchar	2000	√		null
ctd2_trial_details	trial_des_washout_period	varchar	2000	√		null
ctd2_trial_details	trial_description	varchar	4000	√		null
ctd2_trial_details	trial_phase_name	varchar	2000	√		null
ctd2_trial_details	trial_status_name	varchar	2000	√		null
ctd_allowed_meds_treatment	ctd_study_id	int8	19	√		null
ctd_allowed_meds_treatment	trtmt_anti_fibrotics	varchar	4000	√		null
ctd_allowed_meds_treatment	trtmt_corticosteroids	varchar	4000	√		null
ctd_allowed_meds_treatment	trtmt_cytotoxic	varchar	4000	√		null
ctd_allowed_meds_treatment	trtmt_ics	varchar	4000	√		null
ctd_allowed_meds_treatment	trtmt_immunosuppressive	varchar	4000	√		null
ctd_allowed_meds_treatment	trtmt_laba	varchar	4000	√		null
ctd_allowed_meds_treatment	trtmt_ltra	varchar	4000	√		null
ctd_allowed_meds_treatment	trtmt_ocs	varchar	4000	√		null
ctd_arm_view	arm	varchar	4000	√		null
ctd_arm_view	arm_age	varchar	4000	√		null
ctd_arm_view	arm_asthma_duration	varchar	4000	√		null
ctd_arm_view	arm_classification_type	varchar	4000	√		null
ctd_arm_view	arm_classification_value	varchar	4000	√		null
ctd_arm_view	arm_former_smokers_pct	varchar	4000	√		null
ctd_arm_view	arm_gender	varchar	4000	√		null
ctd_arm_view	arm_geographic_region	varchar	4000	√		null
ctd_arm_view	arm_nbr_of_patients_studied	numeric	131089	√		null
ctd_arm_view	arm_never_smokers_pct	varchar	4000	√		null
ctd_arm_view	arm_pack_years	varchar	4000	√		null
ctd_arm_view	arm_smokers_pct	varchar	4000	√		null
ctd_arm_view	baseline_rescue_medication_use	varchar	4000	√		null
ctd_arm_view	baseline_symptom_score	varchar	4000	√		null
ctd_arm_view	id	int8	19	√		null
ctd_arm_view	minority_participation	varchar	4000	√		null
ctd_arm_view	ref_article_protocol_id	varchar	4000	√		null
ctd_biomarker	biomarker_name	varchar	4000	√		null
ctd_biomarker	biomarker_pct	varchar	4000	√		null
ctd_biomarker	biomarker_value	varchar	4000	√		null
ctd_biomarker	ctd_study_id	int8	19	√		null
ctd_biomarker_view	biomarker_name	varchar	4000	√		null
ctd_biomarker_view	biomarker_pct	varchar	4000	√		null
ctd_biomarker_view	biomarker_value	varchar	4000	√		null
ctd_biomarker_view	id	int8	19	√		null
ctd_biomarker_view	ref_article_protocol_id	varchar	4000	√		null
ctd_cell_info_view	cellinfo_count	varchar	4000	√		null
ctd_cell_info_view	cellinfo_source	varchar	4000	√		null
ctd_cell_info_view	cellinfo_type	varchar	4000	√		null
ctd_cell_info_view	id	int8	19	√		null
ctd_cell_info_view	ref_article_protocol_id	varchar	4000	√		null
ctd_clinical_chars_view	clinical_variable	varchar	4000	√		null
ctd_clinical_chars_view	clinical_variable_pct	varchar	4000	√		null
ctd_clinical_chars_view	clinical_variable_value	varchar	4000	√		null
ctd_clinical_chars_view	id	int8	19	√		null
ctd_clinical_chars_view	ref_article_protocol_id	varchar	4000	√		null
ctd_disease	common_name	varchar	4000	√		null
ctd_disease	ctd_study_id	int8	19	√		null
ctd_disease	disease_severity	varchar	4000	√		null
ctd_disease	icd10	varchar	4000	√		null
ctd_disease	mesh	varchar	4000	√		null
ctd_drug_effects_view	adverse_effects	varchar	4000	√		null
ctd_drug_effects_view	beneficial_effects	varchar	4000	√		null
ctd_drug_effects_view	discontinuation_rate	varchar	4000	√		null
ctd_drug_effects_view	downstream_signaling_effects	varchar	4000	√		null
ctd_drug_effects_view	effect_description	varchar	4000	√		null
ctd_drug_effects_view	id	int8	19	√		null
ctd_drug_effects_view	pk_pd_parameter	varchar	4000	√		null
ctd_drug_effects_view	pk_pd_value	varchar	4000	√		null
ctd_drug_effects_view	ref_article_protocol_id	varchar	4000	√		null
ctd_drug_effects_view	response_rate	varchar	4000	√		null
ctd_drug_inhib	ctd_study_id	int8	19	√		null
ctd_drug_inhib	drug_inhibitor_cas_id	varchar	4000	√		null
ctd_drug_inhib	drug_inhibitor_common_name	varchar	4000	√		null
ctd_drug_inhib	drug_inhibitor_standard_name	varchar	4000	√		null
ctd_drug_inhibitor_view	drug_inhibitor_cas_id	varchar	4000	√		null
ctd_drug_inhibitor_view	drug_inhibitor_common_name	varchar	4000	√		null
ctd_drug_inhibitor_view	drug_inhibitor_standard_name	varchar	4000	√		null
ctd_drug_inhibitor_view	id	int8	19	√		null
ctd_drug_inhibitor_view	ref_article_protocol_id	varchar	4000	√		null
ctd_events_view	definition_of_the_event	varchar	4000	√		null
ctd_events_view	event_description	varchar	4000	√		null
ctd_events_view	event_p_value	varchar	4000	√		null
ctd_events_view	event_pct_reduction	varchar	4000	√		null
ctd_events_view	event_rate	varchar	4000	√		null
ctd_events_view	id	int8	19	√		null
ctd_events_view	number_of_events	varchar	4000	√		null
ctd_events_view	ref_article_protocol_id	varchar	4000	√		null
ctd_events_view	time_to_event	varchar	4000	√		null
ctd_experiments_view	comparator_dose	varchar	4000	√		null
ctd_experiments_view	comparator_name	varchar	4000	√		null
ctd_experiments_view	comparator_route_of_admin	varchar	4000	√		null
ctd_experiments_view	comparator_time_period	varchar	4000	√		null
ctd_experiments_view	drug_inhibitor_common_name	varchar	4000	√		null
ctd_experiments_view	drug_inhibitor_dose	varchar	4000	√		null
ctd_experiments_view	drug_inhibitor_route_of_admin	varchar	4000	√		null
ctd_experiments_view	drug_inhibitor_time_period	varchar	4000	√		null
ctd_experiments_view	drug_inhibitor_trtmt_regime	varchar	4000	√		null
ctd_experiments_view	experiment_description	varchar	4000	√		null
ctd_experiments_view	id	int8	19	√		null
ctd_experiments_view	placebo	varchar	4000	√		null
ctd_experiments_view	ref_article_protocol_id	varchar	4000	√		null
ctd_experiments_view	treatment_regime	varchar	4000	√		null
ctd_expr_after_view	biomolecule_name	varchar	4000	√		null
ctd_expr_after_view	expr_after_trtmt_number	varchar	4000	√		null
ctd_expr_after_view	expr_after_trtmt_pct	varchar	4000	√		null
ctd_expr_after_view	expr_after_trtmt_sd	varchar	4000	√		null
ctd_expr_after_view	expr_after_trtmt_sem	varchar	4000	√		null
ctd_expr_after_view	expr_after_trtmt_unit	varchar	4000	√		null
ctd_expr_after_view	expr_aftertrtmt_valuefold_mean	varchar	4000	√		null
ctd_expr_after_view	id	int8	19	√		null
ctd_expr_after_view	ref_article_protocol_id	varchar	4000	√		null
ctd_expr_baseline_view	baseline_expr_number	varchar	4000	√		null
ctd_expr_baseline_view	baseline_expr_pct	varchar	4000	√		null
ctd_expr_baseline_view	baseline_expr_sd	varchar	4000	√		null
ctd_expr_baseline_view	baseline_expr_sem	varchar	4000	√		null
ctd_expr_baseline_view	baseline_expr_unit	varchar	4000	√		null
ctd_expr_baseline_view	baseline_expr_value_fold_mean	varchar	4000	√		null
ctd_expr_baseline_view	biomolecule_name	varchar	4000	√		null
ctd_expr_baseline_view	id	int8	19	√		null
ctd_expr_baseline_view	ref_article_protocol_id	varchar	4000	√		null
ctd_expr_bio_view	biomarker	varchar	4000	√		null
ctd_expr_bio_view	biomarker_type	varchar	4000	√		null
ctd_expr_bio_view	biomolecule_id	varchar	4000	√		null
ctd_expr_bio_view	biomolecule_name	varchar	4000	√		null
ctd_expr_bio_view	biomolecule_type	varchar	4000	√		null
ctd_expr_bio_view	id	int8	19	√		null
ctd_expr_bio_view	ref_article_protocol_id	varchar	4000	√		null
ctd_expr_source_view	expr_chg_description	varchar	4000	√		null
ctd_expr_source_view	expr_chg_source_type	varchar	4000	√		null
ctd_expr_source_view	expr_chg_technique	varchar	4000	√		null
ctd_expr_source_view	id	int8	19	√		null
ctd_expr_source_view	ref_article_protocol_id	varchar	4000	√		null
ctd_full	abs_change_from_baseline	varchar	4000	√		null
ctd_full	adverse_effects	varchar	4000	√		null
ctd_full	arm	varchar	4000	√		null
ctd_full	arm_age	varchar	4000	√		null
ctd_full	arm_asthma_duration	varchar	4000	√		null
ctd_full	arm_classification_type	varchar	4000	√		null
ctd_full	arm_classification_value	varchar	4000	√		null
ctd_full	arm_former_smokers_pct	varchar	4000	√		null
ctd_full	arm_gender	varchar	4000	√		null
ctd_full	arm_geographic_region	varchar	4000	√		null
ctd_full	arm_nbr_of_patients_studied	varchar	4000	√		null
ctd_full	arm_never_smokers_pct	varchar	4000	√		null
ctd_full	arm_pack_years	varchar	4000	√		null
ctd_full	arm_smokers_pct	varchar	4000	√		null
ctd_full	asthma_diagnosis	varchar	4000	√		null
ctd_full	asthma_phenotype	varchar	4000	√		null
ctd_full	average_over_treatment_period	varchar	4000	√		null
ctd_full	baseline_expr_number	varchar	4000	√		null
ctd_full	baseline_expr_pct	varchar	4000	√		null
ctd_full	baseline_expr_sd	varchar	4000	√		null
ctd_full	baseline_expr_sem	varchar	4000	√		null
ctd_full	baseline_expr_unit	varchar	4000	√		null
ctd_full	baseline_expr_value_fold_mean	varchar	4000	√		null
ctd_full	baseline_rescue_medication_use	varchar	4000	√		null
ctd_full	baseline_symptom_score	varchar	4000	√		null
ctd_full	beneficial_effects	varchar	4000	√		null
ctd_full	biomarker	varchar	4000	√		null
ctd_full	biomarker_name	varchar	4000	√		null
ctd_full	biomarker_pct	varchar	4000	√		null
ctd_full	biomarker_type	varchar	4000	√		null
ctd_full	biomarker_value	varchar	4000	√		null
ctd_full	biomolecule_id	varchar	4000	√		null
ctd_full	biomolecule_name	varchar	4000	√		null
ctd_full	biomolecule_type	varchar	4000	√		null
ctd_full	biopsy	varchar	4000	√		null
ctd_full	blinded_trial	varchar	4000	√		null
ctd_full	blinding_procedure	varchar	4000	√		null
ctd_full	cellinfo_count	varchar	4000	√		null
ctd_full	cellinfo_source	varchar	4000	√		null
ctd_full	cellinfo_type	varchar	4000	√		null
ctd_full	clinical_correlation	varchar	4000	√		null
ctd_full	clinical_trial_design_id	int8	19	√		null
ctd_full	clinical_variable	varchar	4000	√		null
ctd_full	clinical_variable_name	varchar	4000	√		null
ctd_full	clinical_variable_pct	varchar	4000	√		null
ctd_full	clinical_variable_value	varchar	4000	√		null
ctd_full	common_name	varchar	4000	√		null
ctd_full	comparator_dose	varchar	4000	√		null
ctd_full	comparator_name	varchar	4000	√		null
ctd_full	comparator_route_of_admin	varchar	4000	√		null
ctd_full	comparator_time_period	varchar	4000	√		null
ctd_full	concomitant_med	varchar	4000	√		null
ctd_full	control_details	varchar	4000	√		null
ctd_full	definition_of_the_event	varchar	4000	√		null
ctd_full	description	text	2147483647	√		null
ctd_full	difficult_to_treat	varchar	4000	√		null
ctd_full	discontinuation_rate	varchar	4000	√		null
ctd_full	disease_severity	varchar	4000	√		null
ctd_full	disease_type	varchar	4000	√		null
ctd_full	dlco	varchar	4000	√		null
ctd_full	downstream_signaling_effects	varchar	4000	√		null
ctd_full	drug_inhibitor_cas_id	varchar	4000	√		null
ctd_full	drug_inhibitor_common_name	varchar	4000	√		null
ctd_full	drug_inhibitor_dose	varchar	4000	√		null
ctd_full	drug_inhibitor_route_of_admin	varchar	4000	√		null
ctd_full	drug_inhibitor_standard_name	varchar	4000	√		null
ctd_full	drug_inhibitor_time_period	varchar	4000	√		null
ctd_full	drug_inhibitor_trtmt_regime	varchar	4000	√		null
ctd_full	dyspnea_on_exertion	varchar	4000	√		null
ctd_full	effect_description	varchar	4000	√		null
ctd_full	event_description	varchar	4000	√		null
ctd_full	event_p_value	varchar	4000	√		null
ctd_full	event_pct_reduction	varchar	4000	√		null
ctd_full	event_rate	varchar	4000	√		null
ctd_full	exclusion_criteria	text	2147483647	√		null
ctd_full	experiment_description	varchar	4000	√		null
ctd_full	expr_after_trtmt_number	varchar	4000	√		null
ctd_full	expr_after_trtmt_pct	varchar	4000	√		null
ctd_full	expr_after_trtmt_sd	varchar	4000	√		null
ctd_full	expr_after_trtmt_sem	varchar	4000	√		null
ctd_full	expr_after_trtmt_unit	varchar	4000	√		null
ctd_full	expr_aftertrtmt_valuefold_mean	varchar	4000	√		null
ctd_full	expr_chg_description	varchar	4000	√		null
ctd_full	expr_chg_source_type	varchar	4000	√		null
ctd_full	expr_chg_technique	varchar	4000	√		null
ctd_full	fev1	varchar	4000	√		null
ctd_full	fev1_fvc	varchar	4000	√		null
ctd_full	fev1_reversibility	varchar	4000	√		null
ctd_full	fvc	varchar	4000	√		null
ctd_full	hrct	varchar	4000	√		null
ctd_full	icd10	varchar	4000	√		null
ctd_full	inhaled_steroid_dose	varchar	4000	√		null
ctd_full	laba	varchar	4000	√		null
ctd_full	ltra_inhibitors	varchar	4000	√		null
ctd_full	mesh	varchar	4000	√		null
ctd_full	minimal_symptoms	varchar	4000	√		null
ctd_full	minority_participation	varchar	4000	√		null
ctd_full	nature_of_trial	varchar	4000	√		null
ctd_full	number_of_arms	varchar	4000	√		null
ctd_full	number_of_events	varchar	4000	√		null
ctd_full	ocs	varchar	4000	√		null
ctd_full	open_label_extension	varchar	4000	√		null
ctd_full	pct_change_from_baseline	varchar	4000	√		null
ctd_full	physiology_name	varchar	4000	√		null
ctd_full	pk_pd_parameter	varchar	4000	√		null
ctd_full	pk_pd_value	varchar	4000	√		null
ctd_full	placebo	varchar	4000	√		null
ctd_full	primary_endpoint_change	varchar	4000	√		null
ctd_full	primary_endpoint_definition	varchar	4000	√		null
ctd_full	primary_endpoint_p_value	varchar	4000	√		null
ctd_full	primary_endpoint_stat_test	varchar	4000	√		null
ctd_full	primary_endpoint_time_period	varchar	4000	√		null
ctd_full	primary_endpoint_type	varchar	4000	√		null
ctd_full	prior_med_drug_name	varchar	4000	√		null
ctd_full	prior_med_pct	varchar	4000	√		null
ctd_full	prior_med_value	varchar	4000	√		null
ctd_full	pulmonary_pathology_name	varchar	4000	√		null
ctd_full	pulmpath_method	varchar	4000	√		null
ctd_full	pulmpath_patient_pct	varchar	4000	√		null
ctd_full	pulmpath_value_unit	varchar	4000	√		null
ctd_full	randomization	varchar	4000	√		null
ctd_full	rate_of_change_from_baseline	varchar	4000	√		null
ctd_full	ref_article_pmid	varchar	4000	√		null
ctd_full	ref_article_protocol_id	varchar	4000	√		null
ctd_full	ref_back_reference	varchar	4000	√		null
ctd_full	ref_protocol_id	varchar	4000	√		null
ctd_full	ref_record_id	varchar	4000	√		null
ctd_full	ref_title	varchar	4000	√		null
ctd_full	rescue_medication_use	varchar	4000	√		null
ctd_full	response_rate	varchar	4000	√		null
ctd_full	run_in_period	varchar	4000	√		null
ctd_full	runin_anti_fibrotics	varchar	4000	√		null
ctd_full	runin_corticosteroids	varchar	4000	√		null
ctd_full	runin_cytotoxic	varchar	4000	√		null
ctd_full	runin_description	varchar	4000	√		null
ctd_full	runin_ics	varchar	4000	√		null
ctd_full	runin_immunosuppressive	varchar	4000	√		null
ctd_full	runin_laba	varchar	4000	√		null
ctd_full	runin_ltra	varchar	4000	√		null
ctd_full	runin_ocs	varchar	4000	√		null
ctd_full	secondary_type	varchar	4000	√		null
ctd_full	secondary_type_change	varchar	4000	√		null
ctd_full	secondary_type_definition	varchar	4000	√		null
ctd_full	secondary_type_p_value	varchar	4000	√		null
ctd_full	secondary_type_stat_test	varchar	4000	√		null
ctd_full	secondary_type_time_period	varchar	4000	√		null
ctd_full	sgrq	varchar	4000	√		null
ctd_full	source_type	varchar	4000	√		null
ctd_full	sponsor	varchar	4000	√		null
ctd_full	stat_measure_p_value	varchar	4000	√		null
ctd_full	statistical_coefficient_value	varchar	4000	√		null
ctd_full	statistical_test	varchar	4000	√		null
ctd_full	statistical_test_description	varchar	4000	√		null
ctd_full	statistical_test_p_value	varchar	4000	√		null
ctd_full	study_type	varchar	4000	√		null
ctd_full	time_to_event	varchar	4000	√		null
ctd_full	tlc	varchar	4000	√		null
ctd_full	treatment_period	varchar	4000	√		null
ctd_full	treatment_regime	varchar	4000	√		null
ctd_full	trial_age	varchar	4000	√		null
ctd_full	trial_former_smokers_pct	varchar	4000	√		null
ctd_full	trial_nbr_of_patients_studied	varchar	4000	√		null
ctd_full	trial_never_smokers_pct	varchar	4000	√		null
ctd_full	trial_pack_years	varchar	4000	√		null
ctd_full	trial_phase	varchar	4000	√		null
ctd_full	trial_smokers_pct	varchar	4000	√		null
ctd_full	trial_status	varchar	4000	√		null
ctd_full	trial_type	varchar	4000	√		null
ctd_full	trtmt_anti_fibrotics	varchar	4000	√		null
ctd_full	trtmt_corticosteroids	varchar	4000	√		null
ctd_full	trtmt_cytotoxic	varchar	4000	√		null
ctd_full	trtmt_description	varchar	4000	√		null
ctd_full	trtmt_ics	varchar	4000	√		null
ctd_full	trtmt_immunosuppressive	varchar	4000	√		null
ctd_full	trtmt_laba	varchar	4000	√		null
ctd_full	trtmt_ltra	varchar	4000	√		null
ctd_full	trtmt_ocs	varchar	4000	√		null
ctd_full	washout_period	varchar	4000	√		null
ctd_full	within_group_changes	varchar	4000	√		null
ctd_full	xolair	varchar	4000	√		null
ctd_full_clinical_endpts_view	id	int8	19	√		null
ctd_full_clinical_endpts_view	primary_endpoint_change	varchar	4000	√		null
ctd_full_clinical_endpts_view	primary_endpoint_definition	varchar	4000	√		null
ctd_full_clinical_endpts_view	primary_endpoint_p_value	varchar	4000	√		null
ctd_full_clinical_endpts_view	primary_endpoint_stat_test	varchar	4000	√		null
ctd_full_clinical_endpts_view	primary_endpoint_time_period	varchar	4000	√		null
ctd_full_clinical_endpts_view	primary_endpoint_type	varchar	4000	√		null
ctd_full_clinical_endpts_view	ref_article_protocol_id	varchar	4000	√		null
ctd_full_clinical_endpts_view	secondary_type	varchar	4000	√		null
ctd_full_clinical_endpts_view	secondary_type_change	varchar	4000	√		null
ctd_full_clinical_endpts_view	secondary_type_definition	varchar	4000	√		null
ctd_full_clinical_endpts_view	secondary_type_p_value	varchar	4000	√		null
ctd_full_clinical_endpts_view	secondary_type_stat_test	varchar	4000	√		null
ctd_full_clinical_endpts_view	secondary_type_time_period	varchar	4000	√		null
ctd_full_search_view	biomarker_name	varchar	4000	√		null
ctd_full_search_view	common_name	varchar	4000	√		null
ctd_full_search_view	disease_severity	varchar	4000	√		null
ctd_full_search_view	drug_inhibitor_standard_name	varchar	4000	√		null
ctd_full_search_view	fact_id	int8	19	√		null
ctd_full_search_view	fev1	varchar	4000	√		null
ctd_full_search_view	inhaled_steroid_dose	varchar	4000	√		null
ctd_full_search_view	mesh	varchar	4000	√		null
ctd_full_search_view	primary_endpoint_change	varchar	4000	√		null
ctd_full_search_view	primary_endpoint_p_value	varchar	4000	√		null
ctd_full_search_view	primary_endpoint_time_period	varchar	4000	√		null
ctd_full_search_view	primary_endpoint_type	varchar	4000	√		null
ctd_full_search_view	ref_article_protocol_id	varchar	4000	√		null
ctd_full_search_view	secondary_type	varchar	4000	√		null
ctd_inclusion_criteria	asthma_phenotype	varchar	4000	√		null
ctd_inclusion_criteria	ctd_study_id	int8	19	√		null
ctd_inclusion_criteria	fev1	varchar	4000	√		null
ctd_inclusion_criteria	inhaled_steroid_dose	varchar	4000	√		null
ctd_inclusion_criteria	laba	varchar	4000	√		null
ctd_inclusion_criteria	ltra_inhibitors	varchar	4000	√		null
ctd_inclusion_criteria	ocs	varchar	4000	√		null
ctd_inclusion_criteria	xolair	varchar	4000	√		null
ctd_primary_endpts	ctd_study_id	int8	19	√		null
ctd_primary_endpts	id	int8	19	√		null
ctd_primary_endpts	primary_type	varchar	4000	√		null
ctd_primary_endpts	primary_type_change	varchar	4000	√		null
ctd_primary_endpts	primary_type_definition	varchar	4000	√		null
ctd_primary_endpts	primary_type_p_value	varchar	4000	√		null
ctd_primary_endpts	primary_type_time_period	varchar	4000	√		null
ctd_primary_endpts_view	id	int8	19	√		null
ctd_primary_endpts_view	primary_endpoint_change	varchar	4000	√		null
ctd_primary_endpts_view	primary_endpoint_definition	varchar	4000	√		null
ctd_primary_endpts_view	primary_endpoint_p_value	varchar	4000	√		null
ctd_primary_endpts_view	primary_endpoint_stat_test	varchar	4000	√		null
ctd_primary_endpts_view	primary_endpoint_time_period	varchar	4000	√		null
ctd_primary_endpts_view	primary_endpoint_type	varchar	4000	√		null
ctd_primary_endpts_view	ref_article_protocol_id	varchar	4000	√		null
ctd_prior_med_use_view	id	int8	19	√		null
ctd_prior_med_use_view	prior_med_drug_name	varchar	4000	√		null
ctd_prior_med_use_view	prior_med_pct	varchar	4000	√		null
ctd_prior_med_use_view	prior_med_value	varchar	4000	√		null
ctd_prior_med_use_view	ref_article_protocol_id	varchar	4000	√		null
ctd_pulmonary_path_view	id	int8	19	√		null
ctd_pulmonary_path_view	pulmonary_pathology_name	varchar	4000	√		null
ctd_pulmonary_path_view	pulmpath_method	varchar	4000	√		null
ctd_pulmonary_path_view	pulmpath_patient_pct	varchar	4000	√		null
ctd_pulmonary_path_view	pulmpath_value_unit	varchar	4000	√		null
ctd_pulmonary_path_view	ref_article_protocol_id	varchar	4000	√		null
ctd_quant_params_view	abs_change_from_baseline	varchar	4000	√		null
ctd_quant_params_view	average_over_treatment_period	varchar	4000	√		null
ctd_quant_params_view	clinical_variable_name	varchar	4000	√		null
ctd_quant_params_view	id	int8	19	√		null
ctd_quant_params_view	pct_change_from_baseline	varchar	4000	√		null
ctd_quant_params_view	rate_of_change_from_baseline	varchar	4000	√		null
ctd_quant_params_view	ref_article_protocol_id	varchar	4000	√		null
ctd_quant_params_view	stat_measure_p_value	varchar	4000	√		null
ctd_quant_params_view	within_group_changes	varchar	4000	√		null
ctd_reference_view	id	int8	19	√		null
ctd_reference_view	ref_article_pmid	varchar	4000	√		null
ctd_reference_view	ref_article_protocol_id	varchar	4000	√		null
ctd_reference_view	ref_back_reference	varchar	4000	√		null
ctd_reference_view	ref_protocol_id	varchar	4000	√		null
ctd_reference_view	ref_record_id	varchar	4000	√		null
ctd_reference_view	ref_title	varchar	4000	√		null
ctd_runin_therapies_view	id	int8	19	√		null
ctd_runin_therapies_view	ref_article_protocol_id	varchar	4000	√		null
ctd_runin_therapies_view	runin_anti_fibrotics	varchar	4000	√		null
ctd_runin_therapies_view	runin_corticosteroids	varchar	4000	√		null
ctd_runin_therapies_view	runin_cytotoxic	varchar	4000	√		null
ctd_runin_therapies_view	runin_description	varchar	4000	√		null
ctd_runin_therapies_view	runin_ics	varchar	4000	√		null
ctd_runin_therapies_view	runin_immunosuppressive	varchar	4000	√		null
ctd_runin_therapies_view	runin_laba	varchar	4000	√		null
ctd_runin_therapies_view	runin_ltra	varchar	4000	√		null
ctd_runin_therapies_view	runin_ocs	varchar	4000	√		null
ctd_sec_endpts	ctd_study_id	int8	19	√		null
ctd_sec_endpts	id	int8	19	√		null
ctd_sec_endpts	secondary_type	varchar	4000	√		null
ctd_sec_endpts	secondary_type_change	varchar	4000	√		null
ctd_sec_endpts	secondary_type_definition	varchar	4000	√		null
ctd_sec_endpts	secondary_type_p_value	varchar	4000	√		null
ctd_sec_endpts	secondary_type_time_period	varchar	4000	√		null
ctd_secondary_endpts_view	id	int8	19	√		null
ctd_secondary_endpts_view	ref_article_protocol_id	varchar	4000	√		null
ctd_secondary_endpts_view	secondary_type	varchar	4000	√		null
ctd_secondary_endpts_view	secondary_type_change	varchar	4000	√		null
ctd_secondary_endpts_view	secondary_type_definition	varchar	4000	√		null
ctd_secondary_endpts_view	secondary_type_p_value	varchar	4000	√		null
ctd_secondary_endpts_view	secondary_type_stat_test	varchar	4000	√		null
ctd_secondary_endpts_view	secondary_type_time_period	varchar	4000	√		null
ctd_stats_view	clinical_correlation	varchar	4000	√		null
ctd_stats_view	id	int8	19	√		null
ctd_stats_view	ref_article_protocol_id	varchar	4000	√		null
ctd_stats_view	statistical_coefficient_value	varchar	4000	√		null
ctd_stats_view	statistical_test	varchar	4000	√		null
ctd_stats_view	statistical_test_description	varchar	4000	√		null
ctd_stats_view	statistical_test_p_value	varchar	4000	√		null
ctd_study	ctd_study_id	int8	19	√		null
ctd_study	ref_article_pmid	varchar	4000	√		null
ctd_study	ref_article_protocol_id	varchar	4000	√		null
ctd_study	ref_protocol_id	varchar	4000	√		null
ctd_study_details_view	common_name	varchar	4000	√		null
ctd_study_details_view	disease_type	varchar	4000	√		null
ctd_study_details_view	icd10	varchar	4000	√		null
ctd_study_details_view	id	int8	19	√		null
ctd_study_details_view	mesh	varchar	4000	√		null
ctd_study_details_view	physiology_name	varchar	4000	√		null
ctd_study_details_view	ref_article_protocol_id	varchar	4000	√		null
ctd_study_details_view	study_type	varchar	4000	√		null
ctd_td_design_view	blinded_trial	varchar	4000	√		null
ctd_td_design_view	id	int8	19	√		null
ctd_td_design_view	nature_of_trial	varchar	4000	√		null
ctd_td_design_view	open_label_extension	varchar	4000	√		null
ctd_td_design_view	randomization	varchar	4000	√		null
ctd_td_design_view	ref_article_protocol_id	varchar	4000	√		null
ctd_td_design_view	run_in_period	varchar	4000	√		null
ctd_td_design_view	treatment_period	varchar	4000	√		null
ctd_td_design_view	trial_type	varchar	4000	√		null
ctd_td_design_view	washout_period	varchar	4000	√		null
ctd_td_excl_view	blinding_procedure	varchar	4000	√		null
ctd_td_excl_view	control_details	varchar	4000	√		null
ctd_td_excl_view	description1	text	2147483647	√		null
ctd_td_excl_view	description2	text	2147483647	√		null
ctd_td_excl_view	exclusion_criteria1	text	2147483647	√		null
ctd_td_excl_view	exclusion_criteria2	text	2147483647	√		null
ctd_td_excl_view	id	int8	19	√		null
ctd_td_excl_view	minimal_symptoms	varchar	4000	√		null
ctd_td_excl_view	number_of_arms	varchar	4000	√		null
ctd_td_excl_view	ref_article_protocol_id	varchar	4000	√		null
ctd_td_excl_view	rescue_medication_use	varchar	4000	√		null
ctd_td_inclusion_view	asthma_diagnosis	varchar	4000	√		null
ctd_td_inclusion_view	asthma_phenotype	varchar	4000	√		null
ctd_td_inclusion_view	biopsy	varchar	4000	√		null
ctd_td_inclusion_view	concomitant_med	varchar	4000	√		null
ctd_td_inclusion_view	difficult_to_treat	varchar	4000	√		null
ctd_td_inclusion_view	disease_severity	varchar	4000	√		null
ctd_td_inclusion_view	dlco	varchar	4000	√		null
ctd_td_inclusion_view	dyspnea_on_exertion	varchar	4000	√		null
ctd_td_inclusion_view	fev1	varchar	4000	√		null
ctd_td_inclusion_view	fev1_fvc	varchar	4000	√		null
ctd_td_inclusion_view	fev1_reversibility	varchar	4000	√		null
ctd_td_inclusion_view	fvc	varchar	4000	√		null
ctd_td_inclusion_view	hrct	varchar	4000	√		null
ctd_td_inclusion_view	id	int8	19	√		null
ctd_td_inclusion_view	inhaled_steroid_dose	varchar	4000	√		null
ctd_td_inclusion_view	laba	varchar	4000	√		null
ctd_td_inclusion_view	ltra_inhibitors	varchar	4000	√		null
ctd_td_inclusion_view	ocs	varchar	4000	√		null
ctd_td_inclusion_view	ref_article_protocol_id	varchar	4000	√		null
ctd_td_inclusion_view	sgrq	varchar	4000	√		null
ctd_td_inclusion_view	tlc	varchar	4000	√		null
ctd_td_inclusion_view	trial_age	varchar	4000	√		null
ctd_td_inclusion_view	xolair	varchar	4000	√		null
ctd_td_smoker_view	id	int8	19	√		null
ctd_td_smoker_view	ref_article_protocol_id	varchar	4000	√		null
ctd_td_smoker_view	trial_former_smokers_pct	varchar	4000	√		null
ctd_td_smoker_view	trial_never_smokers_pct	varchar	4000	√		null
ctd_td_smoker_view	trial_pack_years	varchar	4000	√		null
ctd_td_smoker_view	trial_smokers_pct	varchar	4000	√		null
ctd_td_sponsor_view	id	int8	19	√		null
ctd_td_sponsor_view	ref_article_protocol_id	varchar	4000	√		null
ctd_td_sponsor_view	source_type	varchar	4000	√		null
ctd_td_sponsor_view	sponsor	varchar	4000	√		null
ctd_td_sponsor_view	trial_nbr_of_patients_studied	varchar	4000	√		null
ctd_td_status_view	id	int8	19	√		null
ctd_td_status_view	ref_article_protocol_id	varchar	4000	√		null
ctd_td_status_view	trial_phase	varchar	4000	√		null
ctd_td_status_view	trial_status	varchar	4000	√		null
ctd_treatment_phases_view	id	int8	19	√		null
ctd_treatment_phases_view	ref_article_protocol_id	varchar	4000	√		null
ctd_treatment_phases_view	trtmt_anti_fibrotics	varchar	4000	√		null
ctd_treatment_phases_view	trtmt_corticosteroids	varchar	4000	√		null
ctd_treatment_phases_view	trtmt_cytotoxic	varchar	4000	√		null
ctd_treatment_phases_view	trtmt_description	varchar	4000	√		null
ctd_treatment_phases_view	trtmt_ics	varchar	4000	√		null
ctd_treatment_phases_view	trtmt_immunosuppressive	varchar	4000	√		null
ctd_treatment_phases_view	trtmt_laba	varchar	4000	√		null
ctd_treatment_phases_view	trtmt_ltra	varchar	4000	√		null
ctd_treatment_phases_view	trtmt_ocs	varchar	4000	√		null
dd	drn	varchar	20	√		null
dd	drug	varchar	100	√		null
gene_info_test	gene_descr	varchar	4000	√		null
gene_info_test	gene_id	int8	19	√		null
gene_info_test	gene_symbol	varchar	200	√		null
gene_info_test	tax_id	int8	19	√		null
gene_synonym_test	gene_id	int8	19	√		null
gene_synonym_test	gene_symbol	varchar	200	√		null
gene_synonym_test	gene_synonym	varchar	200	√		null
gene_synonym_test	tax_id	int8	19	√		null
genego_gene_map	bio_marker_id	int8	19
genego_gene_map	gene_id	varchar	10	√		null
genego_gene_map	gene_symbol	varchar	20	√		null
genotype_probe_annotation	alt	varchar	4000	√		null
genotype_probe_annotation	alt_clob	text	2147483647	√		null
genotype_probe_annotation	chrom	varchar	4	√		null
genotype_probe_annotation	created_by	varchar	30	√		null
genotype_probe_annotation	created_date	date	13	√		null
genotype_probe_annotation	exon_intron	varchar	30	√		null
genotype_probe_annotation	gene_info	varchar	4000	√		null
genotype_probe_annotation	genome_build	varchar	10	√		null
genotype_probe_annotation	genotype_probe_annotation_id	numeric	22
genotype_probe_annotation	modified_by	varchar	30	√		null
genotype_probe_annotation	modified_date	date	13	√		null
genotype_probe_annotation	pos	numeric	131089	√		null
genotype_probe_annotation	recombination_map	numeric	18,6	√		null
genotype_probe_annotation	recombination_rate	numeric	18,6	√		null
genotype_probe_annotation	ref	varchar	4000	√		null
genotype_probe_annotation	ref_clob	text	2147483647	√		null
genotype_probe_annotation	regulome_score	varchar	10	√		null
genotype_probe_annotation	snp_name	varchar	50	√		null
genotype_probe_annotation	snp_source	varchar	10	√		null
genotype_probe_annotation	strand	bool	1	√		null
genotype_probe_annotation	variation_class	varchar	10	√		null
gse_analysis	analysis1	varchar	300	√		null
gse_analysis	analysis2	varchar	300	√		null
gse_analysis	bio_assay_analysis_id	int8	19	√		null
gse_analysis	bio_assay_platform_id	int8	19	√		null
gse_analysis	bio_experiment_id	int8	19	√		null
gse_analysis	data_ct	int8	19	√		null
gse_analysis	fc_mean	int8	19	√		null
gse_analysis	fc_stddev	int8	19	√		null
gse_analysis	name	varchar	100	√		null
gse_analysis	platform	varchar	100	√		null
gse_analysis	test	varchar	1000	√		null
gse_probeset	name	varchar	100	√		null
gse_probeset	platform	varchar	100	√		null
gse_probeset	probeset	varchar	100	√		null
heat_map_results	assay_id	int8	19	√		null
heat_map_results	bio_assay_analysis_id	int8	19	√		null
heat_map_results	bio_assay_feature_group_id	int8	19	√		null
heat_map_results	bio_marker_id	int8	19	√		null
heat_map_results	bio_marker_name	varchar	400	√		null
heat_map_results	cohort_id	varchar	255	√		null
heat_map_results	fold_change_ratio	float8	17,17	√		null
heat_map_results	gene_id	varchar	200	√		null
heat_map_results	log_intensity	float8	17,17	√		null
heat_map_results	preferred_pvalue	float8	17,17	√		null
heat_map_results	probe_id	varchar	100	√		null
heat_map_results	search_keyword_id	int8	19	√		null
heat_map_results	significant	int2	5	√		null
heat_map_results	subject_id	varchar	50	√		null
heat_map_results	tea_normalized_pvalue	float8	17,17	√		null
heat_map_results	trial_name	varchar	50	√		null
mesh	mh	varchar	200	√		null
mesh	mn	varchar	200	√		null
mesh	ui	varchar	20
mesh	ui_path	varchar	500	√		null
mesh_copy	mh	varchar	200	√		null
mesh_copy	mn	varchar	200	√		null
mesh_copy	ui	varchar	20
mesh_descriptor	mesh_annotation	varchar	2000	√		null
mesh_descriptor	mesh_descriptor_id	varchar	15
mesh_descriptor	mesh_heading	varchar	256	√		null
mesh_entry	entry	varchar	200	√		null
mesh_entry	mh	varchar	200	√		null
mesh_path	child_number	varchar	200	√		null
mesh_path	id_path	varchar	500	√		null
mesh_path	mesh_name	varchar	200	√		null
mesh_path	parent_number	varchar	200	√		null
mesh_path	unique_id	varchar	20
mesh_temp	mh	varchar	200	√		null
mesh_temp	mn	varchar	200	√		null
mesh_temp	ui	varchar	20	√		null
mesh_with_parent	mh	varchar	200	√		null
mesh_with_parent	mn	varchar	200	√		null
mesh_with_parent	pn	text	2147483647	√		null
mesh_with_parent	ui	varchar	20	√		null
mirna_bio_assay_data_annot	bio_assay_feature_group_id	numeric	18	√		null
mirna_bio_assay_data_annot	bio_marker_id	numeric	18
mirna_bio_assay_data_annot	data_table	bpchar	5	√		null
mirna_bio_assay_feature_group	bio_assay_feature_group_id	numeric	18		√	nextval('biomart.seq_bio_data_id'::regclass)
mirna_bio_assay_feature_group	feature_group_name	varchar	100
mirna_bio_assay_feature_group	feature_group_type	varchar	50
mirna_bio_marker	bio_marker_description	varchar	1000	√		null
mirna_bio_marker	bio_marker_id	int8	19
mirna_bio_marker	bio_marker_name	varchar	200	√		null
mirna_bio_marker	bio_marker_type	varchar	200
mirna_bio_marker	organism	varchar	200	√		null
mirna_bio_marker	primary_external_id	varchar	200	√		null
mirna_bio_marker	primary_source_code	varchar	200	√		null
project_info	activedataname	varchar	400	√		null
project_info	entrydt	timestamp	29,6	√		null
project_info	file_id	int4	10
project_info	file_name	varchar	100	√		null
project_info	id	varchar	100	√		null
project_info	name	varchar	100	√		null
project_info	project_accession	varchar	100	√		null
project_info	project_category	text	2147483647	√		null
project_info	project_compound	varchar	400	√		null
project_info	project_contactaddress	varchar	4000	√		null
project_info	project_contactcompany	varchar	400	√		null
project_info	project_contactdepartment	varchar	400	√		null
project_info	project_contactemail	varchar	400	√		null
project_info	project_contactfax	varchar	100	√		null
project_info	project_contactlaboratory	varchar	400	√		null
project_info	project_contactname	varchar	400	√		null
project_info	project_contactorganization	varchar	1000	√		null
project_info	project_contactphone	varchar	100	√		null
project_info	project_contactweblink	varchar	1000	√		null
project_info	project_contributors	varchar	4000	√		null
project_info	project_datasource	varchar	100	√		null
project_info	project_description	text	2147483647	√		null
project_info	project_design	text	2147483647	√		null
project_info	project_editors	varchar	100	√		null
project_info	project_extractedfromcelfiles	varchar	1000	√		null
project_info	project_id	varchar	100	√		null
project_info	project_isprivate	varchar	100	√		null
project_info	project_keywords	varchar	1000	√		null
project_info	project_organism	varchar	400	√		null
project_info	project_outputfile	varchar	500	√		null
project_info	project_platform	varchar	400	√		null
project_info	project_platformdescription	varchar	4000	√		null
project_info	project_platformorganism	varchar	400	√		null
project_info	project_platformprovider	varchar	400	√		null
project_info	project_platformtechnology	varchar	400	√		null
project_info	project_platformtype	varchar	400	√		null
project_info	project_publishdate	varchar	100	√		null
project_info	project_pubmed	varchar	400	√		null
project_info	project_studytype	varchar	1000	√		null
project_info	project_supplementaryfile	varchar	400	√		null
project_info	project_tissue	varchar	400	√		null
project_info	project_title	varchar	500	√		null
project_info	project_weblink	varchar	1000	√		null
tests	adjusted_pvalue	float8	17,17	√		null
tests	estimate	float8	17,17	√		null
tests	fold_change	float8	17,17	√		null
tests	id	int8	19	√		null
tests	max_ls_mean	float8	17,17	√		null
tests	name	varchar	100	√		null
tests	platform	varchar	100	√		null
tests	probeset	varchar	100	√		null
tests	raw_pvalue	float8	17,17	√		null
tests	test	varchar	1000	√		null
tmp_bio_marker	gene_id	varchar	50	√		null
tmp_bio_marker	id	int8	19	√		null
tmp_bio_marker	organism	varchar	200	√		null
tmp_omicsoft_compound	accession	varchar	100	√		null
tmp_omicsoft_compound	bio_compound_id	int8	19
tmp_omicsoft_compound	bio_experiment_id	int8	19	√		null
tmp_omicsoft_compound	cas_registry	varchar	400	√		null
tmp_omicsoft_compound	compound	varchar	4000	√		null
tmp_omicsoft_disease_m1	accession	varchar	100	√		null
tmp_omicsoft_disease_m1	mesh_descriptor_id	varchar	15
tmp_omicsoft_disease_m1	mesh_heading	varchar	256	√		null
tmp_project_category	accession	varchar	100	√		null
tmp_project_category	category	varchar	4000	√		null
tmp_project_category	file_id	varchar	100	√		null
tmp_project_compound	accession	varchar	100	√		null
tmp_project_compound	compound	varchar	4000	√		null
tmp_project_compound	file_id	varchar	100	√		null
tmp_project_disease	accession	varchar	100	√		null
tmp_project_disease	disease	varchar	4000	√		null
tmp_project_disease	file_id	varchar	100	√		null
vw_faceted_search	analyses	varchar	200	√		null
vw_faceted_search	analysis_analyst_name	varchar	250	√		null
vw_faceted_search	analysis_data_type	varchar	50	√		null
vw_faceted_search	analysis_description_l	varchar	4000	√		null
vw_faceted_search	analysis_description_s	varchar	510	√		null
vw_faceted_search	analysis_id	int8	19	√		null
vw_faceted_search	analysis_method	varchar	50	√		null
vw_faceted_search	analysis_name	varchar	500	√		null
vw_faceted_search	analysis_qa_criteria	varchar	4000	√		null
vw_faceted_search	analysis_type	varchar	200	√		null
vw_faceted_search	data_type	varchar	50	√		null
vw_faceted_search	facet_id	int8	19	√		null
vw_faceted_search	model_description	varchar	500	√		null
vw_faceted_search	model_name	varchar	100	√		null
vw_faceted_search	observation	text	2147483647	√		null
vw_faceted_search	platform	varchar	20	√		null
vw_faceted_search	platform_description	varchar	2000	√		null
vw_faceted_search	platform_name	varchar	200	√		null
vw_faceted_search	platform_vendor	varchar	200	√		null
vw_faceted_search	research_unit	varchar	500	√		null
vw_faceted_search	study	int8	19	√		null
vw_faceted_search	study_access_type	varchar	100	√		null
vw_faceted_search	study_accession	varchar	100	√		null
vw_faceted_search	study_biomarker_type	varchar	255	√		null
vw_faceted_search	study_contact_field	varchar	400	√		null
vw_faceted_search	study_country	varchar	1000	√		null
vw_faceted_search	study_description	varchar	4000	√		null
vw_faceted_search	study_design	varchar	2000	√		null
vw_faceted_search	study_id	int8	19	√		null
vw_faceted_search	study_institution	varchar	400	√		null
vw_faceted_search	study_overall_design	varchar	2000	√		null
vw_faceted_search	study_primary_inv	varchar	400	√		null
vw_faceted_search	study_target	varchar	255	√		null
vw_faceted_search	study_title	varchar	1000	√		null
vw_faceted_search_disease	bio_assay_analysis_id	int8	19	√		null
vw_faceted_search_disease	solr_hierarchy	text	2147483647	√		null