Table transmart.biomart.bio_assay_analysis_gwas 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_asy_analysis_gwas_id int8 19
bio_asy_analysis_data_ext.bio_asy_analysis_data_id bio_asy_analysis_data_ext_fk R
bio_assay_analysis_id int8 19  √  null
bio_assay_analysis.bio_assay_analysis_id fk_gwas_bio_aa R
rs_id varchar 50  √  null
p_value_char varchar 100  √  null
p_value float8 17,17  √  null
log_p_value float8 17,17  √  null
etl_id int8 19  √  null
ext_data varchar 4000  √  null
effect_allele varchar 30  √  null
other_allele varchar 30  √  null
pass_fail varchar 1  √  null
probe_name varchar 100  √  null
bio_asy_geno_platform_probe_id int8 19  √  null
beta float8 17,17  √  null
standard_error float8 17,17  √  null
geno_platform_probe_id numeric 22  √  null
bio_assay_geno_platform_probe.bio_asy_geno_platform_probe_id fk_gwas_geno_platform_probe R
beta_old numeric 131089  √  null
standard_error_old numeric 131089  √  null
effect_allele_clob text 2147483647  √  null
other_allele_clob text 2147483647  √  null
created_by varchar 30  √  null
created_date date 13  √  null
modified_by varchar 30  √  null
modified_date date 13  √  null

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

Indexes:
Column(s) Type Sort Constraint Name Anomalies
bio_asy_analysis_gwas_id Primary key Asc bio_asy_analysis_gwas_id  
rs_id Performance Asc idx2_bio_assay_analysis_gwas  
bio_assay_analysis_id + rs_id Must be unique Asc/Asc idx3_bio_assay_analysis_gwas These unique columns are also nullable
geno_platform_probe_id Performance Asc idx_gwas_geno_pltfm_probe_id  

Close relationships  within of separation: