Table transmart.biomart.bio_assay_geno_platform_probe 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_geno_platform_probe_id numeric 18
bio_assay_analysis_gwas.geno_platform_probe_id fk_gwas_geno_platform_probe R
bio_asy_platform_probe_anno.bio_asy_geno_platform_probe_id fk_bio_asy_ppa_gp_probe R
bio_assay_platform_id int8 19
bio_assay_platform.bio_assay_platform_id fk_bio_asy_gp_probe_asy_plf R
orig_chrom varchar 5  √  null
orig_position numeric 131089  √  null
orig_genome_build varchar 20  √  null
probe_name varchar 200  √  null
is_control bool 1  √  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
bio_asy_geno_platform_probe_id Primary key Asc pk_bio_asy_gp_probe
bio_asy_geno_platform_probe_id Must be unique Asc idx_bio_assay_gp_probe_pk
bio_assay_platform_id Performance Asc idx_bio_asy_gpp_platform
probe_name Performance Asc idx_bio_asy_gpp_probe_name

Close relationships  within of separation: