tells SEAD which site each sample group comes from

YAML as of 2026-09-21

name: sample_group
type: entity
system_id: system_id
keys: []
columns:
  - context_id
  - context_type
  - site_key
  - sample_group_key
public_id: sample_group_id
source: supersite
foreign_keys:
  - entity: site
    local_keys:
      - site_key
    remote_keys:
      - site_key
    how: inner
    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
drop_duplicates: true
check_functional_dependency: false
```