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