Alter DB schema to support for Request settlement by currency

[ggrg]

Goal:

As a core OSS team member
I want to change the existing database
so that the new DB model caters for Request settlement by currency

The scope of this story is to include all DB changes proposed by the OSS Settlement BRD, section 6.1 Request settlement by currency

Tasks:

• Provide knex migration scripts [@ggrg]
  • settlementWindowContent
  • settlementWindowContentStateChange
  • settlementContentAggregation
  • settlementContentAggregationStateChange
    • to be derived from settlementTransferParticipant
  • Changes to support the settlement model [@ggrg]
    • settlementDelay
    • settlementInterchange
    • settlementGranularity
    • settlementModel
  • Changes to existing tables [@ggrg]
    • settlement
• Provide seed values for all lookup and configuration tables [@ggrg]
• Export ER diagram and have peer review and BRD validation [@ggrg]
• Export DDL and ERD files [@ggrg]
• Peer review and updates [@ggrg]
• Present to DA [@ggrg] link

Acceptance Criteria:

• Existing ERD is updated
• Knex migration scripts are provided
• Seeds are populated
• The model is validated against the BRD
• DB model is presented to the DA
• Any changes, suggested by the DA are addressed
• DB model is approved by the DA
• Documentation is updated

Pull Requests:

• feature/1093 Alter DB schema for settlements documentation#144
• feature/1093 Alter DB Schema for Settlements central-ledger#501

Follow-up:

• Provide SDs for all changes to the existing API (part 1) #1094

Dependencies:

• N/A

Accountability:

• Owner: TBC
• QA/Review: TBC