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.
- migration scripts need to be updated to include this new field in pieces as it's required.
- 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