Uploaded image for project: 'Instrument control development'
  1. Instrument control development
  2. INSTRM-1275

Fix `cobra_match` so that `spot_id` can be `NULL`

    XMLWordPrintable

    Details

      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`.

        Attachments

          Activity

            People

            • Assignee:
              kiyoto.yabe Kiyoto Yabe
              Reporter:
              kiyoto.yabe Kiyoto Yabe
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: