Page Comparison

...

• In mod-search PostgreSQL DB

  • create a table tables for call numbers

    • The following fields should be present in the table callnumber table:

      • itemcallnumber_id - item identifier

      • effective_callnumber_components - set of components for a callnumber

        • callnumber

        • prefix

        • suffix

        • callnumber_type_id

      • volume

      • enumeration

      • chronology

      • copynumberinstance_arr - jsonb field for storing the relation with instances

    • The following fields should be present in the table callnumber_instances table:

      • callnumber_id

      • instance_id

      • shared

      • tenant_id

  • on create/update/delete events for items create a new procedure that would extract call numbers from items

• Adjust the Reindexing procedure and Ongoing domain events consuming for items

• Create a separate index for call numbers

• Refactor browse queries to use search_after search_before queries

...