transmart.tm_cz contains 617 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
all_test_detail_view	act_record_cnt	float8	17,17	√		null
all_test_detail_view	category	varchar	255	√		null
all_test_detail_view	end_date	text	2147483647	√		null
all_test_detail_view	error_code	varchar	30	√		null
all_test_detail_view	error_message	varchar	4000	√		null
all_test_detail_view	max_value_allowed	float8	17,17	√		null
all_test_detail_view	min_value_allowed	float8	17,17	√		null
all_test_detail_view	run_id	int8	19	√		null
all_test_detail_view	run_name	varchar	200	√		null
all_test_detail_view	start_date	text	2147483647	√		null
all_test_detail_view	status	varchar	20	√		null
all_test_detail_view	sub_category1	varchar	255	√		null
all_test_detail_view	sub_category2	varchar	255	√		null
all_test_detail_view	test_id	int8	19	√		null
all_test_detail_view	test_severity_cd	varchar	20	√		null
all_test_detail_view	vcolumn	varchar	255	√		null
all_test_detail_view	vsql	varchar	2000	√		null
all_test_detail_view	vtable	varchar	255	√		null
all_test_summary_view	db_version	varchar	200	√		null
all_test_summary_view	end_date	text	2147483647	√		null
all_test_summary_view	error	int8	19	√		null
all_test_summary_view	fail	int8	19	√		null
all_test_summary_view	pass	int8	19	√		null
all_test_summary_view	start_date	text	2147483647	√		null
all_test_summary_view	status	varchar	20	√		null
all_test_summary_view	test_category	varchar	255	√		null
all_test_summary_view	test_run_id	int8	19	√		null
all_test_summary_view	test_run_name	varchar	200	√		null
all_test_summary_view	test_sub_category1	varchar	255	√		null
all_test_summary_view	test_sub_category2	varchar	255	√		null
all_test_summary_view	total	int8	19	√		null
all_test_summary_view	warning	int8	19	√		null
annotation_deapp	gene_id	varchar	100	√		null
annotation_deapp	gene_symbol	varchar	100	√		null
annotation_deapp	gpl_id	varchar	100	√		null
annotation_deapp	organism	varchar	200	√		null
annotation_deapp	probe_id	varchar	100	√		null
annotation_deapp	probeset_id	int8	19	√		null
annotation_deapp_20120206	gene_id	varchar	100	√		null
annotation_deapp_20120206	gene_symbol	varchar	100	√		null
annotation_deapp_20120206	gpl_id	varchar	100	√		null
annotation_deapp_20120206	probe_id	varchar	100	√		null
annotation_deapp_20120206	probeset_id	int8	19	√		null
antigen_deapp	antigen_id	int8	19
antigen_deapp	antigen_name	varchar	100
antigen_deapp	platform	varchar	100
az_test_comparison_info	curr_act_record_cnt	float8	17,17	√		null
az_test_comparison_info	curr_dw_version_id	int8	19	√		null
az_test_comparison_info	curr_run_date	timestamp	29,6	√		null
az_test_comparison_info	curr_test_step_run_id	int8	19	√		null
az_test_comparison_info	param1	varchar	4000	√		null
az_test_comparison_info	prev_act_record_cnt	float8	17,17	√		null
az_test_comparison_info	prev_dw_version_id	int8	19	√		null
az_test_comparison_info	prev_run_date	date	13	√		null
az_test_comparison_info	prev_test_step_run_id	int8	19	√		null
az_test_comparison_info	test_id	int8	19	√		null
az_test_run	dw_version_id	int8	19	√		null
az_test_run	end_date	timestamp	29,6	√		null
az_test_run	param1	varchar	4000	√		null
az_test_run	return_code	varchar	30	√		null
az_test_run	return_message	varchar	4000	√		null
az_test_run	start_date	timestamp	29,6	√		null
az_test_run	status	varchar	20	√		null
az_test_run	test_category_id	int8	19	√		null
az_test_run	test_run_id	int8	19
az_test_run	test_run_name	varchar	200	√		null
az_test_step_act_result	act_record_cnt	float8	17,17	√		null
az_test_step_act_result	return_code	varchar	30	√		null
az_test_step_act_result	return_error_back_trace	varchar	4000	√		null
az_test_step_act_result	return_error_stack	varchar	4000	√		null
az_test_step_act_result	return_message	varchar	4000	√		null
az_test_step_act_result	test_step_act_result_id	int8	19
az_test_step_act_result	test_step_run_id	int8	19
az_test_step_run	end_date	timestamp	29,6	√		null
az_test_step_run	param1	varchar	4000	√		null
az_test_step_run	seq_id	int8	19	√		null
az_test_step_run	start_date	timestamp	29,6	√		null
az_test_step_run	status	varchar	20	√		null
az_test_step_run	test_id	int8	19
az_test_step_run	test_run_id	int8	19
az_test_step_run	test_step_run_id	int8	19
bio_clinical_trial_release	bio_experiment_id	int8	19	√		null
bio_clinical_trial_release	blinding_procedure	varchar	1000	√		null
bio_clinical_trial_release	completion_date	timestamp	29,6	√		null
bio_clinical_trial_release	development_partner	varchar	100	√		null
bio_clinical_trial_release	dosing_regimen	varchar	3500	√		null
bio_clinical_trial_release	duration_of_study_weeks	int4	10	√		null
bio_clinical_trial_release	exclusion_criteria	text	2147483647	√		null
bio_clinical_trial_release	gender_restriction_mfb	varchar	510	√		null
bio_clinical_trial_release	geo_platform	varchar	30	√		null
bio_clinical_trial_release	group_assignment	varchar	510	√		null
bio_clinical_trial_release	inclusion_criteria	text	2147483647	√		null
bio_clinical_trial_release	main_findings	varchar	2000	√		null
bio_clinical_trial_release	max_age	int4	10	√		null
bio_clinical_trial_release	min_age	int4	10	√		null
bio_clinical_trial_release	number_of_patients	int4	10	√		null
bio_clinical_trial_release	number_of_sites	int4	10	√		null
bio_clinical_trial_release	platform_name	varchar	200	√		null
bio_clinical_trial_release	primary_end_points	varchar	2000	√		null
bio_clinical_trial_release	release_study	varchar	510	√		null
bio_clinical_trial_release	route_of_administration	varchar	510	√		null
bio_clinical_trial_release	search_area	varchar	100	√		null
bio_clinical_trial_release	secondary_end_points	varchar	3500	√		null
bio_clinical_trial_release	secondary_ids	varchar	510	√		null
bio_clinical_trial_release	study_owner	varchar	510	√		null
bio_clinical_trial_release	study_phase	varchar	100	√		null
bio_clinical_trial_release	studytype	varchar	510	√		null
bio_clinical_trial_release	subjects	varchar	2000	√		null
bio_clinical_trial_release	trial_number	varchar	510	√		null
bio_clinical_trial_release	type_of_control	varchar	510	√		null
bio_data_compound_release	bio_compound_id	int8	19
bio_data_compound_release	bio_data_id	int8	19
bio_data_compound_release	etl_source	varchar	100	√		null
bio_data_compound_release	release_study	varchar	100	√		null
bio_data_uid_release	bio_data_id	int8	19
bio_data_uid_release	bio_data_type	varchar	100
bio_data_uid_release	release_study	varchar	200
bio_data_uid_release	unique_id	varchar	200
bio_experiment_release	access_type	varchar	100	√		null
bio_experiment_release	accession	varchar	100
bio_experiment_release	bio_experiment_id	int8	19	√		null
bio_experiment_release	bio_experiment_type	varchar	200	√		null
bio_experiment_release	biomarker_type	varchar	255	√		null
bio_experiment_release	completion_date	timestamp	29,6	√		null
bio_experiment_release	contact_field	varchar	400	√		null
bio_experiment_release	country	varchar	50	√		null
bio_experiment_release	description	varchar	2000	√		null
bio_experiment_release	design	varchar	2000	√		null
bio_experiment_release	entrydt	timestamp	29,6	√		null
bio_experiment_release	etl_id	varchar	100	√		null
bio_experiment_release	institution	varchar	100	√		null
bio_experiment_release	overall_design	varchar	2000	√		null
bio_experiment_release	primary_investigator	varchar	400	√		null
bio_experiment_release	release_study	varchar	100
bio_experiment_release	start_date	timestamp	29,6	√		null
bio_experiment_release	status	varchar	100	√		null
bio_experiment_release	target	varchar	255	√		null
bio_experiment_release	title	varchar	1000	√		null
bio_experiment_release	updated	timestamp	29,6	√		null
category_path_excluded_words	excluded_text	varchar	100	√		null
concept_dimension_release	concept_blob	text	2147483647	√		null
concept_dimension_release	concept_cd	varchar	50
concept_dimension_release	concept_path	varchar	700
concept_dimension_release	download_date	timestamp	29,6	√		null
concept_dimension_release	import_date	timestamp	29,6	√		null
concept_dimension_release	name_char	varchar	2000	√		null
concept_dimension_release	release_study	varchar	50	√		null
concept_dimension_release	sourcesystem_cd	varchar	50	√		null
concept_dimension_release	table_name	varchar	255	√		null
concept_dimension_release	update_date	timestamp	29,6	√		null
concept_dimension_release	upload_id	int8	19	√		null
currtime	clock_timestamp	timestamptz	35,6	√		null
cz_data	business_desc	varchar	1000	√		null
cz_data	create_date	timestamp	29,6	√		null
cz_data	custodian_id	int8	19	√		null
cz_data	data_id	int8	19
cz_data	data_name	varchar	200	√		null
cz_data	load_freq	varchar	20	√		null
cz_data	owner_id	int8	19	√		null
cz_data	technical_desc	varchar	1000	√		null
cz_data_file	act_record_cnt	int8	19	√		null
cz_data_file	contact_id	int8	19	√		null
cz_data_file	data_file_id	int8	19
cz_data_file	data_id	int8	19
cz_data_file	description	varchar	2000	√		null
cz_data_file	exp_record_cnt	int8	19	√		null
cz_data_file	extraction_date	timestamp	29,6	√		null
cz_data_file	file_name	varchar	200	√		null
cz_data_file	location	varchar	500	√		null
cz_data_file	provider	varchar	200	√		null
cz_data_file	url	varchar	500	√		null
cz_data_profile_column_exclusi	column_name	varchar	500
cz_data_profile_column_exclusi	etl_date	timestamp	29,6	√		('now'::text)::timestamp without time zone
cz_data_profile_column_exclusi	exclusion_reason	varchar	2000	√		null
cz_data_profile_column_exclusi	table_name	varchar	500
cz_data_profile_column_sample	column_name	varchar	500	√		null
cz_data_profile_column_sample	count	int8	19	√		null
cz_data_profile_column_sample	etl_date	timestamp	29,6	√		('now'::text)::timestamp without time zone
cz_data_profile_column_sample	table_name	varchar	500	√		null
cz_data_profile_column_sample	value	varchar	4000	√		null
cz_data_profile_stats	column_length	int4	10	√		null
cz_data_profile_stats	column_name	varchar	500
cz_data_profile_stats	column_precision	int4	10	√		null
cz_data_profile_stats	column_scale	int4	10
cz_data_profile_stats	data_type	varchar	500	√		null
cz_data_profile_stats	distinct_count	int8	19	√		null
cz_data_profile_stats	etl_date	timestamp	29,6	√		('now'::text)::timestamp without time zone
cz_data_profile_stats	first_value	varchar	4000	√		null
cz_data_profile_stats	last_value	varchar	4000	√		null
cz_data_profile_stats	max_length	int4	10	√		null
cz_data_profile_stats	max_length_value	varchar	4000	√		null
cz_data_profile_stats	min_length	int4	10	√		null
cz_data_profile_stats	min_length_value	varchar	4000	√		null
cz_data_profile_stats	non_null_count	int8	19	√		null
cz_data_profile_stats	null_count	int8	19	√		null
cz_data_profile_stats	percentage_null	float4	8,8	√		null
cz_data_profile_stats	table_name	varchar	500
cz_data_profile_stats	total_count	int8	19	√		null
cz_dw_version	create_date	timestamp	29,6	√		null
cz_dw_version	created_by	int8	19	√		null
cz_dw_version	dw_version_id	int8	19
cz_dw_version	is_current	bpchar	1	√		null
cz_dw_version	release_date	timestamp	29,6	√		null
cz_dw_version	version_name	varchar	200	√		null
cz_job_audit	database_name	varchar	50	√		null
cz_job_audit	job_date	timestamp	29,6	√		null
cz_job_audit	job_id	int8	19
cz_job_audit	procedure_name	varchar	100	√		null
cz_job_audit	records_manipulated	int8	19	√		null
cz_job_audit	seq_id	int8	19
cz_job_audit	step_desc	varchar	1000	√		null
cz_job_audit	step_number	int8	19	√		null
cz_job_audit	step_status	varchar	50	√		null
cz_job_audit	time_elapsed_secs	float8	17,17	√		0
cz_job_error	error_backtrace	varchar	2000	√		null
cz_job_error	error_message	varchar	1000	√		null
cz_job_error	error_number	varchar	300	√		null
cz_job_error	error_stack	varchar	2000	√		null
cz_job_error	job_id	int8	19
cz_job_error	seq_id	int8	19
cz_job_master	active	varchar	1	√		null
cz_job_master	build_id	int8	19	√		null
cz_job_master	database_name	varchar	50	√		null
cz_job_master	end_date	timestamp	29,6	√		null
cz_job_master	job_id	int8	19
cz_job_master	job_name	varchar	500	√		null
cz_job_master	job_status	varchar	50	√		null
cz_job_master	session_id	int8	19	√		null
cz_job_master	start_date	timestamp	29,6	√		null
cz_job_master	time_elapsed_secs	float8	17,17	√		0
cz_job_message	info_message	varchar	2000	√		null
cz_job_message	job_id	int8	19
cz_job_message	message_id	int8	19	√		null
cz_job_message	message_line	int8	19	√		null
cz_job_message	message_procedure	varchar	100	√		null
cz_job_message	seq_id	int8	19
cz_person	cell_phone	varchar	20	√		null
cz_person	email_address	varchar	100	√		null
cz_person	f_name	varchar	200	√		null
cz_person	l_name	varchar	200	√		null
cz_person	m_name	varchar	200	√		null
cz_person	mail_address	varchar	200	√		null
cz_person	person_id	int8	19
cz_person	role_code	varchar	20	√		null
cz_person	user_name	varchar	20	√		null
cz_person	work_phone	varchar	20	√		null
cz_rwg_invalid_terms	category_name	varchar	500	√		null
cz_rwg_invalid_terms	import_date	timestamp	29,6	√		now()
cz_rwg_invalid_terms	study_id	varchar	500	√		null
cz_rwg_invalid_terms	term_name	varchar	500	√		null
cz_test	table_type	varchar	100	√		null
cz_test	test_category_id	int8	19	√		null
cz_test	test_column	varchar	255	√		null
cz_test	test_desc	varchar	1000	√		null
cz_test	test_id	int8	19
cz_test	test_max_value	float8	17,17	√		null
cz_test	test_min_value	float8	17,17	√		null
cz_test	test_name	varchar	200	√		null
cz_test	test_param1	varchar	2000	√		null
cz_test	test_param2	varchar	2000	√		null
cz_test	test_param3	varchar	2000	√		null
cz_test	test_schema	varchar	255	√		null
cz_test	test_severity_cd	varchar	20	√		null
cz_test	test_sql	varchar	2000	√		null
cz_test	test_table	varchar	255	√		null
cz_test	test_type	varchar	255	√		null
cz_test_category	person_id	int8	19	√		null
cz_test_category	test_category	varchar	255	√		null
cz_test_category	test_category_id	int8	19
cz_test_category	test_sub_category1	varchar	255	√		null
cz_test_category	test_sub_category2	varchar	255	√		null
cz_test_result	external_location	varchar	2000	√		null
cz_test_result	run_date	timestamp	29,6	√		null
cz_test_result	study_id	varchar	2000	√		null
cz_test_result	test_id	int8	19
cz_test_result	test_result_id	int8	19
cz_test_result	test_result_nbr	int8	19	√		null
cz_test_result	test_result_text	varchar	2000	√		null
cz_test_result	test_run_id	int8	19	√		null
cz_test_severity	severity_level	int2	5	√		null
cz_test_severity	severity_name	varchar	255	√		null
cz_test_severity	test_severity_cd	varchar	10
cz_xtrial_ctrl_vocab	ctrl_vocab_category	varchar	200	√		null
cz_xtrial_ctrl_vocab	ctrl_vocab_code	varchar	200
cz_xtrial_ctrl_vocab	ctrl_vocab_id	int8	19
cz_xtrial_ctrl_vocab	ctrl_vocab_name	varchar	200
cz_xtrial_exclusion	trial_id	varchar	200	√		null
czv_pivot_sample_categories	access_type	text	2147483647	√		null
czv_pivot_sample_categories	biomarker	text	2147483647	√		null
czv_pivot_sample_categories	gender	text	2147483647	√		null
czv_pivot_sample_categories	institution	text	2147483647	√		null
czv_pivot_sample_categories	organism	text	2147483647	√		null
czv_pivot_sample_categories	pathology	text	2147483647	√		null
czv_pivot_sample_categories	program_initiative	text	2147483647	√		null
czv_pivot_sample_categories	race	text	2147483647	√		null
czv_pivot_sample_categories	sample_id	varchar	200	√		null
czv_pivot_sample_categories	tissue_type	text	2147483647	√		null
czv_pivot_sample_categories	trial_cd	varchar	200	√		null
czv_pivot_sample_categories	trial_name	varchar	2000	√		null
de_gpl_info_release	annotation_date	timestamp	29,6	√		null
de_gpl_info_release	organism	varchar	100	√		null
de_gpl_info_release	platform	varchar	10	√		null
de_gpl_info_release	title	varchar	500	√		null
de_mrna_annotation_release	gene_id	varchar	100	√		null
de_mrna_annotation_release	gene_symbol	varchar	100	√		null
de_mrna_annotation_release	gpl_id	varchar	100	√		null
de_mrna_annotation_release	probe_id	varchar	100	√		null
de_mrna_annotation_release	probeset_id	int8	19	√		null
de_snp_data_by_patient_release	chrom	varchar	16	√		null
de_snp_data_by_patient_release	data_by_patient_chr	text	2147483647	√		null
de_snp_data_by_patient_release	patient_num	int8	19	√		null
de_snp_data_by_patient_release	ped_by_patient_chr	text	2147483647	√		null
de_snp_data_by_patient_release	release_study	varchar	255	√		null
de_snp_data_by_patient_release	snp_data_by_patient_id	int8	19	√		null
de_snp_data_by_patient_release	snp_dataset_id	int8	19	√		null
de_snp_data_by_patient_release	trial_name	varchar	255	√		null
de_snp_data_by_probe_release	data_by_probe	text	2147483647	√		null
de_snp_data_by_probe_release	probe_id	int8	19	√		null
de_snp_data_by_probe_release	probe_name	varchar	255	√		null
de_snp_data_by_probe_release	release_study	varchar	200	√		null
de_snp_data_by_probe_release	snp_data_by_probe_id	int8	19	√		null
de_snp_data_by_probe_release	snp_id	int8	19	√		null
de_snp_data_by_probe_release	snp_name	varchar	255	√		null
de_snp_data_by_probe_release	trial_name	varchar	255	√		null
de_snp_data_ds_loc_release	location	int8	19	√		null
de_snp_data_ds_loc_release	release_study	varchar	200	√		null
de_snp_data_ds_loc_release	snp_data_dataset_loc_id	int8	19	√		null
de_snp_data_ds_loc_release	snp_dataset_id	int8	19	√		null
de_snp_data_ds_loc_release	trial_name	varchar	255	√		null
de_snp_gene_map_release	entrez_gene_id	int8	19	√		null
de_snp_gene_map_release	snp_id	int8	19	√		null
de_snp_gene_map_release	snp_name	varchar	255	√		null
de_snp_info_release	chrom	varchar	16	√		null
de_snp_info_release	chrom_pos	int8	19	√		null
de_snp_info_release	name	varchar	255	√		null
de_snp_info_release	snp_info_id	int8	19	√		null
de_snp_probe_release	probe_name	varchar	255	√		null
de_snp_probe_release	snp_id	int8	19	√		null
de_snp_probe_release	snp_name	varchar	255	√		null
de_snp_probe_release	snp_probe_id	int8	19	√		null
de_snp_probe_release	vendor_name	varchar	255	√		null
de_snp_probe_sort_def_release	chrom	varchar	16	√		null
de_snp_probe_sort_def_release	num_probe	int8	19	√		null
de_snp_probe_sort_def_release	platform_name	varchar	255	√		null
de_snp_probe_sort_def_release	probe_def	text	2147483647	√		null
de_snp_probe_sort_def_release	snp_id_def	text	2147483647	√		null
de_snp_probe_sort_def_release	snp_probe_sorted_def_id	int8	19	√		null
de_subj_protein_data_release	assay_id	int8	19	√		null
de_subj_protein_data_release	component	varchar	15	√		null
de_subj_protein_data_release	gene_id	int4	10	√		null
de_subj_protein_data_release	gene_symbol	varchar	100	√		null
de_subj_protein_data_release	intensity	int8	19	√		null
de_subj_protein_data_release	mean_intensity	int8	19	√		null
de_subj_protein_data_release	median_intensity	int8	19	√		null
de_subj_protein_data_release	n_value	int8	19	√		null
de_subj_protein_data_release	patient_id	int8	19	√		null
de_subj_protein_data_release	release_study	varchar	15	√		null
de_subj_protein_data_release	stddev_intensity	int8	19	√		null
de_subj_protein_data_release	subject_id	varchar	10	√		null
de_subj_protein_data_release	timepoint	varchar	20	√		null
de_subj_protein_data_release	trial_name	varchar	15	√		null
de_subj_protein_data_release	zscore	int8	19	√		null
de_subj_sample_map_release	assay_id	int8	19	√		null
de_subj_sample_map_release	assay_uid	varchar	100	√		null
de_subj_sample_map_release	category_cd	varchar	1000	√		null
de_subj_sample_map_release	concept_code	varchar	1000	√		null
de_subj_sample_map_release	data_uid	varchar	100	√		null
de_subj_sample_map_release	gpl_id	varchar	20	√		null
de_subj_sample_map_release	patient_id	int8	19	√		null
de_subj_sample_map_release	patient_uid	varchar	50	√		null
de_subj_sample_map_release	platform	varchar	50	√		null
de_subj_sample_map_release	platform_cd	varchar	50	√		null
de_subj_sample_map_release	rbm_panel	varchar	50	√		null
de_subj_sample_map_release	release_study	varchar	30	√		null
de_subj_sample_map_release	sample_cd	varchar	200	√		null
de_subj_sample_map_release	sample_id	int8	19	√		null
de_subj_sample_map_release	sample_type	varchar	100	√		null
de_subj_sample_map_release	sample_type_cd	varchar	50	√		null
de_subj_sample_map_release	site_id	varchar	100	√		null
de_subj_sample_map_release	subject_id	varchar	100	√		null
de_subj_sample_map_release	subject_type	varchar	100	√		null
de_subj_sample_map_release	timepoint	varchar	100	√		null
de_subj_sample_map_release	timepoint_cd	varchar	50	√		null
de_subj_sample_map_release	tissue_type	varchar	100	√		null
de_subj_sample_map_release	tissue_type_cd	varchar	50	√		null
de_subj_sample_map_release	trial_name	varchar	30	√		null
de_subject_mrna_data_release	assay_id	int8	19	√		null
de_subject_mrna_data_release	log_intensity	float8	17,17	√		null
de_subject_mrna_data_release	mean_intensity	float8	17,17	√		null
de_subject_mrna_data_release	median_intensity	float8	17,17	√		null
de_subject_mrna_data_release	patient_id	int8	19	√		null
de_subject_mrna_data_release	probeset_id	int8	19	√		null
de_subject_mrna_data_release	pvalue	float8	17,17	√		null
de_subject_mrna_data_release	raw_intensity	int8	19	√		null
de_subject_mrna_data_release	refseq	varchar	50	√		null
de_subject_mrna_data_release	release_study	varchar	50	√		null
de_subject_mrna_data_release	sample_id	int8	19	√		null
de_subject_mrna_data_release	stddev_intensity	float8	17,17	√		null
de_subject_mrna_data_release	subject_id	varchar	50	√		null
de_subject_mrna_data_release	timepoint	varchar	100	√		null
de_subject_mrna_data_release	trial_name	varchar	50	√		null
de_subject_mrna_data_release	zscore	float8	17,17	√		null
de_subject_rbm_data_release	antigen_name	varchar	100	√		null
de_subject_rbm_data_release	assay_id	int8	19	√		null
de_subject_rbm_data_release	concept_cd	varchar	100	√		null
de_subject_rbm_data_release	data_uid	varchar	100	√		null
de_subject_rbm_data_release	gene_id	int4	10	√		null
de_subject_rbm_data_release	gene_symbol	varchar	100	√		null
de_subject_rbm_data_release	log_intensity	int8	19	√		null
de_subject_rbm_data_release	mean_intensity	int8	19	√		null
de_subject_rbm_data_release	median_intensity	int8	19	√		null
de_subject_rbm_data_release	n_value	int8	19	√		null
de_subject_rbm_data_release	normalized_value	float8	17,17	√		null
de_subject_rbm_data_release	patient_id	int8	19	√		null
de_subject_rbm_data_release	rbm_panel	varchar	50	√		null
de_subject_rbm_data_release	release_study	varchar	15	√		null
de_subject_rbm_data_release	stddev_intensity	int8	19	√		null
de_subject_rbm_data_release	timepoint	varchar	100	√		null
de_subject_rbm_data_release	trial_name	varchar	15	√		null
de_subject_rbm_data_release	value	int8	19	√		null
de_subject_rbm_data_release	zscore	int8	19	√		null
dk1	c1	varchar	10	√		null
gplid	gpl_id	varchar	50	√		null
haploview_data_release	affection_status	int2	5	√		null
haploview_data_release	chromosome	varchar	10	√		null
haploview_data_release	father_id	int4	10	√		null
haploview_data_release	gene	varchar	50	√		null
haploview_data_release	i2b2_id	int8	19	√		null
haploview_data_release	jnj_id	varchar	30	√		null
haploview_data_release	mother_id	int4	10	√		null
haploview_data_release	release	int2	5	√		null
haploview_data_release	release_date	timestamp	29,6	√		null
haploview_data_release	release_study	varchar	30	√		null
haploview_data_release	sex	int2	5	√		null
haploview_data_release	snp_data	text	2147483647	√		null
haploview_data_release	trial_name	varchar	50	√		null
i2b2_release	c_basecode	varchar	450	√		null
i2b2_release	c_columndatatype	varchar	50	√		null
i2b2_release	c_columnname	varchar	50	√		null
i2b2_release	c_comment	text	2147483647	√		null
i2b2_release	c_dimcode	varchar	900	√		null
i2b2_release	c_facttablecolumn	varchar	50	√		null
i2b2_release	c_fullname	varchar	900
i2b2_release	c_hlevel	int8	19	√		null
i2b2_release	c_metadataxml	text	2147483647	√		null
i2b2_release	c_name	varchar	2000	√		null
i2b2_release	c_operator	varchar	10	√		null
i2b2_release	c_synonym_cd	bpchar	1	√		null
i2b2_release	c_tablename	varchar	50	√		null
i2b2_release	c_tooltip	varchar	900	√		null
i2b2_release	c_totalnum	int8	19	√		null
i2b2_release	c_visualattributes	bpchar	3	√		null
i2b2_release	download_date	timestamp	29,6	√		null
i2b2_release	i2b2_id	int8	19	√		null
i2b2_release	import_date	timestamp	29,6	√		null
i2b2_release	release_study	varchar	50	√		null
i2b2_release	sourcesystem_cd	varchar	50	√		null
i2b2_release	update_date	timestamp	29,6	√		null
i2b2_release	valuetype_cd	varchar	50	√		null
i2b2_tags_release	path	varchar	200	√		null
i2b2_tags_release	release_study	varchar	200	√		null
i2b2_tags_release	tag	varchar	200	√		null
i2b2_tags_release	tag_id	int8	19
i2b2_tags_release	tag_type	varchar	200	√		null
last_test_detail_view	act_record_cnt	float8	17,17	√		null
last_test_detail_view	category	varchar	255	√		null
last_test_detail_view	end_date	text	2147483647	√		null
last_test_detail_view	error_code	varchar	30	√		null
last_test_detail_view	error_message	varchar	4000	√		null
last_test_detail_view	max_value_allowed	float8	17,17	√		null
last_test_detail_view	min_value_allowed	float8	17,17	√		null
last_test_detail_view	run_id	int8	19	√		null
last_test_detail_view	run_name	varchar	200	√		null
last_test_detail_view	start_date	text	2147483647	√		null
last_test_detail_view	status	varchar	20	√		null
last_test_detail_view	sub_category1	varchar	255	√		null
last_test_detail_view	sub_category2	varchar	255	√		null
last_test_detail_view	test_id	int8	19	√		null
last_test_detail_view	test_severity_cd	varchar	20	√		null
last_test_detail_view	vcolumn	varchar	255	√		null
last_test_detail_view	vsql	varchar	2000	√		null
last_test_detail_view	vtable	varchar	255	√		null
last_test_summary_view	db_version	varchar	200	√		null
last_test_summary_view	end_date	text	2147483647	√		null
last_test_summary_view	error	int8	19	√		null
last_test_summary_view	fail	int8	19	√		null
last_test_summary_view	pass	int8	19	√		null
last_test_summary_view	start_date	text	2147483647	√		null
last_test_summary_view	status	varchar	20	√		null
last_test_summary_view	test_category	varchar	255	√		null
last_test_summary_view	test_run_id	int8	19	√		null
last_test_summary_view	test_run_name	varchar	200	√		null
last_test_summary_view	test_sub_category1	varchar	255	√		null
last_test_summary_view	test_sub_category2	varchar	255	√		null
last_test_summary_view	total	int8	19	√		null
last_test_summary_view	warning	int8	19	√		null
migrate_tables	data_type	varchar	50	√		null
migrate_tables	delete_seq	int4	10	√		null
migrate_tables	insert_seq	int4	10	√		null
migrate_tables	rebuild_index	bpchar	1	√		null
migrate_tables	stage_table_name	varchar	100	√		null
migrate_tables	study_specific	bpchar	1	√		null
migrate_tables	table_name	varchar	50	√		null
migrate_tables	table_owner	varchar	50	√		null
migrate_tables	where_clause	varchar	2000	√		null
mirna_annotation_deapp	gpl_id	varchar	20	√		null
mirna_annotation_deapp	id_ref	varchar	100	√		null
mirna_annotation_deapp	mirna_id	varchar	100	√		null
mirna_annotation_deapp	mirna_symbol	varchar	100	√		null
mirna_annotation_deapp	organism	varchar	200	√		null
mirna_annotation_deapp	probe_id	varchar	100	√		null
mirna_annotation_deapp	probeset_id	numeric	38	√		null
mirna_probeset_deapp	organism	varchar	200	√		null
mirna_probeset_deapp	platform	varchar	100	√		null
mirna_probeset_deapp	probeset	varchar	100	√		null
mirna_probeset_deapp	probeset_id	numeric	38		√	nextval('tm_cz.seq_probeset_id'::regclass)
node_curation	active_flag	bpchar	1	√		null
node_curation	curation_date	timestamp	29,6	√		null
node_curation	curator_name	varchar	250	√		null
node_curation	data_type	bpchar	1	√		null
node_curation	display_in_ui	bpchar	1	√		null
node_curation	display_name	varchar	250	√		null
node_curation	global_flag	bpchar	1	√		null
node_curation	node_name	varchar	250	√		null
node_curation	node_type	varchar	25	√		null
node_curation	study_id	varchar	30	√		null
observation_fact_release	concept_cd	varchar	50
observation_fact_release	confidence_num	int8	19	√		null
observation_fact_release	download_date	timestamp	29,6	√		null
observation_fact_release	encounter_num	int8	19	√		null
observation_fact_release	end_date	timestamp	29,6	√		null
observation_fact_release	import_date	timestamp	29,6	√		null
observation_fact_release	location_cd	varchar	50
observation_fact_release	modifier_cd	varchar	100	√		null
observation_fact_release	nval_num	float8	17,17	√		null
observation_fact_release	observation_blob	text	2147483647	√		null
observation_fact_release	patient_num	int8	19	√		null
observation_fact_release	provider_id	varchar	50
observation_fact_release	quantity_num	float8	17,17	√		null
observation_fact_release	release_study	varchar	100	√		null
observation_fact_release	sourcesystem_cd	varchar	50	√		null
observation_fact_release	start_date	timestamp	29,6	√		null
observation_fact_release	tval_char	varchar	255	√		null
observation_fact_release	units_cd	varchar	50	√		null
observation_fact_release	update_date	timestamp	29,6	√		null
observation_fact_release	upload_id	int8	19	√		null
observation_fact_release	valtype_cd	varchar	50	√		null
observation_fact_release	valueflag_cd	varchar	50	√		null
patient_dimension_release	age_in_years_num	int8	19	√		null
patient_dimension_release	birth_date	timestamp	29,6	√		null
patient_dimension_release	death_date	timestamp	29,6	√		null
patient_dimension_release	download_date	timestamp	29,6	√		null
patient_dimension_release	import_date	timestamp	29,6	√		null
patient_dimension_release	language_cd	varchar	50	√		null
patient_dimension_release	marital_status_cd	varchar	50	√		null
patient_dimension_release	patient_blob	text	2147483647	√		null
patient_dimension_release	patient_num	int8	19	√		null
patient_dimension_release	race_cd	varchar	50	√		null
patient_dimension_release	release_study	varchar	50	√		null
patient_dimension_release	religion_cd	varchar	50	√		null
patient_dimension_release	sex_cd	varchar	50	√		null
patient_dimension_release	sourcesystem_cd	varchar	50	√		null
patient_dimension_release	statecityzip_path	varchar	700	√		null
patient_dimension_release	update_date	timestamp	29,6	√		null
patient_dimension_release	upload_id	int8	19	√		null
patient_dimension_release	vital_status_cd	varchar	50	√		null
patient_dimension_release	zip_cd	varchar	50	√		null
probeset_deapp	organism	varchar	200	√		null
probeset_deapp	platform	varchar	100
probeset_deapp	probeset	varchar	100
probeset_deapp	probeset_id	int8	19
probeset_deapp_20120206	platform	varchar	100
probeset_deapp_20120206	probeset	varchar	100
probeset_deapp_20120206	probeset_id	int8	19
sample_categories_release	category_cd	varchar	200	√		null
sample_categories_release	category_value	varchar	200	√		null
sample_categories_release	release_study	varchar	50	√		null
sample_categories_release	sample_cd	varchar	200	√		null
sample_categories_release	site_cd	varchar	200	√		null
sample_categories_release	subject_cd	varchar	200	√		null
sample_categories_release	trial_cd	varchar	200	√		null
search_secure_object_release	bio_data_id	int8	19	√		null
search_secure_object_release	bio_data_unique_id	varchar	200	√		null
search_secure_object_release	data_type	varchar	200	√		null
search_secure_object_release	display_name	varchar	100	√		null
search_secure_object_release	release_study	varchar	100	√		null
search_secure_object_release	search_secure_object_id	int8	19	√		null
tmp_num_data_types	category_cd	varchar	200	√		null
tmp_num_data_types	data_label	varchar	500	√		null
tmp_num_data_types	period	varchar	100	√		null
tmp_num_data_types	sample_type	varchar	100	√		null
tmp_num_data_types	visit_name	varchar	100	√		null
tmp_subject_info	age_in_years_num	int2	5	√		null
tmp_subject_info	race_cd	varchar	50	√		null
tmp_subject_info	sex_cd	varchar	50	√		null
tmp_subject_info	usubjid	varchar	100	√		null
tmp_trial_data	base_path	varchar	1250	√		null
tmp_trial_data	category_path	varchar	250	√		null
tmp_trial_data	data_label	varchar	500	√		null
tmp_trial_data	data_type	bpchar	1	√		null
tmp_trial_data	data_value	varchar	500	√		null
tmp_trial_data	patient_num	int8	19	√		null
tmp_trial_data	sourcesystem_cd	varchar	50	√		null
tmp_trial_data	study_id	varchar	25	√		null
tmp_trial_data	sub_category_path_1	varchar	250	√		null
tmp_trial_data	sub_category_path_2	varchar	250	√		null
tmp_trial_data	unit_cd	varchar	50	√		null
tmp_trial_data	usubjid	varchar	50	√		null
tmp_trial_data	visit_name	varchar	100	√		null
tmp_trial_nodes	category_cd	varchar	200	√		null
tmp_trial_nodes	data_label	varchar	500	√		null
tmp_trial_nodes	data_value	varchar	500	√		null
tmp_trial_nodes	leaf_node	varchar	4000	√		null
tmp_trial_nodes	node_name	varchar	500	√		null
tmp_trial_nodes	period	varchar	100	√		null
tmp_trial_nodes	sample_type	varchar	100	√		null
tmp_trial_nodes	visit_name	varchar	100	√		null