i'm working on card game reference website. need have table i'm sure expand in future.
for example, if have table used save attributes of cards, , each card has following information:
card_name rarity race skill1
in future, game may add skill or other information card this:
card_name rarity race skill1 skill2 others
in case, wondering best solution me design database. add new columns or use table save new information of cards?
also, i'm looking tips have watch out. btw, i'm using mysql
create relation table. add primary key id
cards table, autoincrement, , store base data cards. create relation table, foreing key card table id. later can extend table.
here post about, how create it: how create relation table in mysql?
here littlebit more detailed post it: http://www.techrepublic.com/article/relational-databases-defining-relationships-between-database-tables/
Comments
Post a Comment