← Back to index

Schema Columns for mspdevco_deckbuildercouk

Tables: 15
Download JSON
Using current DB (via DATABASE()). Add ?schema=your_schema to override.

cardForeignData

Columns: 10 First row → Top 10 →
# Column Type Null Default Key Extra
1 id int(11) NO 
NULL
 PRI auto_increment
2 faceName text YES 
NULL
3 flavorText text YES 
NULL
4 identifiers text YES 
NULL
5 language text YES 
NULL
6 multiverseId int(11) YES 
NULL
7 name text YES 
NULL
8 text text YES 
NULL
9 type text YES 
NULL
10 uuid varchar(36) NO 
NULL
 MUL

cardIdentifiers

Columns: 23 First row → Top 10 →
# Column Type Null Default Key Extra
1 id int(11) NO 
NULL
 PRI auto_increment
2 cardKingdomEtchedId text YES 
NULL
3 cardKingdomFoilId text YES 
NULL
4 cardKingdomId text YES 
NULL
5 cardsphereFoilId text YES 
NULL
6 cardsphereId text YES 
NULL
7 deckboxId text YES 
NULL
8 mcmId text YES 
NULL
9 mcmMetaId text YES 
NULL
10 mtgArenaId text YES 
NULL
11 mtgjsonFoilVersionId text YES 
NULL
12 mtgjsonNonFoilVersionId text YES 
NULL
13 mtgjsonV4Id text YES 
NULL
14 mtgoFoilId text YES 
NULL
15 mtgoId text YES 
NULL
16 multiverseId text YES 
NULL
17 scryfallCardBackId text YES 
NULL
18 scryfallId text YES 
NULL
19 scryfallIllustrationId text YES 
NULL
20 scryfallOracleId text YES 
NULL
21 tcgplayerEtchedProductId text YES 
NULL
22 tcgplayerProductId text YES 
NULL
23 uuid varchar(36) NO 
NULL
 MUL

cardLegalities

Columns: 23 First row → Top 10 →
# Column Type Null Default Key Extra
1 id int(11) NO 
NULL
 PRI auto_increment
2 alchemy text YES 
NULL
3 brawl text YES 
NULL
4 commander text YES 
NULL
5 duel text YES 
NULL
6 future text YES 
NULL
7 gladiator text YES 
NULL
8 historic text YES 
NULL
9 legacy text YES 
NULL
10 modern text YES 
NULL
11 oathbreaker text YES 
NULL
12 oldschool text YES 
NULL
13 pauper text YES 
NULL
14 paupercommander text YES 
NULL
15 penny text YES 
NULL
16 pioneer text YES 
NULL
17 predh text YES 
NULL
18 premodern text YES 
NULL
19 standard text YES 
NULL
20 standardbrawl text YES 
NULL
21 timeless text YES 
NULL
22 uuid varchar(36) NO 
NULL
 MUL
23 vintage text YES 
NULL

cardPurchaseUrls

Columns: 8 First row → Top 10 →
# Column Type Null Default Key Extra
1 id int(11) NO 
NULL
 PRI auto_increment
2 cardKingdom text YES 
NULL
3 cardKingdomEtched text YES 
NULL
4 cardKingdomFoil text YES 
NULL
5 cardmarket text YES 
NULL
6 tcgplayer text YES 
NULL
7 tcgplayerEtched text YES 
NULL
8 uuid varchar(36) NO 
NULL
 MUL

cardRulings

Columns: 4 First row → Top 10 →
# Column Type Null Default Key Extra
1 id int(11) NO 
NULL
 PRI auto_increment
2 date date YES 
NULL
3 text text YES 
NULL
4 uuid varchar(36) NO 
NULL
 MUL

cards

Columns: 78 First row → Top 10 →
# Column Type Null Default Key Extra
1 id int(11) NO 
NULL
 PRI auto_increment
