Henry Weismann ( User ) 4 days ago
Yeah Can you possible send me the new schema for the database for the work you are doing?
I will be syncing activecollab.com with your work and here is what I was going to create. Let me know if this is close and if not please send your schema so I can continue work on my syncing with my third party system while doing things the way you are with the db at least:
id, employee_id, project_id, date_from, date_to
(where project id=0 is default can enter dates with different rates to account for rate changes over time)
id, time,employee_id, project_id,task_id,sub_task_id, billable,task_category
category would be like web design, web development, quality assurance, etc etc
this is because I will be syncing third party systems:
id, entity_type, our_system_id, remote_system_id
where entity type is one of customer, employee, project, task, sub task
As far as employees and projects and tasks Akaunting already has places to store that data but does it have a concept of sub tasks?
Thanks so much!
Do you have a https://www.patreon.com/ ?