Answer the question
In order to leave comments, you need to log in
How to format a sql table correctly?
I want to develop a mini application for learning English.
Let's say there are two lists of English words (with translation). One list of words available for study, and the other - already passed. How to arrange sql table more rationally? I get it like this:
the program will receive at once a field with open words (many words) and randomly select one that parses it into one task.
separate the word and the translation, and in brackets[2] the number 2 is the number of points for the correct answer.
Answer the question
In order to leave comments, you need to log in
First, develop a model, and then a data structure, which you will design as tables.
Start modeling with the basic ones: user, word, translation, task, etc. Then from the relationship, for example, a word and its translation, user and task ...
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question