2 artist text YES 
NULL
3 artistIds text YES 
NULL
4 asciiName text YES 
NULL
5 attractionLights text YES 
NULL
6 availability text YES 
NULL
7 boosterTypes text YES 
NULL
8 borderColor text YES 
NULL
9 colorIdentity text YES 
NULL
10 colorIndicator text YES 
NULL
11 colors text YES 
NULL
12 defense text YES 
NULL
13 duelDeck text YES 
NULL
14 edhrecRank int(11) YES 
NULL
15 edhrecSaltiness float YES 
NULL
16 faceConvertedManaCost float YES 
NULL
17 faceFlavorName text YES 
NULL
18 faceManaValue float YES 
NULL
19 faceName text YES 
NULL
20 finishes text YES 
NULL
21 flavorName text YES 
NULL
22 flavorText text YES 
NULL
23 frameEffects text YES 
NULL
24 frameVersion text YES 
NULL
25 hand text YES 
NULL
26 hasAlternativeDeckLimit tinyint(1) YES 
NULL
27 hasContentWarning tinyint(1) YES 
NULL
28 hasFoil tinyint(1) YES 
NULL
29 hasNonFoil tinyint(1) YES 
NULL
30 isAlternative tinyint(1) YES 
NULL
31 isFullArt tinyint(1) YES 
NULL
32 isFunny tinyint(1) YES 
NULL
33 isGameChanger tinyint(1) YES 
NULL
34 isOnlineOnly tinyint(1) YES 
NULL
35 isOversized tinyint(1) YES 
NULL
36 isPromo tinyint(1) YES 
NULL
37 isRebalanced tinyint(1) YES 
NULL
38 isReprint tinyint(1) YES 
NULL
39 isReserved tinyint(1) YES 
NULL
40 isStarter tinyint(1) YES 
NULL
41 isStorySpotlight tinyint(1) YES 
NULL
42 isTextless tinyint(1) YES 
NULL
43 isTimeshifted tinyint(1) YES 
NULL
44 keywords text YES 
NULL
45 language text YES 
NULL
46 layout text YES 
NULL
47 leadershipSkills text YES 
NULL
48 life text YES 
NULL
49 loyalty text YES 
NULL
50 manaCost text YES 
NULL
51 manaValue float YES 
NULL
52 name text YES 
NULL
53 number text YES 
NULL
54 originalPrintings text YES 
NULL
55 originalReleaseDate text YES 
NULL
56 originalText text YES 
NULL
57 otherFaceIds text YES 
NULL
58 power text YES 
NULL
59 printings text YES 
NULL
60 promoTypes text YES 
NULL
61 rarity text YES 
NULL
62 rebalancedPrintings text YES 
NULL
63 relatedCards text YES 
NULL
64 securityStamp text YES 
NULL
65 setCode text YES 
NULL
66 side text YES 
NULL
67 signature text YES 
NULL
68 sourceProducts text YES 
NULL
69 subsets text YES 
NULL
70 subtypes text YES 
NULL
71 supertypes text YES 
NULL
72 text text YES 
NULL
73 toughness text YES 
NULL
74 type text YES 
NULL
75 types text YES 
NULL
76 uuid varchar(36) NO 
NULL
 MUL
77 variations text YES 
NULL
78 watermark text YES 
NULL

meta

Columns: 3 First row → Top 10 →
# Column Type Null Default Key Extra
1 id int(11) NO 
NULL
 PRI auto_increment
2 date date YES 
NULL
3 version text YES 
NULL

setBoosterContents

Columns: 6 First row → Top 10 →
# Column Type Null Default Key Extra
1 id int(11) NO 
NULL
 PRI auto_increment
2 boosterIndex int(11) YES 
NULL
3 boosterName varchar(255) YES 
NULL
4 setCode varchar(20) YES 
NULL
 MUL
5 sheetName varchar(255) YES 
NULL
6 sheetPicks int(11) YES 
NULL

setBoosterContentWeights

Columns: 5 First row → Top 10 →
# Column Type Null Default Key Extra
1 id int(11) NO 
NULL
 PRI auto_increment
2 boosterIndex int(11) YES 
NULL
3 boosterName varchar(255) YES 
NULL
4 boosterWeight int(11) YES 
NULL
5 setCode varchar(20) YES 
NULL

setBoosterSheetCards

Columns: 6 First row → Top 10 →
# Column Type Null Default Key Extra
1 id int(11) NO 
NULL
 PRI auto_increment
2 boosterName varchar(255) YES 
NULL
3 cardUuid varchar(36) NO 
NULL
4 cardWeight bigint(20) YES 
NULL
5 setCode varchar(20) YES 
NULL
 MUL
6 sheetName varchar(255) YES 
NULL

setBoosterSheets

Columns: 6 First row → Top 10 →
# Column Type Null Default Key Extra
1 id int(11) NO 
NULL
 PRI auto_increment
2 boosterName varchar(255) YES 
NULL
3 setCode varchar(20) YES 
NULL
 MUL
4 sheetHasBalanceColors tinyint(1) YES 
NULL
5 sheetIsFoil tinyint(1) YES 
NULL
6 sheetName varchar(255) YES 
NULL

sets

Columns: 23 First row → Top 10 →
# Column Type Null Default Key Extra
1 id int(11) NO 
NULL
 PRI auto_increment
