I want to make budget tracking web-app, tracking all savings and expenses with corresponding dates. Later generating reports, summaries etc..

I came up this design design

  1. Frequency Table - does it have to exist and the best way of storing type of regularity? Json maybe?
  2. What the operation should I use? the seperate authentication server - keycloak for User informations and in my user entity only store id and user_id from the keycloak user? or maybe leave it as is?
  3. the Category only applies to certain type of operation Type.. if it is not, leave a null?

Any other suggestions are welcome :)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.