G
G
guerrrka2018-10-01 22:49:13
Database design
guerrrka, 2018-10-01 22:49:13

How to store the todo list in the database?

For practice, I want to write a todo application (web and android), respectively, there will be an api. The question arose, in what form to store lists of users? (Each user can have an unlimited number of lists of any size.)

Answer the question

In order to leave comments, you need to log in

1 answer(s)
X
xmoonlight, 2018-10-01
@guerrrka

A short list of what you may need:
1. Any task is related nodes or a "tree" of task objects (text, images, files, etc.).
2. Any task - can be dependent on other tasks or other tasks can be dependent on it.
3. Any task - can have its own behavior pattern for various types of events depending on time, other tasks or user actions.
4. For any task - ACL / ABAC rights can be set .
5. Any task - always contains several properties and different statuses.
6. Any task - can be delegated to another user, including all other tasks dependent (on the delegated task).

how to store lists of users
In the usual: a table list. And to each user to bind a new task created by him.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question