search

humlab-sead / sead_bugs_import

SEAD bugs import
2 stars 0 forks source link

Replaced column in target table (TDatesCalendar -> tbl_relative_dates) #55

Open roger-mahler opened 1 year ago

roger-mahler commented 1 year ago

Column physical_sample_id in tbl_relative_dates has been replaced by analysis_entity_id'. This affects import ofTDatesCalendar`.

Source Target Column Lookup
SampleCODE (new) tbl_relative_dates analysis_entity_id ???
SampleCODE (delete) tbl_relative_dates physical_sample_id bugs_import.bugs_trace.bugsdata
Uncertainty tbl_relative_dates dating_uncertainty_id tbl_dating_uncertainty.uncertainty
Date + BCADBP tbl_relative_dates relative_age_id concatenate 'CAL_' + Date + BCADBP
=> lookup tbl_relative_ages."Abbreviation"
DatingMethod tbl_relative_dates method_id lookup tbl_methods.method_abbrev_or_alt_name
Notes tbl_relative_dates notes

https://github.com/humlab-sead/sead_bugs_import/blob/4abddea28810bd361c84463b2a781b2a828ac5a8/doc/mindmap.md#L192