Table transmart.biomart.bio_asy_analysis_gwas_top50 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_assay_analysis_id int8 19  √  null
bio_assay_analysis.bio_assay_analysis_id fk_gwas_top50_asy_anal R
analysis varchar 500  √  null
chrom varchar 4  √  null
pos numeric 10  √  null
rsgene varchar 200  √  null
rsid varchar 50  √  null
pvalue float8 17,17  √  null
logpvalue float8 17,17  √  null
extdata varchar 4000  √  null
rnum int8 19  √  null
intronexon varchar 10  √  null
regulome varchar 10  √  null
recombinationrate numeric 18,6  √  null
beta float8 17,17  √  null
standard_error float8 17,17  √  null
effect_allele varchar 30  √  null
other_allele varchar 30  √  null
strand varchar 1  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
bio_assay_analysis_id Performance Asc idx1_bio_asy_gwas_t50
analysis Performance Asc idx2_bio_asy_gwas_top50

Close relationships  within of separation: