Uploaded image for project: 'mod-orders-storage'
  1. mod-orders-storage
  2. MODORDSTOR-42

Add unique constraint and index for PO number field in DB

    XMLWordPrintable

    Details

    • Type: Story
    • Status: Closed (View Workflow)
    • Priority: P3
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 3.0.0
    • Labels:
      None
    • Template:
    • Sprint:
      ACQ Sprint 55, ACQ Sprint 56
    • Story Points:
      2
    • Development Team:
      Thunderjet
    • Epic Link:

      Description

      Purpose:

      • In order to guarantee PO number uniqueness across all orders a unique constraint needs to be added for PO number filed in DB.
        Right now the uniqueness is enforced by the validation that takes place when Order is created/update, but since there is a gap between validation and actual update of the Order it is not reliable and sufficient.
      • Also it's expected that PO number will often be used for searching the Order, so indexing this field should improve the performance.

      Acceptance criteria:

      • Unique constraint is added for PO number field
      • Index is created for PO number field

        TestRail: Results

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                cmcnally Craig McNally
                Reporter:
                pavelk-epam Pavel Korolenok
                Tester Assignee:
                Craig McNally Craig McNally
                Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases