Database design setup

[Lothrazar]

Use its own isolated schema

user has multiple targets. target is an account (owned by user), or an entity (external to user)

a target is just something that a transaction points at (src and dest) a target is going to be an income or expense type depending on src and on +/-

accounts have exactly one type from cash/ credit : means pos or negative

entities can have multiple tags, pullled from list such as living expense, purchase, service, work income, etc

[Lothrazar]

new setup; user is just the login / page context.user has accounts and entities that it created

Accounts have a balance, and are of type cash, holding, credit, or entity. always has exactly one cash account

entities are outside sources (such as employer for income, company for fees/services)

and now we can easily see untracked cash flow using the cash account. and transactions always point between accounts

[Lothrazar]

endpoint: id type (cash, account, credit, external) date balance tags (user defined / csv type list)

transaction: pay from pay to date id amt > 0