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 -id [unsigned int 11] -user_id [unsigned int 11] -access_level [unsigned int 11] (1=create, 2=read, 4=update, 8=delete)

budget -id [unsigned int 11] -name [varchar 255]

envelope -id [unsigned int 11] -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 -id [unsigned int 11] -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 -id [unsigned int 11] -name [varchar 255]

logins -id -user_id -ip -failed_username -failed_password