1. calls
   1. call_id [int(11)]
   2. call_contact_id [int(11)]
   3. call_timestamp [varchar(100)]
   4. call_staff [varchar(300)]
2. clients
   1. client_id [int(11)]
   2. client_name [varchar(100)]
   3. client_callcount [int(11)]
   4. client_massagecount [int(11)]
   5. client_threenocount [int(11)]
   6. client_returnedmessagescount [int(11)]
   7. client_newleadscount [int(11)]
   8. client_propsuccess [int(11)]
   9. client_status [tinyint(1)]
   10. client_code [varchar(3)]
   11. client_website [varchar(255)]
   12. client_phone [varchar(20)]
   13. client_street [varchar(255)]
   14. client_city [varchar(100)]
   15. client_country [varchar(200)]
   16. client_zip [varchar(10)]
   17. client_email [varchar(100)]
   18. client_province [varchar(30)]
3. contacts
   1. contact_id [int(11)]
   2. contact_phone [varchar(50)]
   3. contact_address [varchar(300)]
   4. contact_client_id [int(11)]
   5. contact_email [varchar(100)]
   6. contact_title [varchar(300)]
   7. contact_name [varchar(100)]
4. projects
   1. project_id [int(11)]
   2. project_code [varchar(10)]
   3. project_client_id [int(11)]
   4. project_contact_id [int(11)]
   5. project_title [varchar(100)]
   6. project_description [varchar(1000)]
   7. project_probstate [varchar(1000)]
   8. project_objective [varchar(1000)]
   9. project_timeline [varchar(100)]
   10. project_budget [varchar(100)]
   11. project_urgent [tinyint(1)]
   12. project_reqstamp [tinyint(1)]
5. Legend
   1. Columns in use
      1. Blue
   2. Deprecated Columns
      1. Orange