Table zfindb.informix.organism 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
organism_species varchar 60
probe_library.probelib_species probelib_species_foreign_key R
organism_common_name varchar 30
antibody.atb_host_organism atb_host_organism_foreign_key R
antibody.atb_immun_organism atb_immun_organism_foreign_key R
foreign_db_contains.fdbcont_organism_common_name foreign_db_contains_organism_foreign_key R
organism_display_order int 10
organism_is_ab_immun boolean 1  √  f
organism_is_ab_host boolean 1  √  f
organism_taxid int 10
ncbi_ortholog.noi_taxid noi_taxid_foreign_key R

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

Indexes:
Column(s) Type Sort Constraint Name
organism_is_ab_host + organism_is_ab_immun + organism_common_name Must be unique Asc/Asc/Asc organism_common_name_index
organism_is_ab_host + organism_is_ab_immun + organism_display_order Must be unique Asc/Asc/Asc organism_display_order_index
organism_is_ab_host + organism_is_ab_immun + organism_species Must be unique Asc/Asc/Asc organism_primary_key_index
organism_is_ab_host + organism_is_ab_immun + organism_taxid Must be unique Asc/Asc/Asc organism_taxid_index

Close relationships  within of separation: