Entity geochronology

These are columns of this dataset having to do with geochronology. They are linked to SEAD's column names by setting the Extra Columns to:

• lab_id = Structure of SEAD/Columns/lab_number
• c14_age_bp = age
• c14_error = error_older and error_younger
• d13C = delta_13c
• comment = notes

• decide what do with c14_data_status, which contains only three different values; ok, c14_data_saknas, and orealistiskt_c14_värde (the last one has only one example in the data set). Should it be merged with comment to make a composite note? (e.g.: “c14_data_status ok, Anltyp grop i slutundersökning. Daterar inte anläggningen utan senare inblandning” or “c14_data_saknas, Ej med i avhandlingen” or “orealistiskt_c14_värde, Faller helt utanför ramen”)
  

YAML as of 2026-09-18

name: geochronology
type: entity
system_id: system_id
keys:
  - lab_id
  - unique_row_identifier
columns:
  - c14_age_bp
  - d13c
  - c14_error
  - comment
  - unique_row_identifier
  - lab_id
  - lab_prefix_raw
public_id: geochron_id
source: supergeochron
foreign_keys:
  - entity: dating_lab
    local_keys:
      - lab_prefix_raw
    remote_keys:
      - extracted_lab_prefix
    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: false
  - entity: analysis_entity
    local_keys:
      - unique_row_identifier
    remote_keys:
      - unique_row_identifier
    how: inner
    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
drop_duplicates: true
check_functional_dependency: false
extra_columns:
  lab_number: '{lab_id}'
  age: '{c14_age_bp}'
  error_older: '{c14_error}'
  error_younger: '{c14_error}'
  delta_13c: '{d13c}'
  notes: '{comment}'
```