LP#1857150: various schema and IDL changes
authorGalen Charlton <gmc@equinoxinitiative.org>
Wed, 2 Sep 2020 16:32:25 +0000 (12:32 -0400)
committerGalen Charlton <gmc@equinoxinitiative.org>
Tue, 8 Sep 2020 18:43:56 +0000 (14:43 -0400)
commitfc46e3fa7209bb33c3e4c178c7b826fc2fd4929d
treed3d717a4deda2fd974682e085749c48e71520ac9
parentd4295d0c6cdc20ba3a799dc2fc5d445b25ccc294
LP#1857150: various schema and IDL changes

* Add a primary_contact column to acq.provider. The primary contact,
  when set, signifies the primary point of contact in case a provider
  has multiple contacts. This is displayed on the summary pane in
  the Angular interface.

* Mark various non-NULL fields as required so that the record editor,
  can require them in turn:

  - acqpro.name
  - acqpro.owner
  - acqpro.currency_type
  - acqpro.code
  - acqpa.city
  - acqpa.country
  - acqpa.post_code
  - acqpa.state
  - acqpa.street1
  - acqpc.provider
  - acqpc.name
  - acqpca.city
  - acqpca.country
  - acqpca.post_code
  - acqpca.state
  - acqpca.street
  - acqlipad.code
  - acqlipad.description
  - acqlipad.xpath
  - acqlipad.provider
  - acqphsm.provider
  - acqphsm.name
  - acqphsm.subfield
  - acqedi.label
  - acqedi.host
  - acqedi.owner
  - acqedi.provider
  - acqedi.use_attrs

* Make acqpro.name not be translatable. This appears to have just
  been a case of copy-and-pastitis, as providers don't seem to
  vary their names by locale.

* Add various virtual fields to support more fleshing:

  - acqpro.contacts
  - acqpro.holdings_subfields
  - acqpro.attributes
  - acqpro.edi_accounts
  - acqpc.addresses

This patch includes contributions by Mike Rylander.

Sponsored-by: Evergreen Community Development Initiative
Signed-off-by: Galen Charlton <gmc@equinoxinitiative.org>
Open-ILS/examples/fm_IDL.xml
Open-ILS/src/sql/Pg/200.schema.acq.sql
Open-ILS/src/sql/Pg/800.fkeys.sql
Open-ILS/src/sql/Pg/upgrade/AAAA.schema.provider-primary-contact.sql [new file with mode: 0644]