Entities

Account balance

The ledger balance and the independent supporting balance for an account at a period end, with the source of the supporting figure.

Volume

Accounts × periods

Retention

Indefinite

Entity attributes7
  • Exact decimal arithmetic end to end — database column, ORM mapping, API serialisation and client. Floating point anywhere in the chain is disqualifying.
  • Exact decimal arithmetic end to end — database column, ORM mapping, API serialisation and client. Floating point anywhere in the chain is disqualifying.
  • supporting_source
  • Exact decimal arithmetic end to end — database column, ORM mapping, API serialisation and client. Floating point anywhere in the chain is disqualifying.
  • account_balance_id
  • account_id / period_id
  • loaded_at
Entity relationships2
Entity relationships1
Entity lifecycle

Not yet researched

Only the control-bearing entities were modelled for lifecycle. Defensible as a starting point, but it does leave the entity model uneven, and this is incompleteness rather than a finding.