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? 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) Link to comment https://forums.phpfreaks.com/topic/204611-best-solution/#findComment-1071389 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.