Entity site_references

This entity compiles a unique list of the references cited in the dataset and matches each to their site(s)

• check Bruno’s work on the reference list to see which, if any references from this dataset are already in SEAD, and if they are, figure out how best enter their biblio_id here.

YAML as of 2026-09-24

name: site_references
type: entity
system_id: system_id
keys:
  - site_key
  - full_reference
columns:
  - site_key
  - full_reference
public_id: site_reference_id
source: supersite
foreign_keys:
  - entity: site
    local_keys:
      - site_key
    remote_keys:
      - site_key
    how: inner
    constraints:
      cardinality: one_to_one
      allow_unmatched_right: true
      require_unique_left: false
      require_unique_right: false
      allow_row_decrease: true
  - entity: citation
    local_keys:
      - full_reference
    remote_keys:
      - full_reference
    how: inner
    constraints:
      cardinality: one_to_one
      allow_unmatched_right: true
      require_unique_left: false
      require_unique_right: false
      allow_row_decrease: true
drop_duplicates: true
check_functional_dependency: false
drop_empty_rows: true
```