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

DB changes for order-invoice-relationships table

    XMLWordPrintable

    Details

    • Type: Story
    • Status: Closed (View Workflow)
    • Priority: P3
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 13.0.0
    • Labels:
      None
    • Template:
      Thunderjet/Firebird Back-end Story Template
    • Sprint:
      ACQ Sprint 111
    • Story Points:
      2
    • Development Team:
      Thunderjet

      Description

      Overview

      In order to make it easier to discover which invoices are related to an order, and to manage these relationships, we need to make a few changes to the order-invoice-relationships table.

      • Add a unique constraint on (purchaseOrderId, invoiceId)
      • Add alias/table alias to help with cross-index subqueries

      Acceptance Criteria

      • changes above are made
      • data migration scripts ensure uniqueness, removing records as needed
      • unit tests are updated

        TestRail: Results

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                yauheni_kuzmianok Yauheni Kuzmianok
                Reporter:
                cmcnally Craig McNally
                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