The personal-finances from alexander-poe

personal-finances's Introduction

DB STRUCTURE

CREATE TABLE Checks (
    ID serial primary key,
    Amount int,
    DateDeposited DATE,
    Description varchar(255),
    Picture varchar(255),
    Reoccuring BOOLEAN
);

CREATE TABLE CheckTerm (
    ID serial primary key,
    CheckID int references CHECKS(ID),
    Twenty int,
    Thirty int,
    Fifty int
);

CREATE TABLE TermTransactions (
    ID serial primary key,
    CheckTermID int references CheckTerm(ID),
    TransactionDate DATE,
    Account varchar (255),
    Transaction int,
    Description varchar(255),
    Photo varchar(255)
);

Check
1. User adds payment
2. Amount
3. Picture
4. Description
5. Reoccuring (true / false)
6. Generated Automatically
7. ID
8. Date Deposited
CheckTerm
For the current status of check amount
Check is added computer calculates
1. 20% of initial check
2. 30% of initial check
3. 50% of initial check
Transactions
Adjustment is made to (Twenty / Thirty / Fifty)

1. User adds transaction
    1. Amount
    2. Description
    3. Photo
    4. Account => 20 / 30 / 50
2. Generated Automatically
    1. ID
    2. CheckTermID

Routes

Check
1. User adds check
2. User deletes check
CheckTerm
1. Computer adds term
2. Computer modifies when user inputs transaction
3. Computer fetches CheckTerm
Transactions
1. User adds transaction
2. User fetches transactions
3. User deletes transactions

TODO (feature based)

Photo on check
User adds transaction
1. Transaction is posted to DB
2. get checkterm amount
3. subtract transaction from appropriate checkterm ammount and modify the checkterm.

Report Feature


Period | Total Income | Total Spent | Total Saved
------------- | -------------  |
March         | 3000.00 | 1200.00 | 2800.00

TransactionID| Amount | Description | Photo
------------- | -------------  |
122  | 30.00 | Groceries | Photo
123  | 20.00 | Gas | Photo
124  | 100.00 | Insurance | Photo


Twenty | Thirty| Fifty | Remaining
------------- | -------------  |
600.00       | 54.23 | 100.10 | 754.23

Recommend Projects