Comment 1 for bug 2019425

Revision history for this message
Galen Charlton (gmc) wrote :

Noting that this would require refactoring the database schema to establish the notion of an acquisitions holdings subfield mapping independent of the provider record. Something like:

acq.holdings_subfield_map
  id
  owner
  name (for the map)

acq.holdings_subfield_map_entries
  id
  field_name
  subfield
  holdings_subfield_map FK

Then acq.provider would gain a holdings_subfield_map column.

During upgrade, it would be possible to migrate the existing mappings to a de-duplicated set linked back to the correct providers.

Maybe toss in a library setting to specify a default mapping for new provider records.