eugeniu Posted June 12, 2010 Share Posted June 12, 2010 I'd like to create a database with a table that will store "sets" of flash cards with each set having any x number of flash cards, so I'm looking to have a table that will store one set per entry. But now my problem is, how do I store the flash cards for each set? Would it be a good idea to have them all somehow stored with its set's entry, or should I give each flash card its own entry in another table, with a parameter being what set the flash card belongs to? Or am I missing a better solution? For the sets, I need to store the set title, id, author, and some other properties, and for the flash cards I need to store question, answer, position in set (first, second, etc), and what set it belongs to. What would be the best solution? Quote Link to comment https://forums.phpfreaks.com/topic/204611-best-solution/ Share on other sites More sharing options...
ignace Posted June 13, 2010 Share Posted June 13, 2010 sets (set_id, set_title, set_author_id, ..) cards (card_id, .., card_set_id) Quote Link to comment https://forums.phpfreaks.com/topic/204611-best-solution/#findComment-1071389 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.