formats.md 650 B

Definition of data structure formats.

Current:

Account

  • First Name
  • Last Name
  • Account Number
  • History

Account Event

  • Balance Change
  • Description

SQL

Accounts FirstName | LastName | AccountNumber | History (JSON text)

Optimal:

Account

  • First Name
  • Last Name
  • Account Number (indentifier)

Account Event

  • Type (transfer | deposit | withdrawal)
  • Receiver (if applicable)
  • Sender (if applicable)
  • Balance Change
  • // Description can be generated based on available info

SQL

Accounts FirstName | LastName | AccountNumber

Events Type (int) | Receiver (accountnumber) | Sender (accountnumber) | BalanceChange (double)