Tomas-Wardoloff / Virtual-Wallet

Personal project to spend my time in something more useful rather than playing league of legends
MIT License
0 stars 0 forks source link

Database modification #5

Closed Tomas-Wardoloff closed 1 year ago

Tomas-Wardoloff commented 1 year ago

On this branch, I modified two tables of the database. Firstly, I added the column "Type" to the table "Transactions", to know if the balance has to be increased or decreased depending on the transaction type, which could be "Income" or "Expense". Secondly, I added the column "UserId" to the table "Categories", which references the User table to associate a particular user with each category. The categories with UserId = 0 are accessible to all the users.