Here are the 2 databases that we will be using with the game. There’s one database for the cards in the deck, and another for the players. Any changes or additions are welcome. Here’s what I have so far:
Deck
| Card I.D. (int)(Primary Key) |
| Card Text (String) |
| Image URL (String) |
| Card Color (String) |
Card I.D. would be the primary key used to identify the cards. Card text represents the string text on the card, whether it is a noun or adjective. Image URL refers to the URL of the image that is to appear on the card. Card color refers to the type of card. Red cards have nouns on them, while the yellow cards have adjectives on them.
Players
| Player I.D. (int)(Primary Key) |
| Name (String) |
| Score (int) |
| Judge (Boolean) |
Player I.D. would be the primary key of this table to identify the players. Name would represent the players’ names. In the case that there is more than 1 player with the same name, Player I.D. would help to differentiate them. Score would represent how many hand the player has won so far. Judge is a Boolean value to show which player is the judge of that round. There should only be 1 true value in the Judge column. The rest should be all false.
Again, any additions or changes are welcome.
