CARD

Tables (8)

Card_type (Untitled4)

  • typeKey (Key) — Primary key — NOT NULL
  • comment (Field)

Cards (Untitled2)

  • CardKey (Key) — Primary key — NOT NULL
  • cardGrade (Field)
  • cardDust (Field2)
  • mana (Field3)
  • attack (Field4)
  • health (Field5)
  • typeKey (Key2) — Foreign key → Card_type.typeKey — NOT NULL

Deck (Untitled3)

  • deckCode (Field) — Primary key
  • Name (Field2)
  • Class (Field3)
  • decktypeKey (Key) — Foreign key → DeckType.decktypeKey — NOT NULL
  • winningpercentage (Field4)

DeckType (Untitled6)

  • decktypeKey (Key) — Primary key — NOT NULL
  • typeName (Field)

Deck_building (Untitled7)

  • deckCode (Field) — Foreign key → Deck.deckCode
  • CardKey (Key) — Foreign key → Cards.CardKey — NOT NULL

User (Untitled)

  • userId (Key) — Primary key — NOT NULL
  • userBattletag (Field)
  • server (Field2)
  • userDust (Field3)

User_cards (Untitled5)

  • userId (Key) — Foreign key → User.userId — NOT NULL
  • CardKey (Key2) — Foreign key → Cards.CardKey — NOT NULL

Userdeck (Untitled8)