[INSTRM-1275] Fix `cobra_match` so that `spot_id` can be `NULL` Created: 13/May/21 Updated: 25/May/21 Resolved: 25/May/21 |
|
| Status: | Done |
| Project: | Instrument control development |
| Component/s: | spt_operational_database |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Task | Priority: | Normal |
| Reporter: | Kiyoto Yabe | Assignee: | Kiyoto Yabe |
| Resolution: | Done | Votes: | 0 |
| Labels: | opDB | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Description |
|
The primary key of `cobra_match` table is currently (`mcs_frame_id`, `spot_id`). This causes a trouble when tracking and flagging if targets are behind dots or non-detection for some reasons, where they have no `spot_id`. The proposed fix is to change the primary key to (`pfs_visit_id`, `iteration`, `cobra_id`), which is the same as `cobra_target`. |