Table transmart.biomart.bio_analysis_cohort_xref Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
study_id varchar 255  √  null
cohort_id varchar 255  √  null
analysis_cd varchar 255  √  null
bio_assay_analysis_id int8 19
assay_analysis_data.bio_assay_analysis_id Implied Constraint R
bio_analysis_attribute.bio_assay_analysis_id Implied Constraint R
bio_assay_analysis.bio_assay_analysis_id Implied Constraint R
bio_assay_analysis_eqtl.bio_assay_analysis_id Implied Constraint R
bio_asy_analysis_eqtl_top50.bio_assay_analysis_id Implied Constraint R
bio_marker_exp_analysis_mv.bio_assay_analysis_id Implied Constraint R
bio_marker_exp_analysis_mv_10.bio_assay_analysis_id Implied Constraint R
cta_results.bio_assay_analysis_id Implied Constraint R
gse_analysis.bio_assay_analysis_id Implied Constraint R
heat_map_results.bio_assay_analysis_id Implied Constraint R
vw_faceted_search_disease.bio_assay_analysis_id Implied Constraint R

Table contained 0 rows at Wed Jun 26 00:10 CEST 2019

Indexes:
Column(s) Type Sort Constraint Name
bio_assay_analysis_id Primary key Asc bio_analysis_cohort_xref_pk
bio_assay_analysis_id Performance Asc bacx_idx1

Close relationships: