Envisioned Schema

All tables have:

• id [unsigned int 11]
• status [active/deleted]
• created_at [datetime]
• created_by [unsigned int 11]
• updated_at [datetime]
• updated_by [unsigned int 11]

user

• first_name [varchar 255]
• last_name [varchar 255]
• user_name [varchar 255]
• email [varchar 255]
• password [varchar 255]
• verified [true/false]
• cell_phone [unsigned int 11]
• carrier_id [unsigned int 11]

carrier

• name
• sms_domain [varchar 255]
• mms_domain [varchar 255]

user_has_budget

• user_id [unsigned int 11]
• access_level [unsigned int 11] (1=create, 2=read, 4=update, 8=delete)

budget

• name [varchar 255]

envelope

• budget_id [unsigned int 11]
• name [varchar 255]
• base_amount [decimal 9,2]
• current_amount [decimal 9,2]
• rolls_over [true/false]
• roll_over_date [date]

transaction

• transaction_date [datetime]
• entity [varchar 255]
• account_id [unsigned int 11]
• amount [decimal 9,2]
• savings [decimal 9,2]
• memo [varchar 255]
• type [income/expense/transfer]
• receipt [varchar 255] (store path to image)
• recurring [true/false]
• recurring_date [date]

account

• name [varchar 255]

logins

• user_id
• ip
• failed_username
• failed_password