Description
Simple Business Manager allows you to manage your company, track invoices and keep finances in order. Letter generator allows you to create letter templates and then send them to your customers. A Company report allows you to quickly see your company finances, expenses and deposits as well as the ability to track miles traveled.
Arbitrary section
A description of the table structure
Table: spm_project
ID = auto increment number
date_submitted = the date the project started format: YYYY-MM-DD HH:MM:SS
last_updated = the last date the project was updated format: YYYY-MM-DD HH:MM:SS
Table: spm_project_attribute
ID value
1 name
2 category
3 status ( The actual value comes from spm_project_status_options )
4 reporter
5 assigned to
6 priority
7 summary
8 description
9 customer id
10 change
Table: spm_project_details
project_id = The id from spm_project
attribute_id = The ID from spm_project_attribute such as: 1
value = The value such as: Fix the home page
Table: spm_project_status_options
ID Value
1 new
2 unassigned
3 assigned
4 acknowledged
5 feedback
6 confirm
7 resolved
8 closed
Please let me know if you have any questions. russell@russellalbin.com