2 baseSetSize int(11) YES 
NULL
3 block text YES 
NULL
4 cardsphereSetId int(11) YES 
NULL
5 code varchar(8) NO 
NULL
 UNI
6 isFoilOnly tinyint(1) YES 
NULL
7 isForeignOnly tinyint(1) YES 
NULL
8 isNonFoilOnly tinyint(1) YES 
NULL
9 isOnlineOnly tinyint(1) YES 
NULL
10 isPartialPreview tinyint(1) YES 
NULL
11 keyruneCode text YES 
NULL
12 languages text YES 
NULL
13 mcmId int(11) YES 
NULL
14 mcmIdExtras int(11) YES 
NULL
15 mcmName text YES 
NULL
16 mtgoCode text YES 
NULL
17 name text YES 
NULL
18 parentCode text YES 
NULL
19 releaseDate text YES 
NULL
20 tcgplayerGroupId int(11) YES 
NULL
21 tokenSetCode text YES 
NULL
22 totalSetSize int(11) YES 
NULL
23 type text YES 
NULL

setTranslations

Columns: 4 First row → Top 10 →
# Column Type Null Default Key Extra
1 id int(11) NO 
NULL
 PRI auto_increment
2 language text YES 
NULL
3 setCode varchar(20) YES 
NULL
4 translation text YES 
NULL

tokenIdentifiers

Columns: 23 First row → Top 10 →
# Column Type Null Default Key Extra
1 id int(11) NO 
NULL
 PRI auto_increment
2 cardKingdomEtchedId text YES 
NULL
3 cardKingdomFoilId text YES 
NULL
4 cardKingdomId text YES 
NULL
5 cardsphereFoilId text YES 
NULL
6 cardsphereId text YES 
NULL
7 deckboxId text YES 
NULL
8 mcmId text YES 
NULL
9 mcmMetaId text YES 
NULL
10 mtgArenaId text YES 
NULL
11 mtgjsonFoilVersionId text YES 
NULL
12 mtgjsonNonFoilVersionId text YES 
NULL
13 mtgjsonV4Id text YES 
NULL
14 mtgoFoilId text YES 
NULL
15 mtgoId text YES 
NULL
16 multiverseId text YES 
NULL
17 scryfallCardBackId text YES 
NULL
18 scryfallId text YES 
NULL
19 scryfallIllustrationId text YES 
NULL
20 scryfallOracleId text YES 
NULL
21 tcgplayerEtchedProductId text YES 
NULL
22 tcgplayerProductId text YES 
NULL
23 uuid varchar(36) NO 
NULL
 MUL

tokens

Columns: 49 First row → Top 10 →
# Column Type Null Default Key Extra
1 id int(11) NO 
NULL
 PRI auto_increment
2 artist text YES 
NULL
3 artistIds text YES 
NULL
4 asciiName text YES 
NULL
5 availability text YES 
NULL
6 boosterTypes text YES 
NULL
7 borderColor text YES 
NULL
8 colorIdentity text YES 
NULL
9 colors text YES 
NULL
10 edhrecSaltiness float YES 
NULL
11 faceName text YES 
NULL
12 finishes text YES 
NULL
13 flavorName text YES 
NULL
14 flavorText text YES 
NULL
15 frameEffects text YES 
NULL
16 frameVersion text YES 
NULL
17 hasFoil tinyint(1) YES 
NULL
18 hasNonFoil tinyint(1) YES 
NULL
19 isFullArt tinyint(1) YES 
NULL
20 isFunny tinyint(1) YES 
NULL
21 isOversized tinyint(1) YES 
NULL
22 isPromo tinyint(1) YES 
NULL
23 isReprint tinyint(1) YES 
NULL
24 isTextless tinyint(1) YES 
NULL
25 keywords text YES 
NULL
26 language text YES 
NULL
27 layout text YES 
NULL
28 manaCost text YES 
NULL
29 name text YES 
NULL
30 number text YES 
NULL
31 orientation text YES 
NULL
32 originalText text YES 
NULL
33 otherFaceIds text YES 
NULL
34 power text YES 
NULL
35 promoTypes text YES 
NULL
36 relatedCards text YES 
NULL
37 reverseRelated text YES 
NULL
38 securityStamp text YES 
NULL
39 setCode text YES 
NULL
40 side text YES 
NULL
41 signature text YES 
NULL
42 subtypes text YES 
NULL
43 supertypes text YES 
NULL
44 text text YES 
NULL
45 toughness text YES 
NULL
46 type text YES 
NULL
47 types text YES 
NULL
48 uuid varchar(36) NO 
NULL
 MUL
49 watermark text YES 
NULL