Schema Version: 1.3

phylonode_organism


Description

This linking table should only be used for nodes in taxonomy trees; it provides a mapping between the node and an organism. One node can have zero or one organisms, one organism can have zero or more nodes (although typically it should only have one in the standard NCBI taxonomy tree).

Columns

Column Type Size Foreign Key Nullable Default Comments
phylonode_organism_id bigserial 19
nextval('chado.phylonode_organism_phylonode_organism_id_seq'::regclass)
phylonode_id int8 19
phylonode.phylonode_id phylonode_organism_phylonode_id_fkey C
null

One phylonode cannot refer to >1 organism.
organism_id int8 19
organism.organism_id phylonode_organism_organism_id_fkey C
null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
phylonode_organism_pkey Primary key Asc phylonode_organism_id
phylonode_organism_idx1 Performance Asc phylonode_id
phylonode_organism_idx2 Performance Asc organism_id
phylonode_organism_phylonode_id_key Must be unique Asc phylonode_id

Relationships

The following entity relationship (ER) diagram shows the relationships involving the phylonode_organism table.

Show relationships within degrees of separation