title: Converting JSON to a MySQL table, how should the table structure look like?
body: <p>The following is the JSON file...</p>
  
  <pre><code>{
      "name":"Magic 2014 Core Set",
      "code":"M14",
      "releaseDate":"2013-07-19",
      "border":"black",
      "type":"core",
      "cards":
      [
          {
              "layout":"normal",
              "type":"Creature - Human Warrior",
              "types":["Creature"],
              "colors":["Red"],
              "multiverseid":370735,
              "name":"Academy Raider",
              "subtypes":["Human","Warrior"],
              "cmc":3,
              "rarity":"Common",
              "artist":"Karl Kopinski",
              "power":"1",
              "toughness":"1",
              "manaCost":"{2}{R}",
              "text":"Intimidate (This creature can't be blocked except by artifact creatures and/or creatures that share a color with it.)\n\nWhenever Academy Raider deals combat damage to a player, you may discard a card. If you do, draw a card.",
              "number":"124",
              "imageName":"academy raider"
          },
          {
              "layout":"normal",
              "type":"Artifact - Equipment",
              "types":["Artifact"],
              "colors":[],
              "multiverseid":370581,
              "name":"Accorder's Shield",
              "subtypes":["Equipment"],
              "cmc":0,
              "rarity":"Uncommon",
              "artist":"Alan Pollack",
              "manaCost":"{0}",
              "text":"Equipped creature gets +0/+3 and has vigilance. (Attacking doesn't cause it to tap.)\n\nEquip {3} ({3}: Attach to target creature you control. Equip only as a sorcery.)",
              "flavor":"An Auriok shield is polished to a mirror finish even on the inside, enabling its bearer to watch foes ahead and behind.",
              "number":"204",
              "imageName":"accorder's shield"
          },
          {
              "layout":"normal",
              "type":"Creature - Spirit",
              "types":["Creature"],
              "colors":["Black"],
              "multiverseid":370811,
              "name":"Accursed Spirit",
              "subtypes":["Spirit"],
              "cmc":4,
              "rarity":"Common",
              "artist":"Kev Walker",
              "power":"3",
              "toughness":"2",
              "manaCost":"{3}{B}",
              "text":"Intimidate (This creature can't be blocked except by artifact creatures and/or creatures that share a color with it.)",
              "flavor":"Many have heard the slither of dragging armor and the soft squelch of its voice. But only its victims ever meet its icy gaze.",
              "number":"83",
              "imageName":"accursed spirit"
          },
          {...},
          {...},
          {...},
      ]
  }
  </code></pre>
  
  <p>The cards data itself I think would be in a single table but I'm not sure how the...</p>
  
  <pre><code>"name":"Magic 2014 Core Set",
  "code":"M14",
  "releaseDate":"2013-07-19",
  "border":"black",
  "type":"core",
  </code></pre>
  
  <p>would be associated with the card data. How should I design the MySQL table(s) for easy and efficient access?</p>