Re: Design help and multiple values in a field
Posted by: Huu Da Tran
Date: May 16, 2008 12:26PM

well, yes i have a better idea of what you want, but that is a lot of design and I don't think that this place is where you will get all done. I can give you some more pointers though:

1. 12 creatures slots. You would need either to limit it on program side or DB side. I would enforce it on db side with a table designe like:
playerid int not null,
creature_slot enum('1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12') not null,
creature_type int not null,
...
unique index player_creature(`playerid`, `creature_slot`),
...
Making sure no illegal values can me stored, the unique index would ensure you a max of 12 creatures per player.

And for every other requirement, try to find out how you would do it.

Good luck,
H.

Options: ReplyQuote


Subject
Written By
Posted
Re: Design help and multiple values in a field
May 16, 2008 12:26PM


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.