Database

Database documentation

Our database runs in PostgreSQL, and will be handled with the SQLAlchemy ORM for python (working with pyramid).

The database will be hosted on an AWS EC2 instance through a docker container and can be accessed from DBeaver for a better workflow.

We followed general SQL conventions like table names being lowercase and plural, as well as everything being written in snake_case.

Our database consists of 25 tables:

• users

• projects

  • projects_users

  • projects_users_microtasks

• tasks

  • task_comments

  • task_files

  • task_comments_files

• microtasks

  • microtasks_files

  • microtask_comments

  • microtask_comments_files

• templates

  • templates_files

• files

• labels

  • labelsTask

  • labelsTemplate

  • labelsProjectUser

• chats

  • group_chats

  • personal_chats

  • chat_logs

  • chat_logs_files

• notifications

• activity_log