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