Table zfindb.public.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 text 2147483647
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 text 2147483647
zyg_abbrev text 2147483647  √  null
zyg_definition text 2147483647
zyg_allele_display text 2147483647  √  null
zyg_gene_prefix text 2147483647  √  null
zyg_geno_ont_id text 2147483647  √  null

Table contained 5 rows at Tue Sep 15 16:40 PDT 2020

Column(s) Type Sort Constraint Name
zyg_zdb_id Primary key Asc zygocity_primary_key
zyg_name Must be unique Asc zygocity_alternate_key_index

Close relationships  within of separation: