- users (id, type, email, password) - User details. type could be either freelancer/client/other/admin.
- projects (id, name, due_data, user_id) - Project details. user_id is the id of client who creates the project.
- project_resources (id, project_id, user_id) - Keep track of who all are involved in a project, could be a client, some freelancers and an agency.
- project_milestones (id, project_id, note, due_date, status) - Keep track of milestones in a project and their status.
- project_tasks (id, milestone_id, user_id, note, due_date, status) - Keep track of tasks linked to a milestone and the user responsible for its completion.
- timesheet (id, user_id, task_id, start_time, end_time) - keep track of how much each user worked on a particular task.