Documentation DB Structure

__Main tables__

Activity
naming : a_ + activity ID

List
naming : a_ + list ID

Workflow
workflow_reports: id <==> workflow_report_id of activity table
visit_reports : id <==> visit_id of activity table

Users and teams
mobile_users : mobile users data
web_users : web users data
teams : teams data
teams_mobile_users and teams_web_users : user-team assignations

Updated on: 08/01/2024