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:
The new field should be required.
- mod-orders acq-models submodule is updated
- update business login to populate titleId once we create piece
- update unit tests and api tests