{ "database": "mspdevco_deckbuildercouk", "columns": [ { "TABLE_NAME": "cardForeignData", "ORDINAL_POSITION": 1, "COLUMN_NAME": "id", "data_type": "int(11)", "IS_NULLABLE": "NO", "COLUMN_DEFAULT": null, "COLUMN_KEY": "PRI", "EXTRA": "auto_increment" }, { "TABLE_NAME": "cardForeignData", "ORDINAL_POSITION": 2, "COLUMN_NAME": "faceName", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardForeignData", "ORDINAL_POSITION": 3, "COLUMN_NAME": "flavorText", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardForeignData", "ORDINAL_POSITION": 4, "COLUMN_NAME": "identifiers", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardForeignData", "ORDINAL_POSITION": 5, "COLUMN_NAME": "language", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardForeignData", "ORDINAL_POSITION": 6, "COLUMN_NAME": "multiverseId", "data_type": "int(11)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardForeignData", "ORDINAL_POSITION": 7, "COLUMN_NAME": "name", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardForeignData", "ORDINAL_POSITION": 8, "COLUMN_NAME": "text", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardForeignData", "ORDINAL_POSITION": 9, "COLUMN_NAME": "type", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardForeignData", "ORDINAL_POSITION": 10, "COLUMN_NAME": "uuid", "data_type": "varchar(36)", "IS_NULLABLE": "NO", "COLUMN_DEFAULT": null, "COLUMN_KEY": "MUL", "EXTRA": "" }, { "TABLE_NAME": "cardIdentifiers", "ORDINAL_POSITION": 1, "COLUMN_NAME": "id", "data_type": "int(11)", "IS_NULLABLE": "NO", "COLUMN_DEFAULT": null, "COLUMN_KEY": "PRI", "EXTRA": "auto_increment" }, { "TABLE_NAME": "cardIdentifiers", "ORDINAL_POSITION": 2, "COLUMN_NAME": "cardKingdomEtchedId", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardIdentifiers", "ORDINAL_POSITION": 3, "COLUMN_NAME": "cardKingdomFoilId", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardIdentifiers", "ORDINAL_POSITION": 4, "COLUMN_NAME": "cardKingdomId", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardIdentifiers", "ORDINAL_POSITION": 5, "COLUMN_NAME": "cardsphereFoilId", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardIdentifiers", "ORDINAL_POSITION": 6, "COLUMN_NAME": "cardsphereId", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardIdentifiers", "ORDINAL_POSITION": 7, "COLUMN_NAME": "deckboxId", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardIdentifiers", "ORDINAL_POSITION": 8, "COLUMN_NAME": "mcmId", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardIdentifiers", "ORDINAL_POSITION": 9, "COLUMN_NAME": "mcmMetaId", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardIdentifiers", "ORDINAL_POSITION": 10, "COLUMN_NAME": "mtgArenaId", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardIdentifiers", "ORDINAL_POSITION": 11, "COLUMN_NAME": "mtgjsonFoilVersionId", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardIdentifiers", "ORDINAL_POSITION": 12, "COLUMN_NAME": "mtgjsonNonFoilVersionId", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardIdentifiers", "ORDINAL_POSITION": 13, "COLUMN_NAME": "mtgjsonV4Id", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardIdentifiers", "ORDINAL_POSITION": 14, "COLUMN_NAME": "mtgoFoilId", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardIdentifiers", "ORDINAL_POSITION": 15, "COLUMN_NAME": "mtgoId", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardIdentifiers", "ORDINAL_POSITION": 16, "COLUMN_NAME": "multiverseId", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardIdentifiers", "ORDINAL_POSITION": 17, "COLUMN_NAME": "scryfallCardBackId", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardIdentifiers", "ORDINAL_POSITION": 18, "COLUMN_NAME": "scryfallId", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardIdentifiers", "ORDINAL_POSITION": 19, "COLUMN_NAME": "scryfallIllustrationId", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardIdentifiers", "ORDINAL_POSITION": 20, "COLUMN_NAME": "scryfallOracleId", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardIdentifiers", "ORDINAL_POSITION": 21, "COLUMN_NAME": "tcgplayerEtchedProductId", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardIdentifiers", "ORDINAL_POSITION": 22, "COLUMN_NAME": "tcgplayerProductId", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardIdentifiers", "ORDINAL_POSITION": 23, "COLUMN_NAME": "uuid", "data_type": "varchar(36)", "IS_NULLABLE": "NO", "COLUMN_DEFAULT": null, "COLUMN_KEY": "MUL", "EXTRA": "" }, { "TABLE_NAME": "cardLegalities", "ORDINAL_POSITION": 1, "COLUMN_NAME": "id", "data_type": "int(11)", "IS_NULLABLE": "NO", "COLUMN_DEFAULT": null, "COLUMN_KEY": "PRI", "EXTRA": "auto_increment" }, { "TABLE_NAME": "cardLegalities", "ORDINAL_POSITION": 2, "COLUMN_NAME": "alchemy", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardLegalities", "ORDINAL_POSITION": 3, "COLUMN_NAME": "brawl", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardLegalities", "ORDINAL_POSITION": 4, "COLUMN_NAME": "commander", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardLegalities", "ORDINAL_POSITION": 5, "COLUMN_NAME": "duel", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardLegalities", "ORDINAL_POSITION": 6, "COLUMN_NAME": "future", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardLegalities", "ORDINAL_POSITION": 7, "COLUMN_NAME": "gladiator", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardLegalities", "ORDINAL_POSITION": 8, "COLUMN_NAME": "historic", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardLegalities", "ORDINAL_POSITION": 9, "COLUMN_NAME": "legacy", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardLegalities", "ORDINAL_POSITION": 10, "COLUMN_NAME": "modern", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardLegalities", "ORDINAL_POSITION": 11, "COLUMN_NAME": "oathbreaker", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardLegalities", "ORDINAL_POSITION": 12, "COLUMN_NAME": "oldschool", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardLegalities", "ORDINAL_POSITION": 13, "COLUMN_NAME": "pauper", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardLegalities", "ORDINAL_POSITION": 14, "COLUMN_NAME": "paupercommander", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardLegalities", "ORDINAL_POSITION": 15, "COLUMN_NAME": "penny", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardLegalities", "ORDINAL_POSITION": 16, "COLUMN_NAME": "pioneer", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardLegalities", "ORDINAL_POSITION": 17, "COLUMN_NAME": "predh", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardLegalities", "ORDINAL_POSITION": 18, "COLUMN_NAME": "premodern", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardLegalities", "ORDINAL_POSITION": 19, "COLUMN_NAME": "standard", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardLegalities", "ORDINAL_POSITION": 20, "COLUMN_NAME": "standardbrawl", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardLegalities", "ORDINAL_POSITION": 21, "COLUMN_NAME": "timeless", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardLegalities", "ORDINAL_POSITION": 22, "COLUMN_NAME": "uuid", "data_type": "varchar(36)", "IS_NULLABLE": "NO", "COLUMN_DEFAULT": null, "COLUMN_KEY": "MUL", "EXTRA": "" }, { "TABLE_NAME": "cardLegalities", "ORDINAL_POSITION": 23, "COLUMN_NAME": "vintage", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardPurchaseUrls", "ORDINAL_POSITION": 1, "COLUMN_NAME": "id", "data_type": "int(11)", "IS_NULLABLE": "NO", "COLUMN_DEFAULT": null, "COLUMN_KEY": "PRI", "EXTRA": "auto_increment" }, { "TABLE_NAME": "cardPurchaseUrls", "ORDINAL_POSITION": 2, "COLUMN_NAME": "cardKingdom", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardPurchaseUrls", "ORDINAL_POSITION": 3, "COLUMN_NAME": "cardKingdomEtched", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardPurchaseUrls", "ORDINAL_POSITION": 4, "COLUMN_NAME": "cardKingdomFoil", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardPurchaseUrls", "ORDINAL_POSITION": 5, "COLUMN_NAME": "cardmarket", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardPurchaseUrls", "ORDINAL_POSITION": 6, "COLUMN_NAME": "tcgplayer", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardPurchaseUrls", "ORDINAL_POSITION": 7, "COLUMN_NAME": "tcgplayerEtched", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardPurchaseUrls", "ORDINAL_POSITION": 8, "COLUMN_NAME": "uuid", "data_type": "varchar(36)", "IS_NULLABLE": "NO", "COLUMN_DEFAULT": null, "COLUMN_KEY": "MUL", "EXTRA": "" }, { "TABLE_NAME": "cardRulings", "ORDINAL_POSITION": 1, "COLUMN_NAME": "id", "data_type": "int(11)", "IS_NULLABLE": "NO", "COLUMN_DEFAULT": null, "COLUMN_KEY": "PRI", "EXTRA": "auto_increment" }, { "TABLE_NAME": "cardRulings", "ORDINAL_POSITION": 2, "COLUMN_NAME": "date", "data_type": "date", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardRulings", "ORDINAL_POSITION": 3, "COLUMN_NAME": "text", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cardRulings", "ORDINAL_POSITION": 4, "COLUMN_NAME": "uuid", "data_type": "varchar(36)", "IS_NULLABLE": "NO", "COLUMN_DEFAULT": null, "COLUMN_KEY": "MUL", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 1, "COLUMN_NAME": "id", "data_type": "int(11)", "IS_NULLABLE": "NO", "COLUMN_DEFAULT": null, "COLUMN_KEY": "PRI", "EXTRA": "auto_increment" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 2, "COLUMN_NAME": "artist", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 3, "COLUMN_NAME": "artistIds", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 4, "COLUMN_NAME": "asciiName", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 5, "COLUMN_NAME": "attractionLights", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 6, "COLUMN_NAME": "availability", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 7, "COLUMN_NAME": "boosterTypes", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 8, "COLUMN_NAME": "borderColor", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 9, "COLUMN_NAME": "colorIdentity", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 10, "COLUMN_NAME": "colorIndicator", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 11, "COLUMN_NAME": "colors", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 12, "COLUMN_NAME": "defense", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 13, "COLUMN_NAME": "duelDeck", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 14, "COLUMN_NAME": "edhrecRank", "data_type": "int(11)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 15, "COLUMN_NAME": "edhrecSaltiness", "data_type": "float", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 16, "COLUMN_NAME": "faceConvertedManaCost", "data_type": "float", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 17, "COLUMN_NAME": "faceFlavorName", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 18, "COLUMN_NAME": "faceManaValue", "data_type": "float", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 19, "COLUMN_NAME": "faceName", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 20, "COLUMN_NAME": "finishes", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 21, "COLUMN_NAME": "flavorName", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 22, "COLUMN_NAME": "flavorText", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 23, "COLUMN_NAME": "frameEffects", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 24, "COLUMN_NAME": "frameVersion", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 25, "COLUMN_NAME": "hand", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 26, "COLUMN_NAME": "hasAlternativeDeckLimit", "data_type": "tinyint(1)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 27, "COLUMN_NAME": "hasContentWarning", "data_type": "tinyint(1)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 28, "COLUMN_NAME": "hasFoil", "data_type": "tinyint(1)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 29, "COLUMN_NAME": "hasNonFoil", "data_type": "tinyint(1)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 30, "COLUMN_NAME": "isAlternative", "data_type": "tinyint(1)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 31, "COLUMN_NAME": "isFullArt", "data_type": "tinyint(1)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 32, "COLUMN_NAME": "isFunny", "data_type": "tinyint(1)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 33, "COLUMN_NAME": "isGameChanger", "data_type": "tinyint(1)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 34, "COLUMN_NAME": "isOnlineOnly", "data_type": "tinyint(1)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 35, "COLUMN_NAME": "isOversized", "data_type": "tinyint(1)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 36, "COLUMN_NAME": "isPromo", "data_type": "tinyint(1)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 37, "COLUMN_NAME": "isRebalanced", "data_type": "tinyint(1)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 38, "COLUMN_NAME": "isReprint", "data_type": "tinyint(1)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 39, "COLUMN_NAME": "isReserved", "data_type": "tinyint(1)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 40, "COLUMN_NAME": "isStarter", "data_type": "tinyint(1)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 41, "COLUMN_NAME": "isStorySpotlight", "data_type": "tinyint(1)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 42, "COLUMN_NAME": "isTextless", "data_type": "tinyint(1)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 43, "COLUMN_NAME": "isTimeshifted", "data_type": "tinyint(1)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 44, "COLUMN_NAME": "keywords", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 45, "COLUMN_NAME": "language", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 46, "COLUMN_NAME": "layout", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 47, "COLUMN_NAME": "leadershipSkills", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 48, "COLUMN_NAME": "life", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 49, "COLUMN_NAME": "loyalty", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 50, "COLUMN_NAME": "manaCost", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 51, "COLUMN_NAME": "manaValue", "data_type": "float", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 52, "COLUMN_NAME": "name", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 53, "COLUMN_NAME": "number", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 54, "COLUMN_NAME": "originalPrintings", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 55, "COLUMN_NAME": "originalReleaseDate", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 56, "COLUMN_NAME": "originalText", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 57, "COLUMN_NAME": "otherFaceIds", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 58, "COLUMN_NAME": "power", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 59, "COLUMN_NAME": "printings", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 60, "COLUMN_NAME": "promoTypes", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 61, "COLUMN_NAME": "rarity", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 62, "COLUMN_NAME": "rebalancedPrintings", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 63, "COLUMN_NAME": "relatedCards", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 64, "COLUMN_NAME": "securityStamp", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 65, "COLUMN_NAME": "setCode", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 66, "COLUMN_NAME": "side", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 67, "COLUMN_NAME": "signature", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 68, "COLUMN_NAME": "sourceProducts", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 69, "COLUMN_NAME": "subsets", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 70, "COLUMN_NAME": "subtypes", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 71, "COLUMN_NAME": "supertypes", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 72, "COLUMN_NAME": "text", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 73, "COLUMN_NAME": "toughness", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 74, "COLUMN_NAME": "type", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 75, "COLUMN_NAME": "types", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 76, "COLUMN_NAME": "uuid", "data_type": "varchar(36)", "IS_NULLABLE": "NO", "COLUMN_DEFAULT": null, "COLUMN_KEY": "MUL", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 77, "COLUMN_NAME": "variations", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "cards", "ORDINAL_POSITION": 78, "COLUMN_NAME": "watermark", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "meta", "ORDINAL_POSITION": 1, "COLUMN_NAME": "id", "data_type": "int(11)", "IS_NULLABLE": "NO", "COLUMN_DEFAULT": null, "COLUMN_KEY": "PRI", "EXTRA": "auto_increment" }, { "TABLE_NAME": "meta", "ORDINAL_POSITION": 2, "COLUMN_NAME": "date", "data_type": "date", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "meta", "ORDINAL_POSITION": 3, "COLUMN_NAME": "version", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "setBoosterContents", "ORDINAL_POSITION": 1, "COLUMN_NAME": "id", "data_type": "int(11)", "IS_NULLABLE": "NO", "COLUMN_DEFAULT": null, "COLUMN_KEY": "PRI", "EXTRA": "auto_increment" }, { "TABLE_NAME": "setBoosterContents", "ORDINAL_POSITION": 2, "COLUMN_NAME": "boosterIndex", "data_type": "int(11)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "setBoosterContents", "ORDINAL_POSITION": 3, "COLUMN_NAME": "boosterName", "data_type": "varchar(255)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "setBoosterContents", "ORDINAL_POSITION": 4, "COLUMN_NAME": "setCode", "data_type": "varchar(20)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "MUL", "EXTRA": "" }, { "TABLE_NAME": "setBoosterContents", "ORDINAL_POSITION": 5, "COLUMN_NAME": "sheetName", "data_type": "varchar(255)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "setBoosterContents", "ORDINAL_POSITION": 6, "COLUMN_NAME": "sheetPicks", "data_type": "int(11)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "setBoosterContentWeights", "ORDINAL_POSITION": 1, "COLUMN_NAME": "id", "data_type": "int(11)", "IS_NULLABLE": "NO", "COLUMN_DEFAULT": null, "COLUMN_KEY": "PRI", "EXTRA": "auto_increment" }, { "TABLE_NAME": "setBoosterContentWeights", "ORDINAL_POSITION": 2, "COLUMN_NAME": "boosterIndex", "data_type": "int(11)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "setBoosterContentWeights", "ORDINAL_POSITION": 3, "COLUMN_NAME": "boosterName", "data_type": "varchar(255)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "setBoosterContentWeights", "ORDINAL_POSITION": 4, "COLUMN_NAME": "boosterWeight", "data_type": "int(11)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "setBoosterContentWeights", "ORDINAL_POSITION": 5, "COLUMN_NAME": "setCode", "data_type": "varchar(20)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "setBoosterSheetCards", "ORDINAL_POSITION": 1, "COLUMN_NAME": "id", "data_type": "int(11)", "IS_NULLABLE": "NO", "COLUMN_DEFAULT": null, "COLUMN_KEY": "PRI", "EXTRA": "auto_increment" }, { "TABLE_NAME": "setBoosterSheetCards", "ORDINAL_POSITION": 2, "COLUMN_NAME": "boosterName", "data_type": "varchar(255)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "setBoosterSheetCards", "ORDINAL_POSITION": 3, "COLUMN_NAME": "cardUuid", "data_type": "varchar(36)", "IS_NULLABLE": "NO", "COLUMN_DEFAULT": null, "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "setBoosterSheetCards", "ORDINAL_POSITION": 4, "COLUMN_NAME": "cardWeight", "data_type": "bigint(20)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "setBoosterSheetCards", "ORDINAL_POSITION": 5, "COLUMN_NAME": "setCode", "data_type": "varchar(20)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "MUL", "EXTRA": "" }, { "TABLE_NAME": "setBoosterSheetCards", "ORDINAL_POSITION": 6, "COLUMN_NAME": "sheetName", "data_type": "varchar(255)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "setBoosterSheets", "ORDINAL_POSITION": 1, "COLUMN_NAME": "id", "data_type": "int(11)", "IS_NULLABLE": "NO", "COLUMN_DEFAULT": null, "COLUMN_KEY": "PRI", "EXTRA": "auto_increment" }, { "TABLE_NAME": "setBoosterSheets", "ORDINAL_POSITION": 2, "COLUMN_NAME": "boosterName", "data_type": "varchar(255)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "setBoosterSheets", "ORDINAL_POSITION": 3, "COLUMN_NAME": "setCode", "data_type": "varchar(20)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "MUL", "EXTRA": "" }, { "TABLE_NAME": "setBoosterSheets", "ORDINAL_POSITION": 4, "COLUMN_NAME": "sheetHasBalanceColors", "data_type": "tinyint(1)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "setBoosterSheets", "ORDINAL_POSITION": 5, "COLUMN_NAME": "sheetIsFoil", "data_type": "tinyint(1)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "setBoosterSheets", "ORDINAL_POSITION": 6, "COLUMN_NAME": "sheetName", "data_type": "varchar(255)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "sets", "ORDINAL_POSITION": 1, "COLUMN_NAME": "id", "data_type": "int(11)", "IS_NULLABLE": "NO", "COLUMN_DEFAULT": null, "COLUMN_KEY": "PRI", "EXTRA": "auto_increment" }, { "TABLE_NAME": "sets", "ORDINAL_POSITION": 2, "COLUMN_NAME": "baseSetSize", "data_type": "int(11)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "sets", "ORDINAL_POSITION": 3, "COLUMN_NAME": "block", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "sets", "ORDINAL_POSITION": 4, "COLUMN_NAME": "cardsphereSetId", "data_type": "int(11)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "sets", "ORDINAL_POSITION": 5, "COLUMN_NAME": "code", "data_type": "varchar(8)", "IS_NULLABLE": "NO", "COLUMN_DEFAULT": null, "COLUMN_KEY": "UNI", "EXTRA": "" }, { "TABLE_NAME": "sets", "ORDINAL_POSITION": 6, "COLUMN_NAME": "isFoilOnly", "data_type": "tinyint(1)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "sets", "ORDINAL_POSITION": 7, "COLUMN_NAME": "isForeignOnly", "data_type": "tinyint(1)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "sets", "ORDINAL_POSITION": 8, "COLUMN_NAME": "isNonFoilOnly", "data_type": "tinyint(1)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "sets", "ORDINAL_POSITION": 9, "COLUMN_NAME": "isOnlineOnly", "data_type": "tinyint(1)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "sets", "ORDINAL_POSITION": 10, "COLUMN_NAME": "isPartialPreview", "data_type": "tinyint(1)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "sets", "ORDINAL_POSITION": 11, "COLUMN_NAME": "keyruneCode", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "sets", "ORDINAL_POSITION": 12, "COLUMN_NAME": "languages", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "sets", "ORDINAL_POSITION": 13, "COLUMN_NAME": "mcmId", "data_type": "int(11)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "sets", "ORDINAL_POSITION": 14, "COLUMN_NAME": "mcmIdExtras", "data_type": "int(11)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "sets", "ORDINAL_POSITION": 15, "COLUMN_NAME": "mcmName", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "sets", "ORDINAL_POSITION": 16, "COLUMN_NAME": "mtgoCode", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "sets", "ORDINAL_POSITION": 17, "COLUMN_NAME": "name", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "sets", "ORDINAL_POSITION": 18, "COLUMN_NAME": "parentCode", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "sets", "ORDINAL_POSITION": 19, "COLUMN_NAME": "releaseDate", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "sets", "ORDINAL_POSITION": 20, "COLUMN_NAME": "tcgplayerGroupId", "data_type": "int(11)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "sets", "ORDINAL_POSITION": 21, "COLUMN_NAME": "tokenSetCode", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "sets", "ORDINAL_POSITION": 22, "COLUMN_NAME": "totalSetSize", "data_type": "int(11)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "sets", "ORDINAL_POSITION": 23, "COLUMN_NAME": "type", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "setTranslations", "ORDINAL_POSITION": 1, "COLUMN_NAME": "id", "data_type": "int(11)", "IS_NULLABLE": "NO", "COLUMN_DEFAULT": null, "COLUMN_KEY": "PRI", "EXTRA": "auto_increment" }, { "TABLE_NAME": "setTranslations", "ORDINAL_POSITION": 2, "COLUMN_NAME": "language", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "setTranslations", "ORDINAL_POSITION": 3, "COLUMN_NAME": "setCode", "data_type": "varchar(20)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "setTranslations", "ORDINAL_POSITION": 4, "COLUMN_NAME": "translation", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokenIdentifiers", "ORDINAL_POSITION": 1, "COLUMN_NAME": "id", "data_type": "int(11)", "IS_NULLABLE": "NO", "COLUMN_DEFAULT": null, "COLUMN_KEY": "PRI", "EXTRA": "auto_increment" }, { "TABLE_NAME": "tokenIdentifiers", "ORDINAL_POSITION": 2, "COLUMN_NAME": "cardKingdomEtchedId", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokenIdentifiers", "ORDINAL_POSITION": 3, "COLUMN_NAME": "cardKingdomFoilId", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokenIdentifiers", "ORDINAL_POSITION": 4, "COLUMN_NAME": "cardKingdomId", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokenIdentifiers", "ORDINAL_POSITION": 5, "COLUMN_NAME": "cardsphereFoilId", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokenIdentifiers", "ORDINAL_POSITION": 6, "COLUMN_NAME": "cardsphereId", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokenIdentifiers", "ORDINAL_POSITION": 7, "COLUMN_NAME": "deckboxId", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokenIdentifiers", "ORDINAL_POSITION": 8, "COLUMN_NAME": "mcmId", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokenIdentifiers", "ORDINAL_POSITION": 9, "COLUMN_NAME": "mcmMetaId", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokenIdentifiers", "ORDINAL_POSITION": 10, "COLUMN_NAME": "mtgArenaId", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokenIdentifiers", "ORDINAL_POSITION": 11, "COLUMN_NAME": "mtgjsonFoilVersionId", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokenIdentifiers", "ORDINAL_POSITION": 12, "COLUMN_NAME": "mtgjsonNonFoilVersionId", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokenIdentifiers", "ORDINAL_POSITION": 13, "COLUMN_NAME": "mtgjsonV4Id", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokenIdentifiers", "ORDINAL_POSITION": 14, "COLUMN_NAME": "mtgoFoilId", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokenIdentifiers", "ORDINAL_POSITION": 15, "COLUMN_NAME": "mtgoId", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokenIdentifiers", "ORDINAL_POSITION": 16, "COLUMN_NAME": "multiverseId", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokenIdentifiers", "ORDINAL_POSITION": 17, "COLUMN_NAME": "scryfallCardBackId", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokenIdentifiers", "ORDINAL_POSITION": 18, "COLUMN_NAME": "scryfallId", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokenIdentifiers", "ORDINAL_POSITION": 19, "COLUMN_NAME": "scryfallIllustrationId", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokenIdentifiers", "ORDINAL_POSITION": 20, "COLUMN_NAME": "scryfallOracleId", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokenIdentifiers", "ORDINAL_POSITION": 21, "COLUMN_NAME": "tcgplayerEtchedProductId", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokenIdentifiers", "ORDINAL_POSITION": 22, "COLUMN_NAME": "tcgplayerProductId", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokenIdentifiers", "ORDINAL_POSITION": 23, "COLUMN_NAME": "uuid", "data_type": "varchar(36)", "IS_NULLABLE": "NO", "COLUMN_DEFAULT": null, "COLUMN_KEY": "MUL", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 1, "COLUMN_NAME": "id", "data_type": "int(11)", "IS_NULLABLE": "NO", "COLUMN_DEFAULT": null, "COLUMN_KEY": "PRI", "EXTRA": "auto_increment" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 2, "COLUMN_NAME": "artist", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 3, "COLUMN_NAME": "artistIds", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 4, "COLUMN_NAME": "asciiName", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 5, "COLUMN_NAME": "availability", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 6, "COLUMN_NAME": "boosterTypes", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 7, "COLUMN_NAME": "borderColor", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 8, "COLUMN_NAME": "colorIdentity", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 9, "COLUMN_NAME": "colors", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 10, "COLUMN_NAME": "edhrecSaltiness", "data_type": "float", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 11, "COLUMN_NAME": "faceName", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 12, "COLUMN_NAME": "finishes", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 13, "COLUMN_NAME": "flavorName", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 14, "COLUMN_NAME": "flavorText", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 15, "COLUMN_NAME": "frameEffects", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 16, "COLUMN_NAME": "frameVersion", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 17, "COLUMN_NAME": "hasFoil", "data_type": "tinyint(1)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 18, "COLUMN_NAME": "hasNonFoil", "data_type": "tinyint(1)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 19, "COLUMN_NAME": "isFullArt", "data_type": "tinyint(1)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 20, "COLUMN_NAME": "isFunny", "data_type": "tinyint(1)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 21, "COLUMN_NAME": "isOversized", "data_type": "tinyint(1)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 22, "COLUMN_NAME": "isPromo", "data_type": "tinyint(1)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 23, "COLUMN_NAME": "isReprint", "data_type": "tinyint(1)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 24, "COLUMN_NAME": "isTextless", "data_type": "tinyint(1)", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 25, "COLUMN_NAME": "keywords", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 26, "COLUMN_NAME": "language", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 27, "COLUMN_NAME": "layout", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 28, "COLUMN_NAME": "manaCost", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 29, "COLUMN_NAME": "name", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 30, "COLUMN_NAME": "number", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 31, "COLUMN_NAME": "orientation", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 32, "COLUMN_NAME": "originalText", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 33, "COLUMN_NAME": "otherFaceIds", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 34, "COLUMN_NAME": "power", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 35, "COLUMN_NAME": "promoTypes", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 36, "COLUMN_NAME": "relatedCards", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 37, "COLUMN_NAME": "reverseRelated", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 38, "COLUMN_NAME": "securityStamp", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 39, "COLUMN_NAME": "setCode", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 40, "COLUMN_NAME": "side", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 41, "COLUMN_NAME": "signature", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 42, "COLUMN_NAME": "subtypes", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 43, "COLUMN_NAME": "supertypes", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 44, "COLUMN_NAME": "text", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 45, "COLUMN_NAME": "toughness", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 46, "COLUMN_NAME": "type", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 47, "COLUMN_NAME": "types", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 48, "COLUMN_NAME": "uuid", "data_type": "varchar(36)", "IS_NULLABLE": "NO", "COLUMN_DEFAULT": null, "COLUMN_KEY": "MUL", "EXTRA": "" }, { "TABLE_NAME": "tokens", "ORDINAL_POSITION": 49, "COLUMN_NAME": "watermark", "data_type": "text", "IS_NULLABLE": "YES", "COLUMN_DEFAULT": "NULL", "COLUMN_KEY": "", "EXTRA": "" } ] }