phylonode_organism

0 rows


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 Nulls Auto Default Children Parents Comments
phylonode_organism_id serial 10 √ nextval('phylonode_organism_phylonode_organism_id_seq'::regclass)
phylonode_id int4 10 null
phylonode.phylonode_id phylonode_organism_phylonode_id_fkey C

One phylonode cannot refer to >1 organism.
organism_id int4 10 null
organism.organism_id phylonode_organism_organism_id_fkey C

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

Close relationships within degrees of separation