Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Eagle_f90
Constraint Violating Yak Guru
424 Posts |
 Posted - 2010-06-06 : 22:34:02
|
| Hello, I am working on a web site dedicated to the Final Fantasy games and am using SQL 2008 as the backend. I am not really good at designing tables so I was hoping to get some suggestions on the best design of my table(s). What I need to do is setup a system to hold the information for all the items in each game. The problem is while each game will share some information in common (type of item, item name, do you buy it, does it drop off monsters, etc.) but some information will not be shared between games. My original idea was to make a table for each game but then I would have over 80 tables just for items not to mention for shops, monsters, and other things. Is it ok to have one table and make a colum for each item property that takes nulls so if a game does not use that property I can leave it null? Hope that all makes sense.-- If I get used to envying others...Those things about my self I pride will slowly fade away.-Stellvia |
|
|
|
|
|
Need suggestions on created table(s) for games