[INSTRM-1207] add annotation_id and timestamp to sps_annotation table Created: 13/Mar/21  Updated: 18/Mar/21  Resolved: 18/Mar/21

Status: Done
Project: Instrument control development
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Task Priority: Normal
Reporter: arnaud.lefur Assignee: Kiyoto Yabe
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Blocks
blocks INSTRM-1202 Add command to create sps_annotations Done

 Description   

sps_annotation table does exist but isn't currently very useful.
We would like the ability to add more than one annotation per file, having the date as well.
So basically two new columns:

  • annotation_id as primary key (int4 not null)
  • created_at (timestamp)

Thanks.
Generated at Sat Feb 10 16:32:59 JST 2024 using Jira 8.3.4#803005-sha1:1f96e09b3c60279a408a2ae47be3c745f571388b.