RuihanCao/bird-dev-corrected

1{2    "california_schools": " CREATE TABLE main.frpm (\n CDSCode text, -- example: ['01100170109835', '01100170112607', '01100170118489'],\n Academic Year text, -- example: ['2014-2015'],\n County Code text, -- example: ['01', '02', '03'],\n District Code integer, -- example: [10017, 31609, 31617],\n School Code text, -- example: ['0109835', '0112607', '0118489'],\n County Name text, -- example: ['Alameda', 'Alpine', 'Amador'],\n District Name text, -- example: ['Alameda County Office of Education', 'California School for the Blind (State Special Sch...', 'California School for the Deaf-Fremont (State Spec...'],\n School Name text, -- example: ['FAME Public Charter', 'Envision Academy for Arts & Technology', 'Aspire California College Preparatory Academy'],\n District Type text, -- example: ['County Office of Education (COE)', 'State Special Schools', 'Unified School District'],\n School Type text, -- example: ['K-12 Schools (Public)', 'High Schools (Public)', 'Elementary Schools (Public)'],\n Educational Option Type text, -- example: ['Traditional', 'Juvenile Court School', 'County Community School'],\n NSLP Provision Status text, -- example: ['Breakfast Provision 2', 'Provision 2', 'CEP'],\n Charter School (Y/N) integer, -- example: [1, 0],\n Charter School Number text, -- example: ['0728', '0811', '1049'],\n Charter Funding Type text, -- example: ['Directly funded', 'Locally funded', 'Not in CS funding model'],\n IRC integer, -- example: [1, 0],\n Low Grade text, -- example: ['K', '9', '1'],\n High Grade text, -- example: ['12', '8', '5'],\n Enrollment (K-12) real, -- example: [1087.0, 395.0, 244.0],\n Free Meal Count (K-12) real, -- example: [565.0, 186.0, 134.0],\n Percent (%) Eligible Free (K-12) real, -- example: [0.519779208831647, 0.470886075949367, 0.549180327868853],\n FRPM Count (K-12) real, -- example: [715.0, 186.0, 175.0],\n Percent (%) Eligible FRPM (K-12) real, -- example: [0.657773689052438, 0.470886075949367, 0.717213114754098],\n Enrollment (Ages 5-17) real, -- example: [1070.0, 376.0, 230.0],\n Free Meal Count (Ages 5-17) real, -- example: [553.0, 182.0, 128.0],\n Percent (%) Eligible Free (Ages 5-17) real, -- example: [0.516822429906542, 0.484042553191489, 0.556521739130435],\n FRPM Count (Ages 5-17) real, -- example: [702.0, 182.0, 168.0],\n Percent (%) Eligible FRPM (Ages 5-17) real, -- example: [0.65607476635514, 0.484042553191489, 0.730434782608696],\n 2013-14 CALPADS Fall 1 Certification Status integer, -- example: [1],\n PRIMARY KEY (CDSCode),\n CONSTRAINT fk_main_frpm_CDSCode FOREIGN KEY (CDSCode) REFERENCES schools (CDSCode)\n );\n CREATE TABLE main.satscores (\n cds text, -- example: ['01611760135244', '10101080000000', '10101080109991'],\n rtype text, -- example: ['D', 'S'],\n sname text, -- example: ['FAME Public Charter', 'Envision Academy for Arts & Technology', 'Aspire California College Preparatory Academy'],\n dname text, -- example: ['Alameda County Office of Education', 'Alameda Unified', 'Albany City Unified'],\n cname text, -- example: ['Alameda', 'Amador', 'Butte'],\n enroll12 integer, -- example: [398, 62, 75],\n NumTstTakr integer, -- example: [88, 17, 71],\n AvgScrRead integer, -- example: [418, 503, 397],\n AvgScrMath integer, -- example: [418, 546, 387],\n AvgScrWrite integer, -- example: [417, 505, 395],\n NumGE1500 integer, -- example: [14, 9, 5],\n PRIMARY KEY (cds),\n CONSTRAINT fk_main_satscores_cds FOREIGN KEY (cds) REFERENCES schools (CDSCode)\n );\n CREATE TABLE main.schools (\n CDSCode text, -- example: ['01100170000000', '01100170109835', '01100170112607'],\n NCESDist text, -- example: ['0691051', '0600002', '0600003'],\n NCESSchool text, -- example: ['10546', '10947', '12283'],\n StatusType text, -- example: ['Active', 'Closed', 'Merged'],\n County text, -- example: ['Alameda', 'Alpine', 'Amador'],\n District text, -- example: ['Alameda County Office of Education', 'California School for the Blind (State Special Sch...', 'California School for the Deaf-Fremont (State Spec...'],\n School text, -- example: ['FAME Public Charter', 'Envision Academy for Arts & Technology', 'Aspire California College Preparatory Academy'],\n Street text, -- example: ['313 West Winton Avenue', '39899 Balentine Drive, Suite 335', '1515 Webster Street'],\n StreetAbr text, -- example: ['313 West Winton Ave.', '39899 Balentine Dr., Ste. 335', '1515 Webster St.'],\n City text, -- example: ['Hayward', 'Newark', 'Oakland'],\n Zip text, -- example: ['94544-1136', '94560-5359', '94612-3355'],\n State text, -- example: ['CA'],\n MailStreet text, -- example: ['313 West Winton Avenue', '39899 Balentine Drive, Suite 335', '1515 Webster Street'],\n MailStrAbr text, -- example: ['313 West Winton Ave.', '39899 Balentine Dr., Ste. 335', '1515 Webster St.'],\n MailCity text, -- example: ['Hayward', 'Newark', 'Oakland'],\n MailZip text, -- example: ['94544-1136', '94560-5359', '94612'],\n MailState text, -- example: ['CA'],\n Phone text, -- example: ['(510) 887-0152', '(510) 596-8901', '(510) 686-4131'],\n Ext text, -- example: ['130', '1240', '1200'],\n Website text, -- example: ['www.acoe.org', 'www.envisionacademy.org/', 'www.aspirepublicschools.org'],\n OpenDate date, -- example: ['2005-08-29'],\n ClosedDate date, -- example: ['2015-07-31'],\n Charter integer, -- example: [1, 0],\n CharterNum text, -- example: ['0728', '0811', '1049'],\n FundingType text, -- example: ['Directly funded', 'Locally funded', 'Not in CS funding model'],\n DOC text, -- example: ['00', '31', '34'],\n DOCType text, -- example: ['County Office of Education (COE)', 'State Special Schools', 'Non-School Locations'],\n SOC text, -- example: ['65', '66', '60'],\n SOCType text, -- example: ['K-12 Schools (Public)', 'High Schools (Public)', 'Elementary Schools (Public)'],\n EdOpsCode text, -- example: ['TRAD', 'JUV', 'COMM'],\n EdOpsName text, -- example: ['Traditional', 'Juvenile Court School', 'County Community School'],\n EILCode text, -- example: ['ELEMHIGH', 'HS', 'ELEM'],\n EILName text, -- example: ['Elementary-High Combination', 'High School', 'Elementary'],\n GSoffered text, -- example: ['K-12', '9-12', 'K-8'],\n GSserved text, -- example: ['K-12', '9-12', 'K-7'],\n Virtual text, -- example: ['P', 'N', 'F'],\n Magnet integer, -- example: [0, 1],\n Latitude real, -- example: [37.658212, 37.521436, 37.80452],\n Longitude real, -- example: ['-122.09713', '-121.99391', '-122.26815'],\n AdmFName1 text, -- example: ['L Karen', 'Laura', 'Clifford'],\n AdmLName1 text, -- example: ['Monroe', 'Robell', 'Thompson'],\n AdmEmail1 text,\n AdmFName2 text, -- example: ['Sau-Lim (Lance)', 'Jennifer', 'Annalisa'],\n AdmLName2 text, -- example: ['Tsang', 'Koelling', 'Moore'],\n AdmEmail2 text,\n AdmFName3 text, -- example: ['Drew', 'Irma', 'Vickie'],\n AdmLName3 text, -- example: ['Sarratore', 'Munoz', 'Chang'],\n AdmEmail3 text,\n LastUpdate date, -- example: ['2015-06-23'],\n PRIMARY KEY (CDSCode)\n );",3    "financial": " CREATE TABLE main.account (\n account_id integer, -- example: [1, 2, 3],\n district_id integer, -- example: [18, 1, 5],\n frequency text, -- example: ['POPLATEK MESICNE', 'POPLATEK TYDNE', 'POPLATEK PO OBRATU'],\n date date, -- example: ['1995-03-24'],\n PRIMARY KEY (account_id),\n CONSTRAINT fk_main_account_district_id FOREIGN KEY (district_id) REFERENCES district (district_id)\n );\n CREATE TABLE main.card (\n card_id integer, -- example: [1, 2, 3],\n disp_id integer, -- example: [9, 19, 41],\n type text, -- example: ['gold', 'classic', 'junior'],\n issued date, -- example: ['1998-10-16'],\n PRIMARY KEY (card_id),\n CONSTRAINT fk_main_card_disp_id FOREIGN KEY (disp_id) REFERENCES disp (disp_id)\n );\n CREATE TABLE main.client (\n client_id integer, -- example: [1, 2, 3],\n gender text, -- example: ['F', 'M'],\n birth_date date, -- example: ['1970-12-13'],\n district_id integer, -- example: [18, 1, 5],\n PRIMARY KEY (client_id),\n CONSTRAINT fk_main_client_district_id FOREIGN KEY (district_id) REFERENCES district (district_id)\n );\n CREATE TABLE main.disp (\n disp_id integer, -- example: [1, 2, 3],\n client_id integer, -- example: [1, 2, 3],\n account_id integer, -- example: [1, 2, 3],\n type text, -- example: ['OWNER', 'DISPONENT', 'test'],\n PRIMARY KEY (disp_id),\n CONSTRAINT fk_main_disp_account_id FOREIGN KEY (account_id) REFERENCES account (account_id),\n CONSTRAINT fk_main_disp_client_id FOREIGN KEY (client_id) REFERENCES client (client_id)\n );\n CREATE TABLE main.district (\n district_id integer, -- example: [1, 2, 3],\n A2 text, -- example: ['Hl.m. Praha', 'Benesov', 'Beroun'],\n A3 text, -- example: ['Prague', 'central Bohemia', 'south Bohemia'],\n A4 text, -- example: ['1204953', '88884', '75232'],\n A5 text, -- example: ['0', '80', '55'],\n A6 text, -- example: ['0', '26', '29'],\n A7 text, -- example: ['0', '6', '4'],\n A8 integer, -- example: [1, 2, 3],\n A9 integer, -- example: [1, 5, 6],\n A10 real, -- example: [100.0, 46.7, 41.7],\n A11 integer, -- example: [12541, 8507, 8980],\n A12 real, -- example: [0.2, 1.6, 1.9],\n A13 real, -- example: [0.43, 1.85, 2.21],\n A14 integer, -- example: [167, 132, 111],\n A15 integer, -- example: [85677, 2159, 2824],\n A16 integer, -- example: [99107, 2674, 2813],\n PRIMARY KEY (district_id)\n );\n CREATE TABLE main.loan (\n loan_id integer, -- example: [4959, 4961, 4962],\n account_id integer, -- example: [2, 19, 25],\n date date, -- example: ['1994-01-05'],\n amount integer, -- example: [80952, 30276, 318480],\n duration integer, -- example: [24, 12, 60],\n payments real, -- example: [3373.0, 2523.0, 5308.0],\n status text, -- example: ['A', 'B', 'D'],\n PRIMARY KEY (loan_id),\n CONSTRAINT fk_main_loan_account_id FOREIGN KEY (account_id) REFERENCES account (account_id)\n );\n CREATE TABLE main.order (\n order_id integer, -- example: [29401, 29402, 29403],\n account_id integer, -- example: [1, 2, 3],\n bank_to text, -- example: ['YZ', 'ST', 'QR'],\n account_to integer, -- example: [87144583, 89597016, 13943797],\n amount real, -- example: [2452.0, 3372.7, 7266.0],\n k_symbol text, -- example: ['SIPO', 'UVER', 'POJISTNE'],\n PRIMARY KEY (order_id),\n CONSTRAINT fk_main_order_account_id FOREIGN KEY (account_id) REFERENCES account (account_id)\n );\n CREATE TABLE main.trans (\n trans_id integer, -- example: [1, 5, 6],\n account_id integer, -- example: [1, 2, 3],\n date date, -- example: ['1995-03-24'],\n type text, -- example: ['PRIJEM', 'VYDAJ', 'VYBER'],\n operation text, -- example: ['VKLAD', 'PREVOD Z UCTU', 'PREVOD NA UCET'],\n amount integer, -- example: [1000, 3679, 2452],\n balance integer, -- example: [1000, 4679, 20977],\n k_symbol text, -- example: ['SIPO', 'SLUZBY', 'UVER'],\n bank text, -- example: ['AB', 'YZ', 'ST'],\n account integer, -- example: [41403269, 87144583, 66487163],\n PRIMARY KEY (trans_id),\n CONSTRAINT fk_main_trans_account_id FOREIGN KEY (account_id) REFERENCES account (account_id)\n );",4    "toxicology": " CREATE TABLE main.atom (\n atom_id text, -- example: ['TR000_1', 'TR000_2', 'TR000_3'],\n molecule_id text, -- example: ['TR000', 'TR001', 'TR002'],\n element text, -- example: ['cl', 'c', 'h'],\n PRIMARY KEY (atom_id),\n CONSTRAINT fk_main_atom_molecule_id FOREIGN KEY (molecule_id) REFERENCES molecule (molecule_id)\n );\n CREATE TABLE main.bond (\n bond_id text, -- example: ['TR000_1_2', 'TR000_2_3', 'TR000_2_4'],\n molecule_id text, -- example: ['TR000', 'TR001', 'TR002'],\n bond_type text, -- example: ['-', '=', '#'],\n PRIMARY KEY (bond_id),\n CONSTRAINT fk_main_bond_molecule_id FOREIGN KEY (molecule_id) REFERENCES molecule (molecule_id)\n );\n CREATE TABLE main.connected (\n atom_id text, -- example: ['TR000_1', 'TR000_2', 'TR000_3'],\n atom_id2 text, -- example: ['TR000_2', 'TR000_1', 'TR000_3'],\n bond_id text, -- example: ['TR000_1_2', 'TR000_2_3', 'TR000_2_4'],\n PRIMARY KEY (atom_id, atom_id2),\n CONSTRAINT fk_main_connected_bond_id FOREIGN KEY (bond_id) REFERENCES bond (bond_id),\n CONSTRAINT fk_main_connected_atom_id2 FOREIGN KEY (atom_id2) REFERENCES atom (atom_id),\n CONSTRAINT fk_main_connected_atom_id FOREIGN KEY (atom_id) REFERENCES atom (atom_id)\n );\n CREATE TABLE main.molecule (\n molecule_id text, -- example: ['TR000', 'TR001', 'TR002'],\n label text, -- example: ['+', '-'],\n PRIMARY KEY (molecule_id)\n );",5    "card_games": " CREATE TABLE main.cards (\n id integer, -- example: [41138, 1349, 23810],\n artist text, -- example: ['Pete Venters', 'Volkan Ba\u01f5a', 'Justin Sweet'],\n asciiName text, -- example: ['El-Hajjaj', 'Junun Efreet', 'Dandan'],\n availability text, -- example: ['mtgo,paper', 'paper', 'arena'],\n borderColor text, -- example: ['black', 'white', 'borderless'],\n cardKingdomFoilId text, -- example: ['123094', '123095', '123096'],\n cardKingdomId text, -- example: ['122719', '122720', '122725'],\n colorIdentity text, -- example: ['W', 'B', 'U'],\n colorIndicator text, -- example: ['U', 'G', 'R'],\n colors text, -- example: ['W', 'B', 'U'],\n convertedManaCost real, -- example: [7.0, 5.0, 4.0],\n duelDeck text, -- example: ['a', 'b'],\n edhrecRank integer, -- example: [15650, 12702, 11081],\n faceConvertedManaCost real, -- example: [4.0, 5.0, 6.0],\n faceName text, -- example: ['Dusk', 'Dawn', 'Commit'],\n flavorName text, -- example: ['Godzilla, King of the Monsters', 'King Caesar, Ancient Guardian', 'Mothra, Supersonic Queen'],\n flavorText text, -- example: ['Every tear shed is a drop of immortality.', 'The perfect antidote for a tightly packed formatio...', 'Life is measured in inches. To a healer, every one...'],\n frameEffects text, -- example: ['legendary', 'nyxtouched', 'miracle'],\n frameVersion text, -- example: ['2003', '1993', '2015'],\n hand text, -- example: ['1', '0', '-2'],\n hasAlternativeDeckLimit integer, -- example: [0, 1],\n hasContentWarning integer, -- example: [0, 1],\n hasFoil integer, -- example: [0, 1],\n hasNonFoil integer, -- example: [1, 0],\n isAlternative integer, -- example: [0, 1],\n isFullArt integer, -- example: [0, 1],\n isOnlineOnly integer, -- example: [0, 1],\n isOversized integer, -- example: [0, 1],\n isPromo integer, -- example: [0, 1],\n isReprint integer, -- example: [1, 0],\n isReserved integer, -- example: [0, 1],\n isStarter integer, -- example: [0, 1],\n isStorySpotlight integer, -- example: [0, 1],\n isTextless integer, -- example: [0, 1],\n isTimeshifted integer, -- example: [0, 1],\n keywords text, -- example: ['First strike', 'Flying', 'First strike,Flash'],\n layout text, -- example: ['normal', 'aftermath', 'split'],\n leadershipSkills text, -- example: ['{'brawl': False, 'commander': True, 'oathbreaker':...', '{'brawl': False, 'commander': False, 'oathbreaker'...', '{'brawl': False, 'commander': True, 'oathbreaker':...'],\n life text, -- example: ['-5', '-1', '2'],\n loyalty text, -- example: ['6', '3', '4'],\n manaCost text, -- example: ['{5}{W}{W}', '{4}{W}', '{3}{W}'],\n mcmId text, -- example: ['16165', '16166', '16171'],\n mcmMetaId text, -- example: ['156', '176', '368'],\n mtgArenaId text, -- example: ['74983', '74986', '74987'],\n mtgjsonV4Id text, -- example: ['ad41be73-582f-58ed-abd4-a88c1f616ac3', '9eb2e54c-a12b-5e88-a9c0-d8c84c52d59c', 'c0de6fd8-367a-50fb-b2f4-2b8fa5aeb7d9'],\n mtgoFoilId text, -- example: ['27501', '26993', '27473'],\n mtgoId text, -- example: ['27500', '26992', '27472'],\n multiverseId text, -- example: ['130550', '129465', '129470'],\n name text, -- example: ['Ancestor's Chosen', 'Angel of Mercy', 'Aven Cloudchaser'],\n number text, -- example: ['1', '2', '7'],\n originalReleaseDate text, -- example: ['2012/12/1', '2006/12/1', '2007/12/1'],\n originalText text, -- example: ['First strike (This creature deals combat damage be...', 'Flying (This creature can't be blocked except by c...', 'Flying (This creature can't be blocked except by c...'],\n originalType text, -- example: ['Creature - Human Cleric', 'Creature - Angel', 'Creature - Bird Soldier'],\n otherFaceIds text, -- example: ['87f0062a-8321-5c16-960e-a12ce1df5839', 'f9f10d34-071c-57a6-b58c-7553abad5c20', '95a37a67-eac8-5ae2-9a50-31f81f810f18'],\n power text, -- example: ['4', '3', '2'],\n printings text, -- example: ['10E,JUD,UMA', '10E,8ED,9ED,DDC,DVD,IMA,INV,JMP,MB1,P02,PS11,PSAL,...', '10E,8ED,9ED,ODY'],\n promoTypes text, -- example: ['boxtopper,boosterfun', 'boosterfun', 'release,buyabox'],\n purchaseUrls text,\n rarity text, -- example: ['uncommon', 'common', 'rare'],\n scryfallId text, -- example: ['7a5cd03c-4227-4551-aa4b-7d119f0468b5', '8f7980d4-da43-4d6d-ad16-14b8a34ae91d', '407110e9-19af-4ff5-97b2-c03225031a73'],\n scryfallIllustrationId text, -- example: ['be2f7173-c8b7-4172-a388-9b2c6b3c16e5', 'e4d6c53f-e936-4be8-8b70-47c2be863b20', '2eb663cd-020a-46d8-a6d9-bb63d4b5c848'],\n scryfallOracleId text, -- example: ['fc2ccab7-cab1-4463-b73d-898070136d74', 'a2daaf32-dbfe-4618-892e-0da24f63a44a', '48bda7dd-d023-41e8-8c28-e0cfda0d07ca'],\n setCode text, -- example: ['10E', '2ED', '2XM'],\n side text, -- example: ['a', 'b', 'c'],\n subtypes text, -- example: ['Human,Cleric', 'Angel', 'Bird,Soldier'],\n supertypes text, -- example: ['Legendary', 'Basic', 'Legendary,Snow'],\n tcgplayerProductId text, -- example: ['15032', '15033', '15045'],\n text text, -- example: ['First strike (This creature deals combat damage be...', 'Flying\nWhen Angel of Mercy enters the battlefield,...', 'Flying (This creature can't be blocked except by c...'],\n toughness text, -- example: ['4', '3', '2'],\n type text, -- example: ['Creature \u2014 Human Cleric', 'Creature \u2014 Angel', 'Creature \u2014 Bird Soldier'],\n types text, -- example: ['Creature', 'Instant', 'Enchantment'],\n uuid text, -- example: ['00010d56-fe38-5e35-8aed-518019aa36a5', '0001e0d0-2dcd-5640-aadc-a84765cf5fc9', '0003caab-9ff5-5d1a-bc06-976dd0457f19'],\n variations text, -- example: ['b7c19924-b4bf-56fc-aa73-f586e940bd42', '8fd4e2eb-3eb4-50ea-856b-ef638fa47f8a', '6adaf14d-43e3-521a-adf1-960c808e5b1a'],\n watermark text, -- example: ['set (HOU)', 'set (LGN)', 'set (ONS)'],\n PRIMARY KEY (id)\n );\n CREATE TABLE main.foreign_data (\n id integer, -- example: [1, 2, 3],\n flavorText text, -- example: ['\u201eEs ist der Wille aller, und meine Hand, die ihn a...', '\"La voluntad de todos, realizada por mi mano.\"', '\u00ab La volont\u00e9 de tous passe par ma main. \u00bb'],\n language text, -- example: ['German', 'Spanish', 'French'],\n multiverseid integer, -- example: [148411, 150317, 149934],\n name text, -- example: ['Ausgew\u00e4hlter der Ahnfrau', 'Elegido de la Antepasada', '\u00c9lu de l'Anc\u00eatre'],\n text text, -- example: ['Erstschlag (Diese Kreatur f\u00fcgt Kampfschaden vor Kr...', 'Da\u00f1a primero. (Esta criatura hace da\u00f1o de combate ...', 'Initiative (Cette cr\u00e9ature inflige des blessures d...'],\n type text, -- example: ['Kreatur \u2014 Mensch, Kleriker', 'Criatura \u2014 Cl\u00e9rigo humano', 'Cr\u00e9ature : humain et clerc'],\n uuid text, -- example: ['5f8287b1-5bb6-5f4c-ad17-316a40d5bb0c', '57aaebc1-850c-503d-9f6e-bb8d00d8bf7c', '8ac972b5-9f6e-5cc8-91c3-b9a40a98232e'],\n PRIMARY KEY (id),\n CONSTRAINT fk_main_foreign_data_uuid FOREIGN KEY (uuid) REFERENCES cards (uuid)\n );\n CREATE TABLE main.legalities (\n id integer, -- example: [1, 2, 3],\n format text, -- example: ['commander', 'duel', 'legacy'],\n status text, -- example: ['Legal', 'Banned', 'Restricted'],\n uuid text, -- example: ['5f8287b1-5bb6-5f4c-ad17-316a40d5bb0c', '57aaebc1-850c-503d-9f6e-bb8d00d8bf7c', '8ac972b5-9f6e-5cc8-91c3-b9a40a98232e'],\n PRIMARY KEY (id),\n CONSTRAINT fk_main_legalities_uuid FOREIGN KEY (uuid) REFERENCES cards (uuid)\n );\n CREATE TABLE main.rulings (\n id integer, -- example: [1, 2, 3],\n date date, -- example: ['2007-07-15'],\n text text, -- example: ['You draw the card when Bandage resolves, not when ...', 'If you double a negative life total, you do the re...', 'Beacon of Immortality\u2019s effect counts as life gain...'],\n uuid text, -- example: ['6d268c95-c176-5766-9a46-c14f739aba1c', '56f4935b-f6c5-59b9-88bf-9bcce20247ce', '7fef665c-36a1-5f7a-9299-cf8938708710'],\n PRIMARY KEY (id),\n CONSTRAINT fk_main_rulings_uuid FOREIGN KEY (uuid) REFERENCES cards (uuid)\n );\n CREATE TABLE main.set_translations (\n id integer, -- example: [1, 2, 3],\n language text, -- example: ['Chinese Simplified', 'Chinese Traditional', 'French'],\n setCode text, -- example: ['10E', '4ED', '5DN'],\n translation text, -- example: ['\u6838\u5fc3\u7cfb\u5217\u7b2c\u5341\u7248', 'Dixi\u00e8me \u00e9dition', 'Hauptset Zehnte Edition'],\n PRIMARY KEY (id),\n CONSTRAINT fk_main_set_translations_setCode FOREIGN KEY (setCode) REFERENCES sets (code)\n );\n CREATE TABLE main.sets (\n id integer, -- example: [1, 2, 3],\n baseSetSize integer, -- example: [383, 302, 332],\n block text, -- example: ['Core Set', 'Mirrodin', 'Kaladesh'],\n booster text, -- example: ['{'default': {'boosters': [{'contents': {'basic': 1...', '{'default': {'boosters': [{'contents': {'common': ...', '{'default': {'boosters': [{'contents': {'common': ...'],\n code text, -- example: ['10E', '2ED', '2XM'],\n isFoilOnly integer, -- example: [0, 1],\n isForeignOnly integer, -- example: [0, 1],\n isNonFoilOnly integer, -- example: [0, 1],\n isOnlineOnly integer, -- example: [0, 1],\n isPartialPreview integer, -- example: [0, 1],\n keyruneCode text, -- example: ['10E', '2ED', '2XM'],\n mcmId integer, -- example: [74, 3204, 10],\n mcmIdExtras integer, -- example: [3209, 3459, 2587],\n mcmName text, -- example: ['Tenth Edition', 'Double Masters', 'Fourth Edition'],\n mtgoCode text, -- example: ['10E', '2XM', '5DN'],\n name text, -- example: ['Tenth Edition', 'Unlimited Edition', 'Double Masters'],\n parentCode text, -- example: ['JMP', 'MH1', 'ZNR'],\n releaseDate date, -- example: ['2007-07-13'],\n tcgplayerGroupId integer, -- example: [1, 115, 2655],\n totalSetSize integer, -- example: [508, 302, 384],\n type text, -- example: ['core', 'masters', 'expansion'],\n PRIMARY KEY (id)\n );",6    "codebase_community": " CREATE TABLE main.badges (\n Id integer, -- example: [1, 2, 3],\n UserId integer, -- example: [5, 6, 8],\n Name text, -- example: ['Teacher', 'Student', 'Editor'],\n Date datetime, -- example: ['2010-07-19 19:39:07'],\n PRIMARY KEY (Id),\n CONSTRAINT fk_main_badges_UserId FOREIGN KEY (UserId) REFERENCES users (Id)\n );\n CREATE TABLE main.comments (\n Id integer, -- example: [1, 2, 3],\n PostId integer, -- example: [3, 5, 9],\n Score integer, -- example: [5, 0, 11],\n Text text, -- example: ['Could be a poster child fo argumentative and subje...', 'Yes, R is nice- but WHY is it 'valuable'.', 'Again- why?  How would I convince my boss to use t...'],\n CreationDate datetime, -- example: ['2010-07-19 19:15:52'],\n UserId integer, -- example: [13, 37, 5],\n UserDisplayName text, -- example: ['user28', 'Statprof', 'jjgibaja'],\n PRIMARY KEY (Id),\n CONSTRAINT fk_main_comments_PostId FOREIGN KEY (PostId) REFERENCES posts (Id),\n CONSTRAINT fk_main_comments_UserId FOREIGN KEY (UserId) REFERENCES users (Id)\n );\n CREATE TABLE main.postHistory (\n Id integer, -- example: [1, 2, 3],\n PostHistoryTypeId integer, -- example: [2, 1, 3],\n PostId integer, -- example: [1, 2, 3],\n RevisionGUID text, -- example: ['e58bf7fd-e60f-4c58-a6e4-dfc91cf98a69', '18bf9150-f1cb-432d-b7b7-26d2f8e33581', '6320bb0f-c792-4a8c-8083-89507c28d375'],\n CreationDate datetime, -- example: ['2010-07-19 19:12:12'],\n UserId integer, -- example: [8, 24, 18],\n Text text, -- example: ['How should I elicit prior distributions from exper...', 'Eliciting priors from experts', '<bayesian><prior><elicitation>'],\n Comment text, -- example: ['edited tags', 'add content from the comments;', 'Removed the word \"most\" and used \"some\"- most is w...'],\n UserDisplayName text, -- example: ['user28', 'user209', 'Michael Bishop'],\n PRIMARY KEY (Id),\n CONSTRAINT fk_main_postHistory_PostId FOREIGN KEY (PostId) REFERENCES posts (Id),\n CONSTRAINT fk_main_postHistory_UserId FOREIGN KEY (UserId) REFERENCES users (Id)\n );\n CREATE TABLE main.postLinks (\n Id integer, -- example: [108, 145, 217],\n CreationDate datetime, -- example: ['2010-07-21 14:47:33'],\n PostId integer, -- example: [395, 548, 375],\n RelatedPostId integer, -- example: [173, 539, 30],\n LinkTypeId integer, -- example: [1, 3],\n PRIMARY KEY (Id),\n CONSTRAINT fk_main_postLinks_PostId FOREIGN KEY (PostId) REFERENCES posts (Id),\n CONSTRAINT fk_main_postLinks_RelatedPostId FOREIGN KEY (RelatedPostId) REFERENCES posts (Id)\n );\n CREATE TABLE main.posts (\n Id integer, -- example: [1, 2, 3],\n PostTypeId integer, -- example: [1, 2, 7],\n AcceptedAnswerId integer, -- example: [15, 59, 5],\n CreaionDate datetime, -- example: ['2010-07-19 19:12:12'],\n Score integer, -- example: [23, 22, 54],\n ViewCount integer, -- example: [1278, 8198, 3613],\n Body text,\n OwnerUserId integer, -- example: [8, 24, 18],\n LasActivityDate datetime, -- example: ['2010-09-15 21:08:26'],\n Title text, -- example: ['Eliciting priors from experts', 'What is normality?', 'What are some valuable Statistical Analysis open s...'],\n Tags text, -- example: ['<bayesian><prior><elicitation>', '<distributions><normality>', '<software><open-source>'],\n AnswerCount integer, -- example: [5, 7, 19],\n CommentCount integer, -- example: [1, 4, 2],\n FavoriteCount integer, -- example: [14, 8, 36],\n LastEditorUserId integer, -- example: [88, 183, 23],\n LastEditDate datetime, -- example: ['2010-08-07 17:56:44'],\n CommunityOwnedDate datetime, -- example: ['2010-07-19 19:13:28'],\n ParentId integer, -- example: [3, 7, 6],\n ClosedDate datetime, -- example: ['2010-07-19 20:19:46'],\n OwnerDisplayName text, -- example: ['user28', 'user209', 'Michael Bishop'],\n LastEditorDisplayName text, -- example: ['user28', 'user10525', 'sjcockell'],\n PRIMARY KEY (Id),\n CONSTRAINT fk_main_posts_LastEditorUserId FOREIGN KEY (LastEditorUserId) REFERENCES users (Id),\n CONSTRAINT fk_main_posts_OwnerUserId FOREIGN KEY (OwnerUserId) REFERENCES users (Id),\n CONSTRAINT fk_main_posts_ParentId FOREIGN KEY (ParentId) REFERENCES posts (Id)\n );\n CREATE TABLE main.tags (\n Id integer, -- example: [1, 2, 3],\n TagName text, -- example: ['bayesian', 'prior', 'elicitation'],\n Count integer, -- example: [1342, 168, 6],\n ExcerptPostId integer, -- example: [20258, 62158, 67815],\n WikiPostId integer, -- example: [20257, 62157, 67814],\n PRIMARY KEY (Id),\n CONSTRAINT fk_main_tags_ExcerptPostId FOREIGN KEY (ExcerptPostId) REFERENCES posts (Id)\n );\n CREATE TABLE main.users (\n Id integer, -- example: ['-1', 2, 3],\n Reputation integer, -- example: [1, 101, 6792],\n CreationDate datetime, -- example: ['2010-07-19 06:55:26'],\n DisplayName text, -- example: ['Community', 'Geoff Dalgas', 'Jarrod Dixon'],\n LastAccessDate datetime, -- example: ['2010-07-19 06:55:26'],\n WebsiteUrl text,\n Location text, -- example: ['on the server farm', 'Corvallis, OR', 'New York, NY'],\n AboutMe text,\n Views integer, -- example: [0, 25, 22],\n UpVotes integer, -- example: [5007, 3, 19],\n DownVotes integer, -- example: [1920, 0, 5],\n AccountId integer, -- example: ['-1', 2, 3],\n Age integer, -- example: [37, 35, 28],\n ProfileImageUrl text,\n PRIMARY KEY (Id)\n );\n CREATE TABLE main.votes (\n Id integer, -- example: [1, 2, 3],\n PostId integer, -- example: [3, 2, 5],\n VoteTypeId integer, -- example: [2, 5, 3],\n CreationDate date, -- example: ['2010-07-19'],\n UserId integer, -- example: [58, 6, 66],\n BountyAmount integer, -- example: [50, 25, 0],\n PRIMARY KEY (Id),\n CONSTRAINT fk_main_votes_PostId FOREIGN KEY (PostId) REFERENCES posts (Id),\n CONSTRAINT fk_main_votes_UserId FOREIGN KEY (UserId) REFERENCES users (Id)\n );",7    "superhero": " CREATE TABLE main.alignment (\n id integer, -- example: [1, 2, 3],\n alignment text, -- example: ['Good', 'Bad', 'Neutral'],\n PRIMARY KEY (id)\n );\n CREATE TABLE main.attribute (\n id integer, -- example: [1, 2, 3],\n attribute_name text, -- example: ['Intelligence', 'Strength', 'Speed'],\n PRIMARY KEY (id)\n );\n CREATE TABLE main.colour (\n id integer, -- example: [1, 2, 3],\n colour text, -- example: ['No Colour', 'Amber', 'Auburn'],\n PRIMARY KEY (id)\n );\n CREATE TABLE main.gender (\n id integer, -- example: [1, 2, 3],\n gender text, -- example: ['Male', 'Female', 'N/A'],\n PRIMARY KEY (id)\n );\n CREATE TABLE main.hero_attribute (\n hero_id integer, -- example: [1, 2, 3],\n attribute_id integer, -- example: [1, 2, 3],\n attribute_value integer, -- example: [80, 75, 95],\n CONSTRAINT fk_main_hero_attribute_attribute_id FOREIGN KEY (attribute_id) REFERENCES attribute (id),\n CONSTRAINT fk_main_hero_attribute_hero_id FOREIGN KEY (hero_id) REFERENCES superhero (id)\n );\n CREATE TABLE main.hero_power (\n hero_id integer, -- example: [1, 2, 3],\n power_id integer, -- example: [1, 18, 26],\n CONSTRAINT fk_main_hero_power_hero_id FOREIGN KEY (hero_id) REFERENCES superhero (id),\n CONSTRAINT fk_main_hero_power_power_id FOREIGN KEY (power_id) REFERENCES superpower (id)\n );\n CREATE TABLE main.publisher (\n id integer, -- example: [1, 2, 3],\n publisher_name text, -- example: ['ABC Studios', 'Dark Horse Comics', 'DC Comics'],\n PRIMARY KEY (id)\n );\n CREATE TABLE main.race (\n id integer, -- example: [1, 2, 3],\n race text, -- example: ['-', 'Alien', 'Alpha'],\n PRIMARY KEY (id)\n );\n CREATE TABLE main.superhero (\n id integer, -- example: [1, 2, 3],\n superhero_name text, -- example: ['3-D Man', 'A-Bomb', 'Abe Sapien'],\n full_name text, -- example: ['Charles Chandler', 'Richard Milhouse Jones', 'Abraham Sapien'],\n gender_id integer, -- example: [1, 2, 3],\n eye_colour_id integer, -- example: [9, 33, 7],\n hair_colour_id integer, -- example: [13, 1, 4],\n skin_colour_id integer, -- example: [1, 7, 23],\n race_id integer, -- example: [1, 24, 33],\n publisher_id integer, -- example: [13, 3, 4],\n alignment_id integer, -- example: [1, 2, 3],\n height_cm integer, -- example: [188, 203, 191],\n weight_kg integer, -- example: [90, 441, 65],\n PRIMARY KEY (id),\n CONSTRAINT fk_main_superhero_alignment_id FOREIGN KEY (alignment_id) REFERENCES alignment (id),\n CONSTRAINT fk_main_superhero_eye_colour_id FOREIGN KEY (eye_colour_id) REFERENCES colour (id),\n CONSTRAINT fk_main_superhero_gender_id FOREIGN KEY (gender_id) REFERENCES gender (id),\n CONSTRAINT fk_main_superhero_hair_colour_id FOREIGN KEY (hair_colour_id) REFERENCES colour (id),\n CONSTRAINT fk_main_superhero_publisher_id FOREIGN KEY (publisher_id) REFERENCES publisher (id),\n CONSTRAINT fk_main_superhero_race_id FOREIGN KEY (race_id) REFERENCES race (id),\n CONSTRAINT fk_main_superhero_skin_colour_id FOREIGN KEY (skin_colour_id) REFERENCES colour (id)\n );\n CREATE TABLE main.superpower (\n id integer, -- example: [1, 2, 3],\n power_name text, -- example: ['Agility', 'Accelerated Healing', 'Lantern Power Ring'],\n PRIMARY KEY (id)\n );",8    "formula_1": " CREATE TABLE main.circuits (\n circuitId integer, -- example: [23, 61, 29],\n circuitRef text, -- example: ['sepang', 'bahrain', 'catalunya'],\n name text, -- example: ['Sepang International Circuit', 'Bahrain International Circuit', 'Circuit de Barcelona-Catalunya'],\n location text, -- example: ['Kuala Lumpur', 'Sakhir', 'Montmel\u00f3'],\n country text, -- example: ['Malaysia', 'Bahrain', 'Spain'],\n lat real, -- example: [2.76083, 26.0325, 41.57],\n lng real, -- example: [101.738, 50.5106, 2.26111],\n alt integer,\n url text,\n PRIMARY KEY (circuitId)\n );\n CREATE TABLE main.constructorResults (\n constructorResultsId integer, -- example: [1, 2, 3],\n raceId integer, -- example: [18, 19, 20],\n constructorId integer, -- example: [1, 2, 3],\n points real, -- example: [14.0, 8.0, 9.0],\n status text, -- example: ['D'],\n PRIMARY KEY (constructorResultsId),\n CONSTRAINT fk_main_constructorResults_raceId FOREIGN KEY (raceId) REFERENCES races (raceId),\n CONSTRAINT fk_main_constructorResults_constructorId FOREIGN KEY (constructorId) REFERENCES constructors (constructorId)\n );\n CREATE TABLE main.constructorStandings (\n constructorStandingsId integer, -- example: [1, 2, 3],\n raceId integer, -- example: [18, 19, 20],\n constructorId integer, -- example: [1, 2, 3],\n points real, -- example: [14.0, 8.0, 9.0],\n position integer, -- example: [1, 3, 2],\n positionText text, -- example: ['1', '3', '2'],\n wins integer, -- example: [1, 0, 2],\n PRIMARY KEY (constructorStandingsId),\n CONSTRAINT fk_main_constructorStandings_raceId FOREIGN KEY (raceId) REFERENCES races (raceId),\n CONSTRAINT fk_main_constructorStandings_constructorId FOREIGN KEY (constructorId) REFERENCES constructors (constructorId)\n );\n CREATE TABLE main.constructors (\n constructorId integer, -- example: [147, 39, 54],\n constructorRef text, -- example: ['mclaren', 'bmw_sauber', 'williams'],\n name text, -- example: ['AFM', 'AGS', 'ATS'],\n nationality text, -- example: ['British', 'German', 'French'],\n url text,\n PRIMARY KEY (constructorId)\n );\n CREATE TABLE main.driverStandings (\n driverStandingsId integer, -- example: [1, 2, 3],\n raceId integer, -- example: [18, 19, 20],\n driverId integer, -- example: [1, 2, 3],\n points real, -- example: [10.0, 8.0, 6.0],\n position integer, -- example: [1, 2, 3],\n positionText text, -- example: ['1', '2', '3'],\n wins integer, -- example: [1, 0, 2],\n PRIMARY KEY (driverStandingsId),\n CONSTRAINT fk_main_driverStandings_raceId FOREIGN KEY (raceId) REFERENCES races (raceId),\n CONSTRAINT fk_main_driverStandings_driverId FOREIGN KEY (driverId) REFERENCES drivers (driverId)\n );\n CREATE TABLE main.drivers (\n driverId integer, -- example: [452, 625, 103],\n driverRef text, -- example: ['hamilton', 'heidfeld', 'rosberg'],\n number integer, -- example: [44, 6, 14],\n code text, -- example: ['HAM', 'HEI', 'ROS'],\n forename text, -- example: ['Lewis', 'Nick', 'Nico'],\n surname text, -- example: ['Hamilton', 'Heidfeld', 'Rosberg'],\n dob date, -- example: ['1985-01-07'],\n nationality text, -- example: ['British', 'German', 'Spanish'],\n url text,\n PRIMARY KEY (driverId)\n );\n CREATE TABLE main.lapTimes (\n raceId integer, -- example: [1, 2, 3],\n driverId integer, -- example: [1, 2, 3],\n lap integer, -- example: [1, 2, 3],\n position integer, -- example: [13, 12, 11],\n time text, -- example: ['1:49.088', '1:33.740', '1:31.600'],\n milliseconds integer, -- example: [109088, 93740, 91600],\n PRIMARY KEY (raceId, driverId, lap),\n CONSTRAINT fk_main_lapTimes_raceId FOREIGN KEY (raceId) REFERENCES races (raceId),\n CONSTRAINT fk_main_lapTimes_driverId FOREIGN KEY (driverId) REFERENCES drivers (driverId)\n );\n CREATE TABLE main.pitStops (\n raceId integer, -- example: [841, 842, 843],\n driverId integer, -- example: [1, 2, 3],\n stop integer, -- example: [1, 2, 3],\n lap integer, -- example: [16, 36, 15],\n time text, -- example: ['17:28:24', '17:59:29', '17:27:41'],\n duration text, -- example: ['23.227', '23.199', '22.994'],\n milliseconds integer, -- example: [23227, 23199, 22994],\n PRIMARY KEY (raceId, driverId, stop),\n CONSTRAINT fk_main_pitStops_raceId FOREIGN KEY (raceId) REFERENCES races (raceId),\n CONSTRAINT fk_main_pitStops_driverId FOREIGN KEY (driverId) REFERENCES drivers (driverId)\n );\n CREATE TABLE main.qualifying (\n qualifyId integer, -- example: [1, 2, 3],\n raceId integer, -- example: [18, 19, 20],\n driverId integer, -- example: [1, 9, 5],\n constructorId integer, -- example: [1, 2, 6],\n number integer, -- example: [22, 4, 23],\n position integer, -- example: [1, 2, 3],\n q1 text, -- example: ['1:26.572', '1:26.103', '1:25.664'],\n q2 text, -- example: ['1:25.187', '1:25.315', '1:25.452'],\n q3 text, -- example: ['1:26.714', '1:26.869', '1:27.079'],\n PRIMARY KEY (qualifyId),\n CONSTRAINT fk_main_qualifying_raceId FOREIGN KEY (raceId) REFERENCES races (raceId),\n CONSTRAINT fk_main_qualifying_driverId FOREIGN KEY (driverId) REFERENCES drivers (driverId),\n CONSTRAINT fk_main_qualifying_constructorId FOREIGN KEY (constructorId) REFERENCES constructors (constructorId)\n );\n CREATE TABLE main.races (\n raceId integer, -- example: [837, 833, 838],\n year integer, -- example: [2009, 2008, 2007],\n round integer, -- example: [1, 2, 3],\n circuitId integer, -- example: [1, 2, 17],\n name text, -- example: ['Australian Grand Prix', 'Malaysian Grand Prix', 'Chinese Grand Prix'],\n date date, -- example: ['2009-03-29'],\n time text, -- example: ['06:00:00', '09:00:00', '07:00:00'],\n url text,\n PRIMARY KEY (raceId),\n CONSTRAINT fk_main_races_year FOREIGN KEY (year) REFERENCES seasons (year),\n CONSTRAINT fk_main_races_circuitId FOREIGN KEY (circuitId) REFERENCES circuits (circuitId)\n );\n CREATE TABLE main.results (\n resultId integer, -- example: [1, 2, 3],\n raceId integer, -- example: [18, 19, 20],\n driverId integer, -- example: [1, 2, 3],\n constructorId integer, -- example: [1, 2, 3],\n number integer, -- example: [22, 3, 7],\n grid integer, -- example: [1, 5, 7],\n position integer, -- example: [1, 2, 3],\n positionText text, -- example: ['1', '2', '3'],\n positionOrder integer, -- example: [1, 2, 3],\n points real, -- example: [10.0, 8.0, 6.0],\n laps integer, -- example: [58, 57, 55],\n time text, -- example: ['1:34:50.616', '+5.478', '+8.163'],\n milliseconds integer, -- example: [5690616, 5696094, 5698779],\n fastestLap integer, -- example: [39, 41, 58],\n rank integer, -- example: [2, 3, 5],\n fastestLapTime text, -- example: ['1:27.452', '1:27.739', '1:28.090'],\n fastestLapSpeed text, -- example: ['218.300', '217.586', '216.719'],\n statusId integer, -- example: [1, 11, 5],\n PRIMARY KEY (resultId),\n CONSTRAINT fk_main_results_raceId FOREIGN KEY (raceId) REFERENCES races (raceId),\n CONSTRAINT fk_main_results_driverId FOREIGN KEY (driverId) REFERENCES drivers (driverId),\n CONSTRAINT fk_main_results_constructorId FOREIGN KEY (constructorId) REFERENCES constructors (constructorId),\n CONSTRAINT fk_main_results_statusId FOREIGN KEY (statusId) REFERENCES status (statusId)\n );\n CREATE TABLE main.seasons (\n year integer, -- example: [1950, 1951, 1952],\n url text,\n PRIMARY KEY (year)\n );\n CREATE TABLE main.status (\n statusId integer, -- example: [1, 2, 3],\n status text, -- example: ['Finished', 'Disqualified', 'Accident'],\n PRIMARY KEY (statusId)\n );",9    "european_football_2": " CREATE TABLE main.Country (\n id integer, -- example: [1],\n name text, -- example: ['Belgium'],\n PRIMARY KEY (id)\n );\n CREATE TABLE main.League (\n id integer, -- example: [1],\n country_id integer, -- example: [1],\n name text, -- example: ['Belgium Jupiler League'],\n PRIMARY KEY (id),\n CONSTRAINT fk_main_League_country_id FOREIGN KEY (country_id) REFERENCES country (id)\n );\n CREATE TABLE main.Match (\n id integer, -- example: [4769],\n country_id integer, -- example: [1],\n league_id integer, -- example: [1],\n season text, -- example: ['2008/2009'],\n stage integer, -- example: [1],\n date text, -- example: ['2008-08-17 00:00:00'],\n match_api_id integer, -- example: [483129],\n home_team_api_id integer, -- example: [9987],\n away_team_api_id integer, -- example: [9993],\n home_team_goal integer, -- example: [1],\n away_team_goal integer, -- example: [1],\n home_player_X1 integer, -- example: [1],\n home_player_X2 integer, -- example: [2],\n home_player_X3 integer, -- example: [4],\n home_player_X4 integer, -- example: [6],\n home_player_X5 integer, -- example: [8],\n home_player_X6 integer, -- example: [2],\n home_player_X7 integer, -- example: [4],\n home_player_X8 integer, -- example: [6],\n home_player_X9 integer, -- example: [8],\n home_player_X10 integer, -- example: [4],\n home_player_X11 integer, -- example: [6],\n away_player_X1 integer, -- example: [1],\n away_player_X2 integer, -- example: [2],\n away_player_X3 integer, -- example: [4],\n away_player_X4 integer, -- example: [6],\n away_player_X5 integer, -- example: [8],\n away_player_X6 integer, -- example: [2],\n away_player_X7 integer, -- example: [4],\n away_player_X8 integer, -- example: [6],\n away_player_X9 integer, -- example: [8],\n away_player_X10 integer, -- example: [4],\n away_player_X11 integer, -- example: [6],\n home_player_Y1 integer, -- example: [1],\n home_player_Y2 integer, -- example: [3],\n home_player_Y3 integer, -- example: [3],\n home_player_Y4 integer, -- example: [3],\n home_player_Y5 integer, -- example: [3],\n home_player_Y6 integer, -- example: [7],\n home_player_Y7 integer, -- example: [7],\n home_player_Y8 integer, -- example: [7],\n home_player_Y9 integer, -- example: [7],\n home_player_Y10 integer, -- example: [10],\n home_player_Y11 integer, -- example: [10],\n away_player_Y1 integer, -- example: [1],\n away_player_Y2 integer, -- example: [3],\n away_player_Y3 integer, -- example: [3],\n away_player_Y4 integer, -- example: [3],\n away_player_Y5 integer, -- example: [3],\n away_player_Y6 integer, -- example: [7],\n away_player_Y7 integer, -- example: [7],\n away_player_Y8 integer, -- example: [7],\n away_player_Y9 integer, -- example: [7],\n away_player_Y10 integer, -- example: [10],\n away_player_Y11 integer, -- example: [10],\n home_player_1 integer, -- example: [39890],\n home_player_2 integer, -- example: [67950],\n home_player_3 integer, -- example: [38788],\n home_player_4 integer, -- example: [38312],\n home_player_5 integer, -- example: [26235],\n home_player_6 integer, -- example: [36393],\n home_player_7 integer, -- example: [148286],\n home_player_8 integer, -- example: [67898],\n home_player_9 integer, -- example: [26916],\n home_player_10 integer, -- example: [38801],\n home_player_11 integer, -- example: [94289],\n away_player_1 integer, -- example: [34480],\n away_player_2 integer, -- example: [38388],\n away_player_3 integer, -- example: [26458],\n away_player_4 integer, -- example: [13423],\n away_player_5 integer, -- example: [38389],\n away_player_6 integer, -- example: [38798],\n away_player_7 integer, -- example: [30949],\n away_player_8 integer, -- example: [38253],\n away_player_9 integer, -- example: [106013],\n away_player_10 integer, -- example: [38383],\n away_player_11 integer, -- example: [46552],\n goal text, -- example: ['<goal><value><comment>n</comment><stats><goals>1</...'],\n shoton text, -- example: ['<shoton><value><stats><blocked>1</blocked></stats>...'],\n shotoff text, -- example: ['<shotoff><value><stats><shotoff>1</shotoff></stats...'],\n foulcommit text, -- example: ['<foulcommit><value><stats><foulscommitted>1</fouls...'],\n card text, -- example: ['<card><value><comment>y</comment><stats><ycards>1<...'],\n cross text, -- example: ['<cross><value><stats><crosses>1</crosses></stats><...'],\n corner text, -- example: ['<corner><value><stats><corners>1</corners></stats>...'],\n possession text, -- example: ['<possession><value><comment>56</comment><event_inc...'],\n B365H real, -- example: [1.73],\n B365D real, -- example: [3.4],\n B365A real, -- example: [5.0],\n BWH real, -- example: [1.75],\n BWD real, -- example: [3.35],\n BWA real, -- example: [4.2],\n IWH real, -- example: [1.85],\n IWD real, -- example: [3.2],\n IWA real, -- example: [3.5],\n LBH real, -- example: [1.8],\n LBD real, -- example: [3.3],\n LBA real, -- example: [3.75],\n PSH real, -- example: [5.1],\n PSD real, -- example: [3.82],\n PSA real, -- example: [1.76],\n WHH real, -- example: [1.7],\n WHD real, -- example: [3.3],\n WHA real, -- example: [4.33],\n SJH real, -- example: [1.9],\n SJD real, -- example: [3.3],\n SJA real, -- example: [4.0],\n VCH real, -- example: [1.65],\n VCD real, -- example: [3.4],\n VCA real, -- example: [4.5],\n GBH real, -- example: [1.78],\n GBD real, -- example: [3.25],\n GBA real, -- example: [4.0],\n BSH real, -- example: [1.73],\n BSD real, -- example: [3.4],\n BSA real, -- example: [4.2],\n PRIMARY KEY (id),\n CONSTRAINT fk_main_Match_away_player_11 FOREIGN KEY (away_player_11) REFERENCES Player (player_api_id),\n CONSTRAINT fk_main_Match_away_player_10 FOREIGN KEY (away_player_10) REFERENCES Player (player_api_id),\n CONSTRAINT fk_main_Match_away_player_9 FOREIGN KEY (away_player_9) REFERENCES Player (player_api_id),\n CONSTRAINT fk_main_Match_away_player_8 FOREIGN KEY (away_player_8) REFERENCES Player (player_api_id),\n CONSTRAINT fk_main_Match_away_player_7 FOREIGN KEY (away_player_7) REFERENCES Player (player_api_id),\n CONSTRAINT fk_main_Match_away_player_6 FOREIGN KEY (away_player_6) REFERENCES Player (player_api_id),\n CONSTRAINT fk_main_Match_away_player_5 FOREIGN KEY (away_player_5) REFERENCES Player (player_api_id),\n CONSTRAINT fk_main_Match_away_player_4 FOREIGN KEY (away_player_4) REFERENCES Player (player_api_id),\n CONSTRAINT fk_main_Match_away_player_3 FOREIGN KEY (away_player_3) REFERENCES Player (player_api_id),\n CONSTRAINT fk_main_Match_away_player_2 FOREIGN KEY (away_player_2) REFERENCES Player (player_api_id),\n CONSTRAINT fk_main_Match_away_player_1 FOREIGN KEY (away_player_1) REFERENCES Player (player_api_id),\n CONSTRAINT fk_main_Match_home_player_11 FOREIGN KEY (home_player_11) REFERENCES Player (player_api_id),\n CONSTRAINT fk_main_Match_home_player_10 FOREIGN KEY (home_player_10) REFERENCES Player (player_api_id),\n CONSTRAINT fk_main_Match_home_player_9 FOREIGN KEY (home_player_9) REFERENCES Player (player_api_id),\n CONSTRAINT fk_main_Match_home_player_8 FOREIGN KEY (home_player_8) REFERENCES Player (player_api_id),\n CONSTRAINT fk_main_Match_home_player_7 FOREIGN KEY (home_player_7) REFERENCES Player (player_api_id),\n CONSTRAINT fk_main_Match_home_player_6 FOREIGN KEY (home_player_6) REFERENCES Player (player_api_id),\n CONSTRAINT fk_main_Match_home_player_5 FOREIGN KEY (home_player_5) REFERENCES Player (player_api_id),\n CONSTRAINT fk_main_Match_home_player_4 FOREIGN KEY (home_player_4) REFERENCES Player (player_api_id),\n CONSTRAINT fk_main_Match_home_player_3 FOREIGN KEY (home_player_3) REFERENCES Player (player_api_id),\n CONSTRAINT fk_main_Match_home_player_2 FOREIGN KEY (home_player_2) REFERENCES Player (player_api_id),\n CONSTRAINT fk_main_Match_home_player_1 FOREIGN KEY (home_player_1) REFERENCES Player (player_api_id),\n CONSTRAINT fk_main_Match_away_team_api_id FOREIGN KEY (away_team_api_id) REFERENCES Team (team_api_id),\n CONSTRAINT fk_main_Match_home_team_api_id FOREIGN KEY (home_team_api_id) REFERENCES Team (team_api_id),\n CONSTRAINT fk_main_Match_league_id FOREIGN KEY (league_id) REFERENCES League (id),\n CONSTRAINT fk_main_Match_country_id FOREIGN KEY (country_id) REFERENCES Country (id)\n );\n CREATE TABLE main.Player (\n id integer, -- example: [3879],\n player_api_id integer, -- example: [2625],\n player_name text, -- example: ['Aaron Appindangoye'],\n player_fifa_api_id integer, -- example: [2],\n birthday text, -- example: ['1992-02-29 00:00:00'],\n height integer, -- example: [182.88],\n weight integer, -- example: [187],\n PRIMARY KEY (id)\n );\n CREATE TABLE main.Player_Attributes (\n id integer, -- example: [1],\n player_fifa_api_id integer, -- example: [218353],\n player_api_id integer, -- example: [505942],\n date text, -- example: ['2016-02-18 00:00:00'],\n overall_rating integer, -- example: [67],\n potential integer, -- example: [71],\n preferred_foot text, -- example: ['right'],\n attacking_work_rate text, -- example: ['medium'],\n defensive_work_rate text, -- example: ['medium'],\n crossing integer, -- example: [49],\n finishing integer, -- example: [44],\n heading_accuracy integer, -- example: [71],\n short_passing integer, -- example: [61],\n volleys integer, -- example: [44],\n dribbling integer, -- example: [51],\n curve integer, -- example: [45],\n free_kick_accuracy integer, -- example: [39],\n long_passing integer, -- example: [64],\n ball_control integer, -- example: [49],\n acceleration integer, -- example: [60],\n sprint_speed integer, -- example: [64],\n agility integer, -- example: [59],\n reactions integer, -- example: [47],\n balance integer, -- example: [65],\n shot_power integer, -- example: [55],\n jumping integer, -- example: [58],\n stamina integer, -- example: [54],\n strength integer, -- example: [76],\n long_shots integer, -- example: [35],\n aggression integer, -- example: [71],\n interceptions integer, -- example: [70],\n positioning integer, -- example: [45],\n vision integer, -- example: [54],\n penalties integer, -- example: [48],\n marking integer, -- example: [65],\n standing_tackle integer, -- example: [69],\n sliding_tackle integer, -- example: [69],\n gk_diving integer, -- example: [6],\n gk_handling integer, -- example: [11],\n gk_kicking integer, -- example: [10],\n gk_positioning integer, -- example: [8],\n gk_reflexes integer, -- example: [8],\n PRIMARY KEY (id),\n CONSTRAINT fk_main_Player_Attributes_player_api_id FOREIGN KEY (player_api_id) REFERENCES Player (player_api_id),\n CONSTRAINT fk_main_Player_Attributes_player_fifa_api_id FOREIGN KEY (player_fifa_api_id) REFERENCES Player (player_fifa_api_id)\n );\n CREATE TABLE main.Team (\n id integer, -- example: [31446],\n team_api_id integer, -- example: [1601],\n team_fifa_api_id integer, -- example: [673],\n team_long_name text, -- example: ['KRC Genk'],\n team_short_name text, -- example: ['GEN'],\n PRIMARY KEY (id)\n );\n CREATE TABLE main.Team_Attributes (\n id integer, -- example: [1],\n team_fifa_api_id integer, -- example: [434],\n team_api_id integer, -- example: [9930],\n date text, -- example: ['2010-02-22 00:00:00'],\n buildUpPlaySpeed integer, -- example: [60],\n buildUpPlaySpeedClass text, -- example: ['Balanced'],\n buildUpPlayDribbling integer, -- example: [48],\n buildUpPlayDribblingClass text, -- example: ['Little'],\n buildUpPlayPassing integer, -- example: [50],\n buildUpPlayPassingClass text, -- example: ['Mixed'],\n buildUpPlayPositioningClass text, -- example: ['Organised'],\n chanceCreationPassing integer, -- example: [60],\n chanceCreationPassingClass text, -- example: ['Normal'],\n chanceCreationCrossing integer, -- example: [65],\n chanceCreationCrossingClass text, -- example: ['Normal'],\n chanceCreationShooting integer, -- example: [55],\n chanceCreationShootingClass text, -- example: ['Normal'],\n chanceCreationPositioningClass text, -- example: ['Organised'],\n defencePressure integer, -- example: [50],\n defencePressureClass text, -- example: ['Medium'],\n defenceAggression integer, -- example: [55],\n defenceAggressionClass text, -- example: ['Press'],\n defenceTeamWidth integer, -- example: [45],\n defenceTeamWidthClass text, -- example: ['Normal'],\n defenceDefenderLineClass text, -- example: ['Cover'],\n PRIMARY KEY (id),\n CONSTRAINT fk_main_Team_Attributes_team_api_id FOREIGN KEY (team_api_id) REFERENCES Team (team_api_id),\n CONSTRAINT fk_main_Team_Attributes_team_fifa_api_id FOREIGN KEY (team_fifa_api_id) REFERENCES Team (team_fifa_api_id)\n );",10    "thrombosis_prediction": " CREATE TABLE main.Examination (\n ID integer, -- example: [14872, 48473, 102490],\n Examination Date date, -- example: ['1997-05-27'],\n aCL IgG real, -- example: [1.3, 4.3, 2.3],\n aCL IgM real, -- example: [1.6, 4.6, 2.5],\n ANA integer, -- example: [256, 0, 16],\n ANA Pattern text, -- example: ['P', 'P,S', 'S'],\n aCL IgA integer, -- example: [0, 3, 4],\n Diagnosis text, -- example: ['MCTD, AMI', 'SLE', 'PSS'],\n KCT text, -- example: ['-', '+'],\n RVVT text, -- example: ['-', '+'],\n LAC text, -- example: ['-', '+'],\n Symptoms text, -- example: ['AMI', 'CNS lupus', 'Apo'],\n Thrombosis integer, -- example: [1, 0, 2],\n CONSTRAINT fk_main_Examination_ID FOREIGN KEY (ID) REFERENCES Patient (ID)\n );\n CREATE TABLE main.Laboratory (\n ID integer, -- example: [27654, 30609, 43003],\n Date date, -- example: ['1991-09-11'],\n GOT integer, -- example: [34, 29, 26],\n GPT integer, -- example: [36, 31, 22],\n LDH integer, -- example: [567, 579, 684],\n ALP integer, -- example: [166, 154, 138],\n TP real, -- example: [4.5, 5.1, 5.5],\n ALB real, -- example: [3.3, 3.4, 3.6],\n UA real, -- example: [3.8, 4.2, 4.9],\n UN integer, -- example: [29, 36, 34],\n CRE real, -- example: [0.8, 0.9, 0.7],\n T-BIL real, -- example: [0.3, 0.2, 0.4],\n T-CHO integer, -- example: [165, 134, 140],\n TG integer, -- example: [185, 205, 254],\n CPK integer, -- example: [9, 10, 11],\n GLU integer, -- example: [88, 134, 161],\n WBC real, -- example: [5.0, 10.4, 10.5],\n RBC real, -- example: [2.6, 2.9, 3.4],\n HGB real, -- example: [6.4, 6.7, 7.9],\n HCT real, -- example: [20.3, 21.6, 24.7],\n PLT integer, -- example: [227, 242, 233],\n PT real, -- example: [11.3, 12.0, 11.8],\n APTT integer, -- example: [108, 84, 76],\n FG real, -- example: [27.0, 38.6, 27.6],\n PIC integer, -- example: [320, 513, 284],\n TAT integer, -- example: [77, 108, 115],\n TAT2 integer, -- example: [113, 88, 104],\n U-PRO text, -- example: ['-', '0', 'TR'],\n IGG integer, -- example: [339, 771, 430],\n IGA integer, -- example: [145, 188, 118],\n IGM integer, -- example: [46, 132, 56],\n CRP text, -- example: ['0.6', '2.7', '1.2'],\n RA text, -- example: ['-', '+', '+-'],\n RF text, -- example: ['<20.5', '<20.8', '<40'],\n C3 integer, -- example: [30, 82, 103],\n C4 integer, -- example: [14, 26, 35],\n RNP text, -- example: ['0', '1', '256'],\n SM text, -- example: ['0', '1', 'negative'],\n SC170 text, -- example: ['16', '1', '0'],\n SSA text, -- example: ['0', 'negative', '16'],\n SSB text, -- example: ['0', 'negative', '1'],\n CENTROMEA text, -- example: ['0', 'negative'],\n DNA text, -- example: ['41.9', '18', '4.3'],\n DNA-II integer,\n PRIMARY KEY (ID, Date),\n CONSTRAINT fk_main_Laboratory_ID FOREIGN KEY (ID) REFERENCES Patient (ID)\n );\n CREATE TABLE main.Patient (\n ID integer, -- example: [2110, 11408, 12052],\n SEX text, -- example: ['F', 'M'],\n Birthday date, -- example: ['1934-02-13'],\n Description date, -- example: ['1994-02-14'],\n First Date date, -- example: ['1993-02-10'],\n Admission text, -- example: ['+', '-', '+('],\n Diagnosis text, -- example: ['RA susp.', 'PSS', 'SLE'],\n PRIMARY KEY (ID)\n );",11    "student_club": " CREATE TABLE main.attendance (\n link_to_event text, -- example: ['rec2N69DMcrqN9PJC', 'rec5XDvJLyxDsGZWc', 'recEVTik3MlqbvLFi'],\n link_to_member text, -- example: ['recD078PnS3x2doBe', 'recP6DJPyi5donvXL', 'rec28ORZgcm1dtqBZ'],\n PRIMARY KEY (link_to_event, link_to_member),\n CONSTRAINT fk_main_attendance_link_to_event FOREIGN KEY (link_to_event) REFERENCES event (event_id),\n CONSTRAINT fk_main_attendance_link_to_member FOREIGN KEY (link_to_member) REFERENCES member (member_id)\n );\n CREATE TABLE main.budget (\n budget_id text, -- example: ['rec0QmEc3cSQFQ6V2', 'rec1bG6HSft7XIvTP', 'rec1z6ISJU2HdIsVm'],\n category text, -- example: ['Advertisement', 'Food', 'Speaker Gifts'],\n spent real, -- example: [67.81, 121.14, 20.2],\n remaining real, -- example: [7.19, 28.86, '-0.199999999999999'],\n amount integer, -- example: [75, 150, 20],\n event_status text, -- example: ['Closed', 'Open', 'Planning'],\n link_to_event text, -- example: ['recI43CzsZ0Q625ma', 'recggMW2eyCYceNcy', 'recJ4Witp9tpjaugn'],\n PRIMARY KEY (budget_id),\n CONSTRAINT fk_main_budget_link_to_event FOREIGN KEY (link_to_event) REFERENCES event (event_id)\n );\n CREATE TABLE main.event (\n event_id text, -- example: ['rec0Si5cQ4rJRVzd6', 'rec0akZnLLpGUloLH', 'rec0dZPcWXF0QjNnE'],\n event_name text, -- example: ['March Meeting', 'Officers meeting - January', 'Spring Elections'],\n event_date text, -- example: ['2020-03-10T12:00:00', '2020-01-14T09:30:00', '2019-11-24T09:00:00'],\n type text, -- example: ['Meeting', 'Election', 'Game'],\n notes text, -- example: ['All active members can vote for new officers betwe...', 'Attend Women's soccer game as a group.', 'Semester social event. Optional attendance.'],\n location text, -- example: ['MU 215', 'Campus Soccer/Lacrosse stadium', '900 E. Washington St.'],\n status text, -- example: ['Open', 'Planning', 'Closed'],\n PRIMARY KEY (event_id)\n );\n CREATE TABLE main.expense (\n expense_id text, -- example: ['rec017x6R3hQqkLAo', 'rec1nIjoZKTYayqZ6', 'rec1oMgNFt7Y0G40x'],\n expense_description text, -- example: ['Post Cards, Posters', 'Water, Cookies', 'Pizza'],\n expense_date text, -- example: ['2019-08-20', '2019-10-08', '2019-09-10'],\n cost real, -- example: [122.06, 20.2, 51.81],\n approved text, -- example: ['true'],\n link_to_member text, -- example: ['rec4BLdZHS2Blfp4v', 'recro8T1MPMwRadVH', 'recD078PnS3x2doBe'],\n link_to_budget text, -- example: ['recvKTAWAFKkVNnXQ', 'recy8KY5bUdzF81vv', 'recwXIiKoBMjXJsGZ'],\n PRIMARY KEY (expense_id),\n CONSTRAINT fk_main_expense_link_to_budget FOREIGN KEY (link_to_budget) REFERENCES budget (budget_id),\n CONSTRAINT fk_main_expense_link_to_member FOREIGN KEY (link_to_member) REFERENCES member (member_id)\n );\n CREATE TABLE main.income (\n income_id text, -- example: ['rec0s9ZrO15zhzUeE', 'rec7f5XMQZexgtQJo', 'rec8BUJa8GXUjiglg'],\n date_received text, -- example: ['2019-10-17', '2019-09-04', '2019-10-08'],\n amount integer, -- example: [50, 200, 3000],\n source text, -- example: ['Dues', 'Fundraising', 'School Appropration'],\n notes text, -- example: ['Secured donations to help pay for speaker gifts.', 'Annual funding from Student Government.', 'Ad revenue for use on flyers used to advertise upc...'],\n link_to_member text, -- example: ['reccW7q1KkhSKZsea', 'recTjHY5xXhvkCdVT', 'recUdRhbhcEO1Hk5r'],\n PRIMARY KEY (income_id),\n CONSTRAINT fk_main_income_link_to_member FOREIGN KEY (link_to_member) REFERENCES member (member_id)\n );\n CREATE TABLE main.major (\n major_id text, -- example: ['rec06DF6vZ1CyPKpc', 'rec09LedkREyskCNv', 'rec0Eanv576RhQllI'],\n major_name text, -- example: ['Outdoor Product Design and Development', 'Agricultural Communication', 'Fisheries and Aquatic Sciences'],\n department text, -- example: ['School of Applied Sciences, Technology and Educati...', 'Watershed Sciences Department', 'Economics and Finance Department'],\n college text, -- example: ['College of Agriculture and Applied Sciences', 'College of Natural Resources', 'School of Business'],\n PRIMARY KEY (major_id)\n );\n CREATE TABLE main.member (\n member_id text, -- example: ['rec1x5zBFIqoOuPW8', 'rec280Sk7o31iG0Tx', 'rec28ORZgcm1dtqBZ'],\n first_name text, -- example: ['Angela', 'Grant', 'Luisa'],\n last_name text, -- example: ['Sanders', 'Gilmour', 'Guidi'],\n email text,\n position text, -- example: ['Member', 'Inactive', 'President'],\n t_shirt_size text, -- example: ['Medium', 'X-Large', 'Large'],\n phone text, -- example: ['(651) 928-4507', '403-555-1310', '442-555-5882'],\n zip integer, -- example: [55108, 29440, 10002],\n link_to_major text, -- example: ['recxK3MHQFbR9J5uO', 'rec7BxKpjJ7bNph3O', 'recdIBgeU38UbV2sy'],\n PRIMARY KEY (member_id),\n CONSTRAINT fk_main_member_link_to_major FOREIGN KEY (link_to_major) REFERENCES major (major_id),\n CONSTRAINT fk_main_member_zip FOREIGN KEY (zip) REFERENCES zip_code (zip_code)\n );\n CREATE TABLE main.zip_code (\n zip_code integer, -- example: [501, 544, 601],\n type text, -- example: ['Unique', 'Standard', 'PO Box'],\n city text, -- example: ['Holtsville', 'Adjuntas', 'Aguada'],\n county text, -- example: ['Suffolk County', 'Adjuntas Municipio', 'Aguada Municipio'],\n state text, -- example: ['New York', 'Puerto Rico', 'Massachusetts'],\n short_state text, -- example: ['NY', 'PR', 'MA'],\n PRIMARY KEY (zip_code)\n );",12    "debit_card_specializing": " CREATE TABLE main.customers (\n CustomerID integer, -- example: [3, 5, 6],\n Segment text, -- example: ['SME', 'LAM', 'KAM'],\n Currency text, -- example: ['EUR', 'CZK'],\n PRIMARY KEY (CustomerID)\n );\n CREATE TABLE main.gasstations (\n GasStationID integer, -- example: [44, 45, 46],\n ChainID integer, -- example: [13, 6, 23],\n Country text, -- example: ['CZE', 'SVK'],\n Segment text, -- example: ['Value for money', 'Premium', 'Other'],\n PRIMARY KEY (GasStationID)\n );\n CREATE TABLE main.products (\n ProductID integer, -- example: [1, 2, 3],\n Description text, -- example: ['Rucn\u00ed zad\u00e1n\u00ed', 'Nafta', 'Special'],\n PRIMARY KEY (ProductID)\n );\n CREATE TABLE main.transactions_1k (\n TransactionID integer, -- example: [1, 2, 3],\n Date date, -- example: ['2012-08-24'],\n Time text, -- example: ['09:41:00', '10:03:00', '13:53:00'],\n CustomerID integer, -- example: [31543, 46707, 7654],\n CardID integer, -- example: [486621, 550134, 684220],\n GasStationID integer, -- example: [3704, 656, 741],\n ProductID integer, -- example: [2, 23, 5],\n Amount integer, -- example: [28, 18, 1],\n Price real, -- example: [672.64, 430.72, 121.99],\n PRIMARY KEY (TransactionID)\n );\n CREATE TABLE main.yearmonth (\n CustomerID integer, -- example: [39, 63, 172],\n Date text, -- example: ['201112', '201201', '201202'],\n Consumption real, -- example: [528.3, 1598.28, 1931.36],\n PRIMARY KEY (CustomerID, Date),\n CONSTRAINT fk_main_yearmonth_CustomerID FOREIGN KEY (CustomerID) REFERENCES customers (CustomerID)\n );"13}