Table zfindb.informix.genotype_feature 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
genofeat_zdb_id varchar 50
zdb_active_data.zactvd_zdb_id genofeat_zdb_active_data_foreign_key R
genofeat_geno_zdb_id varchar 50
genotype.geno_zdb_id genofeat_geno_foreign_key_odc C
genofeat_feature_zdb_id varchar 50
feature.feature_zdb_id genofeat_feature_foreign_key_odc C
genofeat_dad_zygocity varchar 50  √  null
zygocity.zyg_zdb_id genofeat_dad_zygocity_foreign_key R
genofeat_mom_zygocity varchar 50  √  null
zygocity.zyg_zdb_id genofeat_mom_zygocity_foreign_key R
genofeat_zygocity varchar 50
zygocity.zyg_zdb_id genofeat_zygocity_foreign_key R

Table contained 26,618 rows at Tue Dec 20 09:53 PST 2016

Indexes:
Column(s) Type Sort Constraint Name
genofeat_dad_zygocity Performance Asc genofeat_dad_zygocity_index
genofeat_feature_zdb_id Performance Asc genofeat_feature_zdb_id_foreign_key_index
genofeat_geno_zdb_id Performance Asc genofeat_geno_foreign_key_index
genofeat_mom_zygocity Performance Asc genofeat_mom_zygocity_index
genofeat_zygocity Performance Asc genofeat_zygocity_index
genofeat_geno_zdb_id + genofeat_feature_zdb_id + genofeat_zygocity + genofeat_mom_zygocity + genofeat_dad_zygocity Must be unique Asc/Asc/Asc/Asc/Asc genotype_feature_alternate_key_index
genofeat_zdb_id Must be unique Asc genotype_feature_primary_key_index

Close relationships  within of separation: