Design database

[Tommo303]

We need to design the database for the web app- this should be implemented using sqlite. I imagine that we would need at least the following tables:

• Users: stores information about users and is used for logins
• Boards: stores information about all the kanban boards that exist
• Tasks: stores information about the tasks, which boards they belong to, who the task is assigned to

In addition to these, we may want to consider other tables to store the history of a task's progress, etc. depending on what special features we want to implement.

[Tommo303]

[Tommo303]

The project description says that we need "the ability to store user interactions and the results of those interactions" and "the ability to search previous user interactions".

To address these points, we will need to have another table that stores all things done by every user, including:

• creating a task
• modifying the status of a task (e.g. in progress -> done)
• adding a comment to a task

The point on comments suggests that we may also need a table to store timestamped comments made on tasks.