I could really use some good feedback on best practices / insight on whether it is better to put things in the database, or build an array. Take for example you have the suits of cards:
$suits = array('clubs', 'spades', 'hearts', 'diamonds');
The array could change in the future, but not very frequently if at all. Now these suits are applied to the cards in a deck. So if I build a table, the schema would look something like:
create table cards {
id INT(11)
card_value char(2),
suit varchar(8)
}
Or is it better to build a suits
table and reference the ID
in the cards
table like:
create table suits {
id INT(11),
name varchar(8)
}
create table cards {
id INT(11),
suit_id int(11),
card_value char(2)
}
Which is the better way to go and why?