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

Add titleId field to the piece schema and create a foreign key

    XMLWordPrintable

    Details

    • Template:
    • Sprint:
      ACQ Sprint 87, ACQ Sprint 88
    • Story Points:
      2
    • Development Team:
      Thunderjet

      Description

      Overview

      In order to support filtering titles by information in the associated piece record, we need to add a titleId field to the piece schema and create a foreign key.

      The end result is that we should be able to execute queries like:
      GET /orders/titles?query=pieces.receivingStatus=Expected

      The new field should be required.

      Data Migration

      • migration scripts need to be updated to include this new field in pieces as it's required.

      Acceptance Criteria

      • the piece schema/example have been updated
      • schema.json has been updated to include foreign key
      • sample data is updated
      • mod-orders acq-models submodule is updated
      • migration scripts are updated

        TestRail: Results

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                aliaksandr_pautau Aliaksandr Pautau
                Reporter:
                cmcnally Craig McNally
                Tester Assignee:
                Aliaksandr Pautau Aliaksandr Pautau
                Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases