good practices of creating tables in mysql
I once asked for answers to a problem very similar to yours, and even though I think back on how frustrated I was after a Software Architect did it to me, now, as a much wiser developer, I give the same answer to you. 


  Database Design for Mere Mortals: 2nd Edition
  (2003) by  Michael J. Hernandez. There is also a  Database Design for Mere
  Mortals: 3rd Edition
  (2013) by the same author.



 -- Come back in a couple years as a database engineer, then give someone else the same answer.