search

humlab-sead / sead_change_control

Sane SEAD change control using Sqitch.
1 stars 0 forks source link

20240104_DDL_DATE_SUBMITTED_TYPE #228

Closed roger-mahler closed 10 months ago

roger-mahler commented 10 months ago

Change project: sead_model Change request: 20240104_DDL_DATE_SUBMITTED_TYPE

Changed type of tbl_dataset_submissions.date_submitted from timestamptz(6)to text null.

For some dates in the 2023-12 dendrochronolgy data submission, only the year (e.g., 2003) or year-month (e.g., 2003-05) is available. Then there are cases where they know the sampler but not the date. In such a case, one must either exclude these or allow for such variation.

roger-mahler commented 10 months ago

This type change has also been added to (#220).