Table zfindb.public.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 text 2147483647
probe_library.probelib_species probelib_species_foreign_key R
organism_common_name text 2147483647
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 int4 10
organism_is_ab_immun bool 1  √  false
organism_is_ab_host bool 1  √  false
organism_taxid int4 10
ncbi_ortholog.noi_taxid noi_taxid_foreign_key R

Table contained 43 rows at Wed Sep 15 00:41 PDT 2021

Indexes:
Column(s) Type Sort Constraint Name
organism_species Primary key Asc organism_primary_key
organism_common_name Must be unique Asc organism_common_name_index
organism_display_order Must be unique Asc organism_display_order_index
organism_taxid Must be unique Asc organism_taxid_index

Close relationships  within of separation: