Table transmart.biomart.bio_marker 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
bio_marker_id int8 19
bio_assay_data_annotation.bio_marker_id Implied Constraint R
bio_data_omic_marker.bio_marker_id Implied Constraint R
bio_marker_correl_mv.bio_marker_id Implied Constraint R
bio_marker_correl_view.bio_marker_id Implied Constraint R
bio_marker_exp_analysis_mv.bio_marker_id Implied Constraint R
bio_marker_exp_analysis_mv_10.bio_marker_id Implied Constraint R
bio_stats_exp_marker.bio_marker_id Implied Constraint R
cta_results.bio_marker_id Implied Constraint R
genego_gene_map.bio_marker_id Implied Constraint R
heat_map_results.bio_marker_id Implied Constraint R
mirna_bio_marker.bio_marker_id Implied Constraint R
bio_marker_name varchar 200  √  null
bio_marker_description varchar 1000  √  null
organism varchar 200  √  null
primary_source_code varchar 200  √  null
primary_external_id varchar 200  √  null
bio_marker_type varchar 200

Table contained 108,037 rows at Wed Jun 26 00:10 CEST 2019

Indexes:
Column(s) Type Sort Constraint Name Anomalies
bio_marker_id Primary key Asc biomarker_pk  
bio_marker_id Must be unique Asc bio_marker_pk  
primary_external_id Performance Asc bio_mkr_ext_id  
primary_source_code + primary_external_id Performance Asc/Asc bio_mkr_src_ext_id_idx  
bio_marker_type Performance Asc bio_mkr_type_idx  
organism + primary_external_id Must be unique Asc/Asc biomarker_uk These unique columns are also nullable

Close relationships: