hwang26
commented
3 years ago Transaction
- Ignore "Payment Thank You-Mobile" transactions
- Fields
- id
- User id (FK)
- Inspected? (boolean)
- Reoccuring? (boolean)
- Amount (float)
- Note
- Transaction start date
- Aligns with Chase's "Transaction Date"
- Transaction post date
- Chase's "Post Date"
- Categories field (string array of categories which are FKs into the Categories table)
Categories
- A table in the DB that will serve as foreign keys for transactions
User
- A table in the DB that will store user information
- Fields
- id
- First name
- Last name
- Biweekly take home after all deductions (taxes and 401k)
- Monthly Rent
- Current financial goal
Budget
- fields
- id
- date created
- date ends
- name
- Categories field (string array of categories which are FKs into the Categories table)
- amount
Acceptance Criteria:
Have a general idea of what necessary table we'll have