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

Reconsider unique columns in e.g. mcsData

    XMLWordPrintable

    Details

      Description

      We have non-null serial columns in many databases (e.g. mcsData has mysid) which are probably not needed – the natural join key is usually (frameId, fiberId) and we should probably that tuple be the unique constraint and primary key (cf. this stack overflow answer)

      This will save a little space, and should also speed up access significantly. In some cases the moveId will need to be included too.

      In the cases that we do need a serial column, I propose that we always name them tableNameId (e.g. mcsDataId), or possibly mcsDataSerial to reduce confusion with e.g. fiberId

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: