transmart.tm_lz contains 541 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
clinical_trial_metadata_ext	biomarker_data_owner	varchar	4000	√		null
clinical_trial_metadata_ext	blinding_procedure	varchar	4000	√		null
clinical_trial_metadata_ext	completion_date	varchar	4000	√		null
clinical_trial_metadata_ext	condition	varchar	4000	√		null
clinical_trial_metadata_ext	data_source	varchar	100	√		null
clinical_trial_metadata_ext	description	varchar	4000	√		null
clinical_trial_metadata_ext	descriptive_trial_name	varchar	4000	√		null
clinical_trial_metadata_ext	development_partner	varchar	4000	√		null
clinical_trial_metadata_ext	disease_subtype	varchar	4000	√		null
clinical_trial_metadata_ext	dosing_regimen	varchar	4000	√		null
clinical_trial_metadata_ext	drug_cnto	varchar	4000	√		null
clinical_trial_metadata_ext	drug_name	varchar	4000	√		null
clinical_trial_metadata_ext	duration_of_study	varchar	4000	√		null
clinical_trial_metadata_ext	exclusion_criteria	varchar	4000	√		null
clinical_trial_metadata_ext	experimental_design	varchar	100	√		null
clinical_trial_metadata_ext	gender_restriction	varchar	4000	√		null
clinical_trial_metadata_ext	geo_platform	varchar	4000	√		null
clinical_trial_metadata_ext	group_assignment	varchar	4000	√		null
clinical_trial_metadata_ext	inclusion_criteria	varchar	4000	√		null
clinical_trial_metadata_ext	main_findings	varchar	4000	√		null
clinical_trial_metadata_ext	max_age	varchar	4000	√		null
clinical_trial_metadata_ext	min_age	varchar	4000	√		null
clinical_trial_metadata_ext	number_of_patients	varchar	4000	√		null
clinical_trial_metadata_ext	number_of_sites	varchar	4000	√		null
clinical_trial_metadata_ext	pi	varchar	4000	√		null
clinical_trial_metadata_ext	platform_name	varchar	4000	√		null
clinical_trial_metadata_ext	primary_endpoints	varchar	4000	√		null
clinical_trial_metadata_ext	route_of_admin	varchar	4000	√		null
clinical_trial_metadata_ext	search_area	varchar	100	√		null
clinical_trial_metadata_ext	secondary_endpoints	varchar	4000	√		null
clinical_trial_metadata_ext	secondary_ids	varchar	4000	√		null
clinical_trial_metadata_ext	study_design	varchar	4000	√		null
clinical_trial_metadata_ext	study_id	varchar	50	√		null
clinical_trial_metadata_ext	study_owner	varchar	4000	√		null
clinical_trial_metadata_ext	study_phase	varchar	4000	√		null
clinical_trial_metadata_ext	study_type	varchar	4000	√		null
clinical_trial_metadata_ext	subjects	varchar	4000	√		null
clinical_trial_metadata_ext	title	varchar	4000	√		null
clinical_trial_metadata_ext	trial	varchar	4000	√		null
clinical_trial_metadata_ext	type_of_control	varchar	4000	√		null
lt_chromosomal_region	chromosome	varchar	2	√		null
lt_chromosomal_region	cytoband	varchar	100	√		null
lt_chromosomal_region	end_bp	int8	19	√		null
lt_chromosomal_region	gene_id	int8	19	√		null
lt_chromosomal_region	gene_symbol	varchar	100	√		null
lt_chromosomal_region	gpl_id	varchar	50	√		null
lt_chromosomal_region	num_probes	int4	10	√		null
lt_chromosomal_region	organism	varchar	200	√		null
lt_chromosomal_region	region_id	bigserial	19		√	nextval('tm_lz.lt_chromo_region_id_seq'::regclass)
lt_chromosomal_region	region_name	varchar	100	√		null
lt_chromosomal_region	start_bp	int8	19	√		null
lt_metabolomic_annotation	biochemical_name	varchar	200	√		null
lt_metabolomic_annotation	gpl_id	varchar	20	√		null
lt_metabolomic_annotation	hmdb_id	varchar	20	√		null
lt_metabolomic_annotation	sub_pathway	varchar	200	√		null
lt_metabolomic_annotation	super_pathway	varchar	200	√		null
lt_metabolomic_display_mapping	category_cd	varchar	200
lt_metabolomic_display_mapping	display_label	varchar	200	√		null
lt_metabolomic_display_mapping	display_unit	varchar	20	√		null
lt_metabolomic_display_mapping	display_value	varchar	100	√		null
lt_protein_annotation	biomarker_id	numeric	131089	√		null
lt_protein_annotation	gpl_id	varchar	100	√		null
lt_protein_annotation	organism	varchar	100	√		null
lt_protein_annotation	peptide	varchar	200	√		null
lt_protein_annotation	uniprot_id	varchar	200	√		null
lt_qpcr_mirna_annotation	gpl_id	varchar	20	√		null
lt_qpcr_mirna_annotation	id_ref	varchar	100	√		null
lt_qpcr_mirna_annotation	mirna_id	varchar	100	√		null
lt_qpcr_mirna_annotation	organism	varchar	1000	√		null
lt_qpcr_mirna_annotation	sn_id	varchar	100	√		null
lt_rnaseq_annotation	gene_symbol	varchar	50	√		null
lt_rnaseq_annotation	organism	varchar	30	√		null
lt_rnaseq_annotation	transcript_id	varchar	50	√		null
lt_snp_calls_by_gsm	gsm_num	varchar	10	√		null
lt_snp_calls_by_gsm	snp_calls	varchar	4	√		null
lt_snp_calls_by_gsm	snp_name	varchar	100	√		null
lt_snp_copy_number	chrom	varchar	2	√		null
lt_snp_copy_number	chrom_pos	numeric	20	√		null
lt_snp_copy_number	copy_number	float8	17,17	√		null
lt_snp_copy_number	gsm_num	varchar	10	√		null
lt_snp_copy_number	snp_name	varchar	50	√		null
lt_snp_gene_map	entrez_gene_id	int8	19	√		null
lt_snp_gene_map	snp_name	varchar	2147483647	√		null
lt_src_acgh_data	chip	varchar	50	√		null
lt_src_acgh_data	expr_id	varchar	100	√		null
lt_src_acgh_data	flag	varchar	50	√		null
lt_src_acgh_data	probamp	varchar	50	√		null
lt_src_acgh_data	probgain	varchar	50	√		null
lt_src_acgh_data	probhomloss	varchar	50	√		null
lt_src_acgh_data	probloss	varchar	50	√		null
lt_src_acgh_data	probnorm	varchar	50	√		null
lt_src_acgh_data	region_name	varchar	100	√		null
lt_src_acgh_data	segmented	varchar	50	√		null
lt_src_acgh_data	trial_name	varchar	25	√		null
lt_src_cel_files	cel_file_name	varchar	500	√		null
lt_src_clinical_data	category_cd	varchar	250	√		null
lt_src_clinical_data	ctrl_vocab_code	varchar	200	√		null
lt_src_clinical_data	data_label	varchar	500	√		null
lt_src_clinical_data	data_label_components	varchar	1000	√		null
lt_src_clinical_data	data_label_ctrl_vocab_code	varchar	200	√		null
lt_src_clinical_data	data_value	varchar	500	√		null
lt_src_clinical_data	data_value_ctrl_vocab_code	varchar	500	√		null
lt_src_clinical_data	date_ind	bpchar	1	√		null
lt_src_clinical_data	date_timestamp	timestamp	29,6	√		null
lt_src_clinical_data	end_date	varchar	50	√		null
lt_src_clinical_data	link_type	varchar	20	√		null
lt_src_clinical_data	link_value	varchar	200	√		null
lt_src_clinical_data	modifier_cd	varchar	100	√		null
lt_src_clinical_data	obs_string	varchar	100	√		null
lt_src_clinical_data	sample_cd	varchar	200	√		null
lt_src_clinical_data	sample_type	varchar	100	√		null
lt_src_clinical_data	site_id	varchar	50	√		null
lt_src_clinical_data	study_id	varchar	25	√		null
lt_src_clinical_data	subject_id	varchar	100	√		null
lt_src_clinical_data	units_cd	varchar	50	√		null
lt_src_clinical_data	valuetype_cd	varchar	50	√		null
lt_src_clinical_data	visit_date	varchar	200	√		null
lt_src_clinical_data	visit_name	varchar	100	√		null
lt_src_clinical_data	visit_reference	varchar	100	√		null
lt_src_data_metadata	tag_name	varchar	200	√		null
lt_src_data_metadata	tag_path	varchar	2000	√		null
lt_src_data_metadata	tag_type	varchar	200	√		null
lt_src_data_metadata	tags_idx	int8	19	√		null
lt_src_deapp_annot	gene_id	varchar	250	√		null
lt_src_deapp_annot	gene_symbol	varchar	100	√		null
lt_src_deapp_annot	gpl_id	varchar	100	√		null
lt_src_deapp_annot	organism	varchar	200	√		null
lt_src_deapp_annot	probe_id	varchar	100	√		null
lt_src_display_mapping	category_cd	varchar	200
lt_src_display_mapping	display_label	varchar	200	√		null
lt_src_display_mapping	display_unit	varchar	200	√		null
lt_src_display_mapping	display_value	varchar	100	√		null
lt_src_metabolomic_data	biochemical	varchar	200	√		null
lt_src_metabolomic_data	expr_id	varchar	100	√		null
lt_src_metabolomic_data	intensity_value	varchar	50	√		null
lt_src_metabolomic_data	trial_name	varchar	25	√		null
lt_src_metabolomic_map	attribute_1	varchar	256	√		null
lt_src_metabolomic_map	attribute_2	varchar	200	√		null
lt_src_metabolomic_map	category_cd	varchar	200	√		null
lt_src_metabolomic_map	platform	varchar	100	√		null
lt_src_metabolomic_map	sample_cd	varchar	100	√		null
lt_src_metabolomic_map	site_id	varchar	100	√		null
lt_src_metabolomic_map	source_cd	varchar	200	√		null
lt_src_metabolomic_map	subject_id	varchar	100	√		null
lt_src_metabolomic_map	tissue_type	varchar	100	√		null
lt_src_metabolomic_map	trial_name	varchar	100	√		null
lt_src_metabolomics_display_mapping	category_cd	varchar	200
lt_src_metabolomics_display_mapping	display_label	varchar	200	√		null
lt_src_metabolomics_display_mapping	display_unit	varchar	20	√		null
lt_src_metabolomics_display_mapping	display_value	varchar	100	√		null
lt_src_mirna_deapp_annot	id_ref	varchar	100	√		null
lt_src_mirna_deapp_annot	mirna_id	varchar	250	√		null
lt_src_mirna_deapp_annot	mirna_symbol	varchar	100	√		null
lt_src_mirna_deapp_annot	organism	varchar	200	√		null
lt_src_mirna_deapp_annot	probe_id	varchar	100	√		null
lt_src_mirna_display_mapping	category_cd	varchar	200
lt_src_mirna_display_mapping	display_label	varchar	200	√		null
lt_src_mirna_display_mapping	display_unit	varchar	20	√		null
lt_src_mirna_display_mapping	display_value	varchar	100	√		null
lt_src_mirna_subj_samp_map	attribute_1	varchar	256	√		null
lt_src_mirna_subj_samp_map	attribute_2	varchar	200	√		null
lt_src_mirna_subj_samp_map	category_cd	varchar	200	√		null
lt_src_mirna_subj_samp_map	platform	varchar	100	√		null
lt_src_mirna_subj_samp_map	sample_cd	varchar	100	√		null
lt_src_mirna_subj_samp_map	site_id	varchar	100	√		null
lt_src_mirna_subj_samp_map	source_cd	varchar	200	√		null
lt_src_mirna_subj_samp_map	subject_id	varchar	100	√		null
lt_src_mirna_subj_samp_map	tissue_type	varchar	100	√		null
lt_src_mirna_subj_samp_map	trial_name	varchar	100	√		null
lt_src_mrna_data	expr_id	varchar	100	√		null
lt_src_mrna_data	intensity_value	varchar	50	√		null
lt_src_mrna_data	probeset	varchar	100	√		null
lt_src_mrna_data	trial_name	varchar	25	√		null
lt_src_mrna_subj_samp_map	attribute_1	varchar	256	√		null
lt_src_mrna_subj_samp_map	attribute_2	varchar	200	√		null
lt_src_mrna_subj_samp_map	category_cd	varchar	200	√		null
lt_src_mrna_subj_samp_map	platform	varchar	100	√		null
lt_src_mrna_subj_samp_map	sample_cd	varchar	100	√		null
lt_src_mrna_subj_samp_map	site_id	varchar	100	√		null
lt_src_mrna_subj_samp_map	source_cd	varchar	200	√		null
lt_src_mrna_subj_samp_map	subject_id	varchar	100	√		null
lt_src_mrna_subj_samp_map	tissue_type	varchar	100	√		null
lt_src_mrna_subj_samp_map	trial_name	varchar	100	√		null
lt_src_nextbio	bio_concept_code	varchar	1000	√		null
lt_src_nextbio	code_description	varchar	1000	√		null
lt_src_nextbio	code_name	varchar	1000	√		null
lt_src_nextbio	code_type_name	varchar	1000	√		null
lt_src_omicsoft_annot	etl_id	varchar	200	√		null
lt_src_omicsoft_annot	gene_id	varchar	250	√		null
lt_src_omicsoft_annot	gene_symbol	varchar	1000	√		null
lt_src_omicsoft_annot	gpl_id	varchar	100	√		null
lt_src_omicsoft_annot	organism	varchar	200	√		null
lt_src_omicsoft_annot	probe_id	varchar	100	√		null
lt_src_omicsoft_data	adj_p_value	varchar	200	√		null
lt_src_omicsoft_data	bio_assay_analysis_id	int8	19	√		null
lt_src_omicsoft_data	contrast_name	varchar	1000	√		null
lt_src_omicsoft_data	estimate	float8	17,17	√		null
lt_src_omicsoft_data	etl_id	varchar	200	√		null
lt_src_omicsoft_data	fold_change	float8	17,17	√		null
lt_src_omicsoft_data	id	varchar	1000	√		null
lt_src_omicsoft_data	max_l_s_mean	float8	17,17	√		null
lt_src_omicsoft_data	mean_fold_change	float8	17,17	√		null
lt_src_omicsoft_data	probe_id	varchar	1000	√		null
lt_src_omicsoft_data	raw_p_value	varchar	200	√		null
lt_src_omicsoft_data	std_dev_fold_change	float8	17,17	√		null
lt_src_omicsoft_data	tea_normal_pvalue	float8	17,17	√		null
lt_src_pathway	gene	varchar	1000	√		null
lt_src_pathway	name	varchar	1000	√		null
lt_src_pathway	organism	varchar	200	√		null
lt_src_pathway_org	gene	varchar	1000	√		null
lt_src_pathway_org	id	varchar	20	√		null
lt_src_pathway_org	name	varchar	1000	√		null
lt_src_pathway_org	organism	varchar	200	√		null
lt_src_protein_display_mapping	category_cd	varchar	200
lt_src_protein_display_mapping	display_label	varchar	200	√		null
lt_src_protein_display_mapping	display_unit	varchar	20	√		null
lt_src_protein_display_mapping	display_value	varchar	100	√		null
lt_src_proteomics_data	intensity_value	varchar	50	√		null
lt_src_proteomics_data	m_p_id	varchar	100	√		null
lt_src_proteomics_data	peptide	varchar	100	√		null
lt_src_proteomics_data	trial_name	varchar	25	√		null
lt_src_proteomics_sub_sam_map	attribute_1	varchar	256	√		null
lt_src_proteomics_sub_sam_map	attribute_2	varchar	200	√		null
lt_src_proteomics_sub_sam_map	category_cd	varchar	200	√		null
lt_src_proteomics_sub_sam_map	platform	varchar	100	√		null
lt_src_proteomics_sub_sam_map	sample_cd	varchar	100	√		null
lt_src_proteomics_sub_sam_map	site_id	varchar	100	√		null
lt_src_proteomics_sub_sam_map	source_cd	varchar	200	√		null
lt_src_proteomics_sub_sam_map	subject_id	varchar	100	√		null
lt_src_proteomics_sub_sam_map	tissue_type	varchar	100	√		null
lt_src_proteomics_sub_sam_map	trial_name	varchar	100	√		null
lt_src_qpcr_mirna_data	expr_id	varchar	100	√		null
lt_src_qpcr_mirna_data	intensity_value	varchar	50	√		null
lt_src_qpcr_mirna_data	probeset	varchar	100	√		null
lt_src_qpcr_mirna_data	trial_name	varchar	25	√		null
lt_src_rbm_annotation	antigen_name	varchar	200	√		null
lt_src_rbm_annotation	gene_id	varchar	50	√		null
lt_src_rbm_annotation	gene_symbol	varchar	200	√		null
lt_src_rbm_annotation	gpl_id	varchar	50	√		null
lt_src_rbm_annotation	uniprotid	varchar	50	√		null
lt_src_rbm_data	analyte	varchar	200	√		null
lt_src_rbm_data	avalue	varchar	200	√		null
lt_src_rbm_data	sample_id	varchar	200	√		null
lt_src_rbm_data	trial_id	varchar	20	√		null
lt_src_rbm_display_mapping	category_cd	varchar	200
lt_src_rbm_display_mapping	display_label	varchar	200	√		null
lt_src_rbm_display_mapping	display_unit	varchar	20	√		null
lt_src_rbm_display_mapping	display_value	varchar	100	√		null
lt_src_rbm_subj_samp_map	attribute_1	varchar	256	√		null
lt_src_rbm_subj_samp_map	attribute_2	varchar	200	√		null
lt_src_rbm_subj_samp_map	category_cd	varchar	200	√		null
lt_src_rbm_subj_samp_map	platform	varchar	100	√		null
lt_src_rbm_subj_samp_map	sample_cd	varchar	100	√		null
lt_src_rbm_subj_samp_map	site_id	varchar	100	√		null
lt_src_rbm_subj_samp_map	source_cd	varchar	200	√		null
lt_src_rbm_subj_samp_map	subject_id	varchar	100	√		null
lt_src_rbm_subj_samp_map	tissue_type	varchar	100	√		null
lt_src_rbm_subj_samp_map	trial_name	varchar	100	√		null
lt_src_rna_display_mapping	category_cd	varchar	200
lt_src_rna_display_mapping	display_label	varchar	200	√		null
lt_src_rna_display_mapping	display_unit	varchar	20	√		null
lt_src_rna_display_mapping	display_value	varchar	100	√		null
lt_src_rna_seq_data	expr_id	varchar	100	√		null
lt_src_rna_seq_data	intensity_value	varchar	50	√		null
lt_src_rna_seq_data	probeset	varchar	100	√		null
lt_src_rna_seq_data	trial_name	varchar	25	√		null
lt_src_rna_seq_subj_samp_map	attribute_1	varchar	256	√		null
lt_src_rna_seq_subj_samp_map	attribute_2	varchar	200	√		null
lt_src_rna_seq_subj_samp_map	category_cd	varchar	200	√		null
lt_src_rna_seq_subj_samp_map	platform	varchar	100	√		null
lt_src_rna_seq_subj_samp_map	sample_cd	varchar	100	√		null
lt_src_rna_seq_subj_samp_map	site_id	varchar	100	√		null
lt_src_rna_seq_subj_samp_map	source_cd	varchar	200	√		null
lt_src_rna_seq_subj_samp_map	subject_id	varchar	100	√		null
lt_src_rna_seq_subj_samp_map	tissue_type	varchar	100	√		null
lt_src_rna_seq_subj_samp_map	trial_name	varchar	100	√		null
lt_src_rnaseq_data	expr_id	varchar	100	√		null
lt_src_rnaseq_data	normalized_readcount	varchar	50	√		null
lt_src_rnaseq_data	readcount	varchar	50	√		null
lt_src_rnaseq_data	region_name	varchar	100	√		null
lt_src_rnaseq_data	trial_name	varchar	25	√		null
lt_src_sample_categories	category_cd	varchar	200	√		null
lt_src_sample_categories	category_value	varchar	200	√		null
lt_src_sample_categories	sample_cd	varchar	200	√		null
lt_src_sample_categories	site_cd	varchar	200	√		null
lt_src_sample_categories	subject_cd	varchar	200	√		null
lt_src_sample_categories	trial_cd	varchar	200	√		null
lt_src_search_keyword	bio_data_id	varchar	300	√		null
lt_src_search_keyword	data_category	varchar	200	√		null
lt_src_search_keyword	display_category	varchar	300	√		null
lt_src_search_keyword	keyword	varchar	300	√		null
lt_src_search_keyword	parent_term	varchar	300	√		null
lt_src_search_keyword	source_cd	varchar	200	√		null
lt_src_search_keyword	uid_prefix	varchar	20	√		null
lt_src_search_keyword	unique_id	varchar	300	√		null
lt_src_study_metadata	access_type	varchar	100	√		null
lt_src_study_metadata	biomarker_type	varchar	255	√		null
lt_src_study_metadata	blinding_procedure	varchar	1000	√		null
lt_src_study_metadata	completion_date	varchar	50	√		null
lt_src_study_metadata	compound	varchar	1000	√		null
lt_src_study_metadata	contact_field	varchar	400	√		null
lt_src_study_metadata	country	varchar	50	√		null
lt_src_study_metadata	description	varchar	4000	√		null
lt_src_study_metadata	design	varchar	2000	√		null
lt_src_study_metadata	development_partner	varchar	100	√		null
lt_src_study_metadata	disease	varchar	1000	√		null
lt_src_study_metadata	dosing_regimen	varchar	3500	√		null
lt_src_study_metadata	duration_of_study_weeks	varchar	200	√		null
lt_src_study_metadata	exclusion_criteria	varchar	4000	√		null
lt_src_study_metadata	gender_restriction_mfb	varchar	510	√		null
lt_src_study_metadata	geo_platform	varchar	100	√		null
lt_src_study_metadata	group_assignment	varchar	510	√		null
lt_src_study_metadata	inclusion_criteria	varchar	4000	√		null
lt_src_study_metadata	institution	varchar	100	√		null
lt_src_study_metadata	main_findings	varchar	2000	√		null
lt_src_study_metadata	max_age	varchar	100	√		null
lt_src_study_metadata	min_age	varchar	100	√		null
lt_src_study_metadata	number_of_patients	varchar	200	√		null
lt_src_study_metadata	number_of_sites	varchar	200	√		null
lt_src_study_metadata	organism	varchar	200	√		null
lt_src_study_metadata	overall_design	varchar	2000	√		null
lt_src_study_metadata	primary_end_points	varchar	2000	√		null
lt_src_study_metadata	primary_investigator	varchar	400	√		null
lt_src_study_metadata	pubmed_ids	varchar	4000	√		null
lt_src_study_metadata	route_of_administration	varchar	510	√		null
lt_src_study_metadata	search_area	varchar	100	√		null
lt_src_study_metadata	secondary_end_points	varchar	3500	√		null
lt_src_study_metadata	secondary_ids	varchar	510	√		null
lt_src_study_metadata	start_date	varchar	50	√		null
lt_src_study_metadata	status	varchar	100	√		null
lt_src_study_metadata	study_access_type	varchar	500	√		null
lt_src_study_metadata	study_biomarker_type	varchar	500	√		null
lt_src_study_metadata	study_compound	varchar	500	√		null
lt_src_study_metadata	study_country	varchar	500	√		null
lt_src_study_metadata	study_date	varchar	50	√		null
lt_src_study_metadata	study_description	varchar	2000	√		null
lt_src_study_metadata	study_design_factors	varchar	2000	√		null
lt_src_study_metadata	study_id	varchar	100	√		null
lt_src_study_metadata	study_institution	varchar	500	√		null
lt_src_study_metadata	study_nbr_subjects	varchar	20	√		null
lt_src_study_metadata	study_objective	varchar	2000	√		null
lt_src_study_metadata	study_organism	varchar	500	√		null
lt_src_study_metadata	study_owner	varchar	510	√		null
lt_src_study_metadata	study_phase	varchar	100	√		null
lt_src_study_metadata	study_related_publication	varchar	500	√		null
lt_src_study_metadata	study_title	varchar	500	√		null
lt_src_study_metadata	studytype	varchar	510	√		null
lt_src_study_metadata	subjects	varchar	2000	√		null
lt_src_study_metadata	target	varchar	255	√		null
lt_src_study_metadata	title	varchar	1000	√		null
lt_src_study_metadata	type_of_control	varchar	510	√		null
lt_src_study_metadata_ad_hoc	ad_hoc_property_key	varchar	500	√		null
lt_src_study_metadata_ad_hoc	ad_hoc_property_link	varchar	500	√		null
lt_src_study_metadata_ad_hoc	ad_hoc_property_value	varchar	4000	√		null
lt_src_study_metadata_ad_hoc	study_id	varchar	100	√		null
lt_src_subj_enroll_date	enroll_date	varchar	25	√		null
lt_src_subj_enroll_date	site_id	varchar	50	√		null
lt_src_subj_enroll_date	study_id	varchar	25	√		null
lt_src_subj_enroll_date	subject_id	varchar	20	√		null
lz_src_analysis_metadata	analysis_name	varchar	500	√		null
lz_src_analysis_metadata	analysis_name_archived	varchar	500	√		null
lz_src_analysis_metadata	cell_type	varchar	500	√		null
lz_src_analysis_metadata	data_type	varchar	50	√		null
lz_src_analysis_metadata	description	varchar	2048	√		null
lz_src_analysis_metadata	etl_date	timestamp	29,6	√		null
lz_src_analysis_metadata	etl_id	numeric	38	√		null
lz_src_analysis_metadata	expression_platform_ids	varchar	500	√		null
lz_src_analysis_metadata	filename	varchar	500	√		null
lz_src_analysis_metadata	genome_version	varchar	50	√		null
lz_src_analysis_metadata	genotype_platform_ids	varchar	500	√		null
lz_src_analysis_metadata	model_desc	varchar	500	√		null
lz_src_analysis_metadata	model_name	varchar	500	√		null
lz_src_analysis_metadata	phenotype_ids	varchar	250	√		null
lz_src_analysis_metadata	population	varchar	500	√		null
lz_src_analysis_metadata	process_date	timestamp	29,6	√		null
lz_src_analysis_metadata	pvalue_cutoff	varchar	50	√		null
lz_src_analysis_metadata	research_unit	varchar	500	√		null
lz_src_analysis_metadata	sample_size	varchar	500	√		null
lz_src_analysis_metadata	sensitive_desc	varchar	500	√		null
lz_src_analysis_metadata	sensitive_flag	numeric	18	√		null
lz_src_analysis_metadata	statistical_test	varchar	500	√		null
lz_src_analysis_metadata	status	varchar	50	√		null
lz_src_analysis_metadata	study_id	varchar	50	√		null
lz_src_analysis_metadata	tissue	varchar	500	√		null
lz_src_clinical_data	category_cd	varchar	250	√		null
lz_src_clinical_data	ctrl_vocab_code	varchar	200	√		null
lz_src_clinical_data	data_label	varchar	500	√		null
lz_src_clinical_data	data_label_components	varchar	1000	√		null
lz_src_clinical_data	data_label_ctrl_vocab_code	varchar	200	√		null
lz_src_clinical_data	data_value	varchar	500	√		null
lz_src_clinical_data	data_value_ctrl_vocab_code	varchar	500	√		null
lz_src_clinical_data	date_ind	bpchar	1	√		null
lz_src_clinical_data	date_timestamp	timestamp	29,6	√		null
lz_src_clinical_data	end_date	varchar	50	√		null
lz_src_clinical_data	etl_date	timestamp	29,6	√		null
lz_src_clinical_data	etl_job_id	numeric	22	√		null
lz_src_clinical_data	link_type	varchar	20	√		null
lz_src_clinical_data	link_value	varchar	200	√		null
lz_src_clinical_data	modifier_cd	varchar	100	√		null
lz_src_clinical_data	obs_string	varchar	100	√		null
lz_src_clinical_data	sample_type	varchar	100	√		null
lz_src_clinical_data	site_id	varchar	50	√		null
lz_src_clinical_data	study_id	varchar	25	√		null
lz_src_clinical_data	subject_id	varchar	100	√		null
lz_src_clinical_data	units_cd	varchar	50	√		null
lz_src_clinical_data	valuetype_cd	varchar	50	√		null
lz_src_clinical_data	visit_date	varchar	50	√		null
lz_src_clinical_data	visit_name	varchar	100	√		null
lz_src_clinical_data	visit_reference	varchar	100	√		null
lz_src_mrna_data	expr_id	varchar	100	√		null
lz_src_mrna_data	intensity_value	varchar	50	√		null
lz_src_mrna_data	probeset	varchar	100	√		null
lz_src_mrna_data	source_cd	varchar	200	√		null
lz_src_mrna_data	trial_name	varchar	25	√		null
lz_src_mrna_subj_samp_map	attribute_1	varchar	256	√		null
lz_src_mrna_subj_samp_map	attribute_2	varchar	200	√		null
lz_src_mrna_subj_samp_map	category_cd	varchar	200	√		null
lz_src_mrna_subj_samp_map	platform	varchar	100	√		null
lz_src_mrna_subj_samp_map	sample_cd	varchar	100	√		null
lz_src_mrna_subj_samp_map	site_id	varchar	100	√		null
lz_src_mrna_subj_samp_map	source_cd	varchar	200	√		null
lz_src_mrna_subj_samp_map	subject_id	varchar	100	√		null
lz_src_mrna_subj_samp_map	tissue_type	varchar	100	√		null
lz_src_mrna_subj_samp_map	trial_name	varchar	100	√		null
lz_src_sample_categories	category_cd	varchar	200	√		null
lz_src_sample_categories	category_value	varchar	200	√		null
lz_src_sample_categories	sample_cd	varchar	200	√		null
lz_src_sample_categories	site_cd	varchar	200	√		null
lz_src_sample_categories	subject_cd	varchar	200	√		null
lz_src_sample_categories	trial_cd	varchar	200	√		null
lz_src_sample_categories_bkup	category_cd	varchar	200	√		null
lz_src_sample_categories_bkup	category_value	varchar	200	√		null
lz_src_sample_categories_bkup	sample_cd	varchar	200	√		null
lz_src_sample_categories_bkup	site_cd	varchar	200	√		null
lz_src_sample_categories_bkup	subject_cd	varchar	200	√		null
lz_src_sample_categories_bkup	trial_cd	varchar	200	√		null
lz_src_study_metadata	study_access_type	varchar	500	√		null
lz_src_study_metadata	study_biomarker_type	varchar	500	√		null
lz_src_study_metadata	study_compound	varchar	500	√		null
lz_src_study_metadata	study_country	varchar	500	√		null
lz_src_study_metadata	study_date	varchar	50	√		null
lz_src_study_metadata	study_description	varchar	2000	√		null
lz_src_study_metadata	study_design_factors	varchar	2000	√		null
lz_src_study_metadata	study_id	varchar	50	√		null
lz_src_study_metadata	study_institution	varchar	500	√		null
lz_src_study_metadata	study_nbr_subjects	varchar	20	√		null
lz_src_study_metadata	study_objective	varchar	2000	√		null
lz_src_study_metadata	study_organism	varchar	500	√		null
lz_src_study_metadata	study_owner	varchar	500	√		null
lz_src_study_metadata	study_phase	varchar	500	√		null
lz_src_study_metadata	study_related_publication	varchar	500	√		null
lz_src_study_metadata	study_title	varchar	500	√		null
lz_src_study_metadata_ad_hoc	ad_hoc_property_key	varchar	500	√		null
lz_src_study_metadata_ad_hoc	ad_hoc_property_link	varchar	500	√		null
lz_src_study_metadata_ad_hoc	ad_hoc_property_value	varchar	4000	√		null
lz_src_study_metadata_ad_hoc	study_id	varchar	100	√		null
lz_src_study_metadata_ad_hoc	upload_date	timestamp	29,6	√		null
lz_src_subj_enroll_date	enroll_date	varchar	25	√		null
lz_src_subj_enroll_date	site_id	varchar	50	√		null
lz_src_subj_enroll_date	study_id	varchar	25	√		null
lz_src_subj_enroll_date	subject_id	varchar	20	√		null
rwg_analysis	analysis_id	varchar	500	√		null
rwg_analysis	analysis_type	varchar	500	√		null
rwg_analysis	bio_assay_analysis_id	int8	19	√		null
rwg_analysis	cohorts	varchar	500	√		null
rwg_analysis	data_type	varchar	500	√		null
rwg_analysis	foldchange_cutoff	float8	17,17	√		null
rwg_analysis	import_date	timestamp	29,6			now()
rwg_analysis	long_desc	varchar	500	√		null
rwg_analysis	lsmean_cutoff	float8	17,17	√		null
rwg_analysis	platform	varchar	500	√		null
rwg_analysis	pvalue_cutoff	float8	17,17	√		null
rwg_analysis	short_desc	varchar	500	√		null
rwg_analysis	study_id	varchar	500	√		null
rwg_analysis_data	adjusted_pvalue	float8	17,17	√		null
rwg_analysis_data	analysis_cd	varchar	100	√		null
rwg_analysis_data	bio_assay_analysis_id	int8	19	√		null
rwg_analysis_data	fold_change	float8	17,17	√		null
rwg_analysis_data	max_lsmean	float8	17,17	√		null
rwg_analysis_data	min_lsmean	float8	17,17	√		null
rwg_analysis_data	probeset	varchar	200	√		null
rwg_analysis_data	pvalue	float8	17,17	√		null
rwg_analysis_data	raw_pvalue	float8	17,17	√		null
rwg_analysis_data	study_id	varchar	200	√		null
rwg_analysis_data_ext	adjusted_pvalue	varchar	100	√		null
rwg_analysis_data_ext	analysis_id	varchar	100	√		null
rwg_analysis_data_ext	fold_change	varchar	100	√		null
rwg_analysis_data_ext	lsmean_1	varchar	100	√		null
rwg_analysis_data_ext	lsmean_2	varchar	100	√		null
rwg_analysis_data_ext	preferred_pvalue	varchar	100	√		null
rwg_analysis_data_ext	probeset	varchar	100	√		null
rwg_analysis_data_ext	raw_pvalue	varchar	100	√		null
rwg_analysis_ext	analysis_id	varchar	500	√		null
rwg_analysis_ext	analysis_type	varchar	500	√		null
rwg_analysis_ext	cohorts	varchar	500	√		null
rwg_analysis_ext	data_type	varchar	500	√		null
rwg_analysis_ext	foldchange_cutoff	varchar	500	√		null
rwg_analysis_ext	long_desc	varchar	500	√		null
rwg_analysis_ext	lsmean_cutoff	varchar	500	√		null
rwg_analysis_ext	platform	varchar	500	√		null
rwg_analysis_ext	pvalue_cutoff	varchar	500	√		null
rwg_analysis_ext	short_desc	varchar	500	√		null
rwg_analysis_ext	study_id	varchar	500	√		null
rwg_cohorts	cohort_id	varchar	500	√		null
rwg_cohorts	cohort_title	varchar	500	√		null
rwg_cohorts	disease	varchar	500	√		null
rwg_cohorts	import_date	timestamp	29,6			now()
rwg_cohorts	long_desc	varchar	500	√		null
rwg_cohorts	organism	varchar	500	√		null
rwg_cohorts	pathology	varchar	500	√		null
rwg_cohorts	sample_type	varchar	500	√		null
rwg_cohorts	short_desc	varchar	500	√		null
rwg_cohorts	study_id	varchar	500	√		null
rwg_cohorts	treatment	varchar	500	√		null
rwg_cohorts_ext	cohort_id	varchar	500	√		null
rwg_cohorts_ext	cohort_title	varchar	500	√		null
rwg_cohorts_ext	disease	varchar	500	√		null
rwg_cohorts_ext	long_desc	varchar	500	√		null
rwg_cohorts_ext	organism	varchar	500	√		null
rwg_cohorts_ext	pathology	varchar	500	√		null
rwg_cohorts_ext	sample_type	varchar	500	√		null
rwg_cohorts_ext	short_desc	varchar	500	√		null
rwg_cohorts_ext	study_id	varchar	500	√		null
rwg_cohorts_ext	treatment	varchar	500	√		null
rwg_samples	cohorts	varchar	500	√		null
rwg_samples	expr_id	varchar	500	√		null
rwg_samples	import_date	timestamp	29,6			now()
rwg_samples	study_id	varchar	500	√		null
rwg_samples_ext	cohorts	varchar	500	√		null
rwg_samples_ext	expr_id	varchar	500	√		null
rwg_samples_ext	study_id	varchar	500	√		null
wt_snp_node_values	category_cd	varchar	500	√		null
wt_snp_node_values	sample_type	varchar	200	√		null
wt_snp_node_values	timepoint	varchar	200	√		null
wt_snp_node_values	title	varchar	500	√		null
wt_snp_nodes	category_cd	varchar	500	√		null
wt_snp_nodes	leaf_node	varchar	2000	√		null
wt_snp_nodes	node_type	varchar	100	√		null
wt_snp_nodes	platform	varchar	500	√		null
wt_snp_nodes	sample_type	varchar	200	√		null
wt_snp_nodes	timepoint	varchar	200	√		null