E
E
Eternal972021-01-18 20:54:18
Database design
Eternal97, 2021-01-18 20:54:18

How to design a database for a checklist service?

Hi all! I'm writing a test task in Laravel and got stuck. In general, you need to implement a checklist service. For each user, you need to implement several checklists with tasks that he must perform. I created three three tables for this. The structure looks like this: The 6005ca5e91a26111397742.png
question is, did I do everything right or can the tables be implemented somehow differently? Many thanks in advance for your advice!

Answer the question

In order to leave comments, you need to log in

1 answer(s)
V
Vitsliputsli, 2021-01-18
@Eternal97

users:
- user_id
- name
checklists:
- checklist_id
- user_id - association with users
tasks:
- task_id
- checklist_id - association with checklists
- task_message

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question