The following is an initial list of database tables. A lot of the tables for sections (messaging, tasks, milestones etc) are likely to change as those sections evolve. The users, account and project tables seem pretty fixed.
I’ll get an ER diagram up in the next few days for the first couple of tables, which will also explain more about the choices I’ve made and what fields will be included.
Accounts and users
users
accounts
account_users
groups
group_users
contact_details
Projects
projects
project_categories
project_category_projects
project_users
Messages
messages
message_categories
message_category_messages
Tasks
tasks
lists
list_categories
list_category_lists
task_priorities
user_lists
user_tasks
group_lists
group_tasks
Tickets
tickets
ticket_messages
ticket_tasks
Milestones
milestones
milestone_categories
milestone_categories_milestones
Files
files
account_files
project_files
file_versions
file_folders
file_folders_files
file_tags
file_tags_files
Comments
comments
comment_comments
project_comments
message_comments
file_comments
Times
times
