IS-94.00 Database Schema Part Deux

[dfilteau]

PSP_PIMS | Development Sprint: S94.00 | Design Sprint: 93 | Date: 2024-Nov-27

• Altered tables:
  • PIMS_ACQUISITION_FILE
  • PIMS_ACQUISITION_FILE_HIST
  • PIMS_DISPOSITION_FILE_DOCUMENT
  • PIMS_DISPOSITION_FILE_DOCUMENT_HIST
  • PIMS_DOCUMENT
  • PIMS_DOCUMENT_HIST
  • PIMS_DOCUMENT_QUEUE
  • PIMS_DOCUMENT_QUEUE_HIST
  • PIMS_PROJECT_PRODUCT
  • PIMS_PROJECT_PRODUCT_HIST
  • PIMS_PROP_PROP_ANOMALY_TYPE
• Added build script:
  • 009_DML_Set_Concurrency_Control_NULL.sql
• Altered test script:
  • 031_PIMS_ACQUISITION_FILE.sql
  • 043_PIMS_ACQUISITION_FILE.sql
• Requires additional metadata to meet standards