To include a taxon name at a rank with no explicit column, create a parent taxonlabel for it and point to it using parent_id. To include multiple such names, chain the taxonlabels together using parent_id. Note that lower-level taxa should point to higher-level taxa.

COMMENT ON COLUMN taxonlabel.parent_id IS 'The parent taxonlabel. Note that while a taxon *name* may have multiple parents, a taxon *label* has only one, based on the creator''s opinion of where that taxonlabel goes in the taxonomic hierarchy.';

COMMENT ON COLUMN taxonlabel.taxonepithet IS 'The epithet of the taxon within its parent taxon. This is the lowest-rank portion of this taxonlabel''s full taxonomic name, if it has one.

The morphospecies suffix goes in this field.';

COMMENT ON COLUMN taxonlabel.rank IS 'The taxonlabel''s level in the taxonomic hierarchy, standardized to a closed list. Even if you specify a custom verbatimrank, you should also specify a closest-match rank from the taxonrank closed list.';

COMMENT ON COLUMN taxonlabel.taxonomicname IS 'The taxonomic name that uniquely identifies this taxonlabel. If set, the other fields will not be used in duplicate elimination.';

COMMENT ON COLUMN taxonverbatim.verbatimrank IS 'The taxonlabel''s verbatim level in the taxonomic hierarchy. Does not need to be in the taxonrank closed list.';

COMMENT ON COLUMN taxonverbatim.family IS 'The family of the taxonomic name. This is a cached field for easy querying; the identifying version of this field is stored in the chain of parent_id ancestors.';

COMMENT ON COLUMN taxonverbatim.genus IS 'The genus portion of the taxonomic name. This is a cached field for easy querying; the identifying version of this field is stored in the chain of parent_id ancestors.';

COMMENT ON COLUMN taxonverbatim.species IS 'The species portion of the taxonomic name. This is a cached field for easy querying; the identifying version of this field is stored in the chain of parent_id ancestors.';