database

database copied to clipboard

Thank you for your amazing work! Is there an example dataset with some (at least about 100) records to see it "in action"?

Ansharja

Add foreign key constraints to database scheme

3

[Foreign key constraints](https://www.sqlite.org/foreignkeys.html) will allow: * auto-generate database schema diagrams and documentation * detect errors in application logic implementation like moneymanagerex/moneymanagerex#1584 * enforce data consistency while modified outside application -...

slodki

All transaction's details from BILLSDEPOSITS can be stored in CHECKINGACCOUNT with TRANSDATE set to NULL. Then BUDGETSPLITTRANSACTIONS can be migrated to SPLITTRANSACTIONS. * All existing queries to CHECKINGACCOUNT should verify...

slodki

**Idea** * Treat all currencies, crypto-currencies and stock shares as a single entity used to describe transaction/account value. * Reuse checking accounts for both investment and share accounts and store...

slodki