tft

Tables (7)

card

  • id — INT — Primary key — NOT NULL
  • augmented — varchar(64)
  • level_3 — varchar(64)
  • level_5 — TEXT
  • level_4 — varchar(128)
  • level_6 — TEXT
  • level_7 — TEXT
  • champion — TEXT
  • trait — TEXT

card_intro

  • id — INT — Primary key — NOT NULL
  • name — varchar(64)
  • trait — varchar(64)
  • image — TEXT
  • description — TEXT
  • card_id (id2) — INT — Foreign key → card.id — NOT NULL

champion

  • id — INT — Primary key — NOT NULL
  • string (name) — varchar(64)
  • string (cost) — INT

champion_final

  • id — INT — Primary key — NOT NULL

champion_trait (Untitled2)

  • id — INT — Foreign key → champion.id — NOT NULL
  • id (id2) — INT — Foreign key → traits.id — NOT NULL

finalDeck

  • id — INT — Primary key — NOT NULL

traits

  • id — INT — Primary key — NOT NULL
  • string (name) — varchar(64)