MySQL Forums
Forum List  »  Newbie

Re: Need Database Structure Help
Posted by: Alex Bursch
Date: October 19, 2010 06:51PM

Yes, and that should help.

Skills are just a small subset that the database needs to keep track of. There is also:

Class Attributes (6 tables)
Race Attributes (3 tables)
Feats (3 tables)
Spells (7 tables)
Equipment (16 tables)
Random Stuff (4 tables)

The database has grown just a little since I last posted. I am still stuck on one main problem. I have read every table needs a key, but I have also read that I am only allowed one primary key per table. So for example with all of the skills tables that need multiple keys to be unique, do I need to use the UNIQUE attribute instead of a primary key? is there something else to use? What would the actual syntax be?

Thanks

Options: ReplyQuote


Subject
Written By
Posted
October 09, 2010 11:43AM
Re: Need Database Structure Help
October 19, 2010 06:51PM
October 20, 2010 09:16AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.