Entity species

This entity takes the species_split output column from the Entity superabundance and links it to both the Entity species_resolution and Entity taxa_tree_master

YAML as of 2026-09-24

name: species
type: entity
system_id: system_id
keys: []
columns:
  - species_split
public_id: taxon_id
source: superabundance
foreign_keys:
  - entity: species_resolution
    local_keys:
      - species_split
    remote_keys:
      - species_split
    how: left
    constraints:
      cardinality: one_to_one
      allow_unmatched_right: true
      require_unique_left: false
      require_unique_right: false
      allow_row_decrease: true
      allow_unmatched_left: true
  - entity: taxa_tree_master
    local_keys:
      - species_split
    remote_keys:
      - species_split
    how: left
    constraints:
      cardinality: many_to_one
      allow_unmatched_right: true
      require_unique_left: false
      require_unique_right: false
      allow_row_decrease: true
      allow_unmatched_left: true
      allow_null_keys: true
drop_duplicates: true
check_functional_dependency: false
drop_empty_rows:
  - species_split