Verify initial data model

axjasf commented 2 weeks ago

[ ] Write a wiki document about the data model
[x] Take into consideration different tables, fields, and views and their justification
[x] Take into consideration cascading of deletions and updates.
[x] Compare current data model to google sheet and adjust documentation and technical structure.
[x] Ensure data normalization and avoid redundancy
[x] Define relationships and foreign key constraints
[x] Data integrity constraints: Check for constraints like NOT NULL, unique keys, or value limits that are essential for data integrity.
[x] What can be altered while the app grows, what has to be in place from the get go?
[ ] What else might be important?
[ ] Data consistency - consider it and make it a chapter.

axjasf commented 2 weeks ago

Initial page is started with a goals section and a quick comparison of the google sheet with the current data model.

axjasf commented 2 weeks ago

Worked on this today adding a description field to the transaction splits and thinking about data consistency, opened up a chapter for that.

axjasf commented 2 weeks ago

axjasf commented 1 week ago

Leaving this active as an important step

axjasf / PersonalFinanceCategorizer_WebApp