Table transmart.biomart.bio_asy_platform_probe_anno 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_platform_probe_anno_id numeric 22
bio_asy_geno_platform_probe_id numeric 22
bio_assay_geno_platform_probe.bio_asy_geno_platform_probe_id fk_bio_asy_ppa_gp_probe R
genotype_probe_annotation_id numeric 22
genotype_probe_annotation.genotype_probe_annotation_id fk_bio_asy_ppa_probe_anno R
bio_assay_platform_id int8 19
bio_assay_platform.bio_assay_platform_id fk_bio_asy_ppa_platform R
genome_build varchar 10  √  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
genotype_probe_annotation_id Performance Asc idx_bio_asy_ppanno_anno
bio_assay_platform_id Performance Asc idx_bio_asy_ppanno_platform
bio_asy_geno_platform_probe_id Performance Asc idx_bio_asy_ppanno_probe
bio_asy_platform_probe_anno_id Must be unique Asc pk_bio_asy_platform_probe_anno

Close relationships  within of separation: