hearthstoneERD

Tables (9)

cardtotal

  • cardID — int — Primary key — NOT NULL
  • cartType — varchar(45)
  • packID — int
  • cardClass — int

class

  • classID (직업 아이디) — int — Primary key — NOT NULL
  • className (직업 이름) — varchar(45)
  • skillID (스킬 아이디) — int

deck

    keyword

    • keywordID — int — Primary key — NOT NULL
    • keywordName — varchar(45)

    minion

    • cardID — int — Primary key — NOT NULL
    • costPoiint — int
    • attackPoint — int
    • lifePoint — int
    • skillID — int
    • cardName — varchar(45)

    skill

    • skillID — int — Primary key — NOT NULL
    • cardID — int
    • skillText — varchar(45)
    • skillType — int

    spell

    • cardID — int — Primary key — NOT NULL
    • cardName — varchar(45)
    • cardClass — int
    • skillID — int
    • cardCost — int

    user

      weapon

      • cardID — int — Primary key — NOT NULL
      • attackPoint — int
      • durablePoint — int
      • skillID — int
      • classID — int
      • cardCost — int