patternMinor
What are the pros and cons of this schema for flashcards app?
Viewed 0 times
thisthewhatappareflashcardsprosforandschema
Problem
I am planning a flashcards app with the following schema:
Some of the things I would like to ultimately calculate are:
Does this seem reasonable? How else could I go about capturing guesses in a logical fashion?
user(id, name, email)
flashcard_group(id, user_id, group_name, group_tag)
flashcard(id, group_id, question, solution)
guess(id, user_id, flashcard_id, is_correct)Some of the things I would like to ultimately calculate are:
- The number of times a user guesses a flash card incorrectly and correctly (or a correctness percentage)
- All of a user's flashcards
- All of the user's flashcard groups
- Probably more information about guesses.
Does this seem reasonable? How else could I go about capturing guesses in a logical fashion?
Solution
- Flashcards are used to test knowledge in a topic.
- Each card has a question and a correct answer.
- One topic has many cards.
- Each card may belong to more then one topic.
- User chooses a topic to test in.
- User may attempt the same test many times.
- Each test has many cards (questions) from the chosen topic.
- Each card may be part of many test from the chosen topic.
Note:
UserTopicAttempt is as sequence number (1,2,3 ...) for each (USerID,TopicID).Context
StackExchange Database Administrators Q#24553, answer score: 4
Revisions (0)
No revisions yet.