Planning with Brandon and Hamid on 7/11/24

Project - Budgeting and Making a Budget Tool

- create a plan and see if you can stick to it.
- like a piece of pie - what goes where?

- $25/hour

- $1,000 my budget

- make a plan - using CF, MySQL, HTML, CSS (optional), JavaScript (optional)
	- show me your plan
	- use pen and paper and make some notes, what pages will look like, what they will do, etc.

- plan the database...
	- create a new budget table
		- id, name, date range, active/inactive (main or the one)

	- once created (the main) be able to add any line items to it (new line items table)
		- their own id, tie-in to the main id, category (need to plan), description, value range or set value (min/max range), actual value, difference, active/inactive, etc.

- on the categories... it would be awesome to help and save those in a new table as well.
	- you you want categories and sub categories? (bonus land)
	- plan what this table or tables might look like.

- requirements...
	- Be able to save a budget (record the main in the database)
	- The budget can have multiple lines (with categories and maybe sub categories) - build a one-to-many with the main and line items.
	- Be able to query the budget by name - show the results
	- Be able to pull the data back up - data drill-down - from results to details (per budget)