Results 1 to 1 of 1
Oct 20, 2002, 17:33 #1
- Join Date
- Oct 2002
- 0 Post(s)
- 0 Thread(s)
3D game comparison database design HELP
I'm trying to design a 3D computer game comparison database using PHP and MySQL, incorporating all the data in http://tnlc.com/eep/compare/table.html and http://tnlc.com/eep/compare/mentions.html (46 games so far), and allowing submissions via the still-being-designed game entry form at http://tnlc.com/eep/compare/gameform.html .
Now, as you can see from the form, I want to allow people to enter custom fields in addition to the provided options (pull-down lists and checkboxes), but I'm having a hard time figuring out how to design that. Do I use "set" fields or cross-reference tables where keys are duplicated and the text-entry field data is entered in them or is there a more efficient way?
Games can have more than one of just about everything.
Original relationships: http://tnlc.com/eep/compare/relations.jpg
Later design (lots of cross-reference tables): http://tnlc.com/eep/compare/relations4.gif
Latest cross-reference design: http://tnlc.com/eep/compare/relations5.gif
Heirarchial design proposed by Barry White: http://www.databaseanswers.com/data_...ames_features/
Here are some discussions I've been involved in so far regarding this database in case you need more info/details:
Any help would be greatly appreciated. I really need as thorough table structures as possible. Thanks!
Last edited by Eep²; Oct 26, 2002 at 22:04.