Table zfindb.informix.zygocity Generated by
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
zyg_zdb_id varchar 50
genotype_feature.genofeat_dad_zygocity genofeat_dad_zygocity_foreign_key R
genotype_feature.genofeat_mom_zygocity genofeat_mom_zygocity_foreign_key R
genotype_feature.genofeat_zygocity genofeat_zygocity_foreign_key R
zdb_active_data.zactvd_zdb_id zygocity_zdb_active_data_foreign_key R
zyg_name varchar 60
zyg_abbrev varchar 10  √  null
zyg_definition varchar 255
zyg_allele_display varchar 10  √  null
zyg_gene_prefix varchar 10  √  null

Table contained 5 rows at Thu Jun 22 08:42 PDT 2017

Column(s) Type Sort Constraint Name
zyg_name Must be unique Asc zygocity_alternate_key_index
zyg_zdb_id Must be unique Asc zygocity_primary_key_index

Close relationships  within of separation: