[INSTRM-1731] create sequence_group table in opdb Created: 04/Oct/22  Updated: 08/Feb/23  Resolved: 02/Nov/22

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

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

Issue Links:
Blocks
blocks INSTRM-1732 display groups in obslog Done
Story Points: 1
Sprint: 2DDRP-2023 A

 Description   

After some though and discussions with cloomis and since we haven't used that mechanism yet, we decided to update the current schema and create an external sequence_group table with

  • group_id (int)
  • group_name(str)
  • created_at(timestamp)

Another advantage is that we can back populate groups from the latest engineering run.

 Comments   
Comment by arnaud.lefur [ 02/Nov/22 ]

Kiyoto Yabe michitaro
I've merged an upgraded the summit opdb.

Generated at Sat Feb 10 16:38:48 JST 2024 using Jira 8.3.4#803005-sha1:1f96e09b3c60279a408a2ae47be3c745f571388b.