EECS3421 ass1 test data

gistfile1.txt

-- this is an example

group: nameOfTheNewGroup 


Country = {
	CTRYID:string, name:string
	US,  UNITED_STATES
	CAN,  CANADA
	CN,  CHINA
	RU,  RUSSIAN
	JP, JAPAN
}

Player = {
	PID:number, fname:string, lname:string, gender:string,activeSince:number,wins:number,losses:number,totalPoints:number,globalRank:number,ctryID:string
	1,Glen,Huckstepp,Male,20190913,12,25,5207,1,CN
	2,Trent,Aylen,Male,20190610,72,63,6266,2,CA
	3,Dallas,Gheorghie,Male,20190309,73,37,641,3,CN
	4,Jannelle,Burchall,Female,20190504,66,97,5803,4,CN
	5,Kin,Hinge,Male,20190920,67,28,3939,5,CN
	6,Gwynne,Timmes,Female,20181203,35,57,9224,6,CN
	7,Akim,Luckcuck,Male,20190830,8,48,6154,7,CN
	8,Hagan,Lane,Male,20190402,47,39,1638,8,CN
	9,Guntar,Oland,Male,20190105,19,41,8824,9,US
	10,Agneta,Smuth,Female,20190724,91,57,2143,10,CN
	11,Darrin,Teall,Male,20181215,51,22,9460,11,CN
	12,Janeen,Menzies,Female,20181220,17,77,4921,12,US
	13,Eberhard,Conaghan,Male,20190519,31,33,7623,13,CN
	14,Reeva,Ransfield,Female,20190702,37,89,3716,14,RU
	15,Lexy,Jacobowits,Female,20190315,86,39,4333,15,RU
	16,Portia,Carme,Female,20181126,67,53,3589,16,CN
	17,Maxie,Mattusevich,Female,20190309,29,86,2839,17,RU
	18,Field,Kingdom,Male,20190409,8,97,2600,18,RU
	19,Stephan,Shynn,Male,20190924,29,81,3407,19,CN
	20,Court,Troak,Male,20190224,79,99,6805,20,CA
	21,Merrel,Agostini,Male,20190730,55,66,9144,21,CN
	22,Seward,Bewicke,Male,20190326,1,69,8620,22,CA
	23,Livvy,Cottham,Female,20190528,94,64,1588,23,RU
	24,Alastair,Bradden,Male,20190218,86,83,5748,24,CN
	25,Brnaby,Dunks,Male,20181020,8,73,8013,25,RU
	26,Cesare,Uzielli,Male,20190416,26,98,4911,26,CN
	27,Kalinda,Tuckey,Female,20190408,98,13,5189,27,CN
	28,Chrisse,Nineham,Male,20190414,30,15,2186,28,RU
	29,Maude,Oakley,Female,20190526,96,6,6718,29,CN
	30,Haze,Cliss,Male,20190819,41,63,2845,30,RU
	31,Lindie,Murdoch,Female,20190430,39,25,1553,31,RU
	32,Bartolemo,Langsdon,Male,20191001,18,76,1718,32,CN
	33,Leodora,Kick,Female,20190405,28,33,7927,33,CN
	34,Kyla,Loughren,Female,20190228,25,83,6606,34,CN
	35,Traci,Spillett,Female,20181230,24,66,9966,35,CN
	36,Noell,Klazenga,Female,20190919,7,46,1424,36,CA
	37,Ruby,Linklater,Male,20181122,52,5,4498,37,JP
	38,Aloisia,Doubrava,Female,20190210,49,35,958,38,CN
	39,Sharline,Gomar,Female,20190118,13,57,1647,39,US
	40,Karleen,Birkwood,Female,20190426,60,37,1010,40,CN
	41,Riccardo,Frith,Male,20190221,70,82,4610,41,CN
	42,Kelvin,Habeshaw,Male,20190323,94,39,1776,42,RU
	43,Teddie,Chorley,Female,20190408,28,64,947,43,CN
	44,Shelby,Tretter,Male,20190622,79,98,5817,44,CN
	45,Syd,Mayhew,Male,20181116,66,70,9685,45,CN
	46,Julian,Chippendale,Male,20190830,98,2,1197,46,US
	47,Daffie,Isacq,Female,20181219,42,16,7932,47,CN
	48,Seth,Petkov,Male,20190531,84,46,8351,48,CN
	49,Marcus,Edmonson,Male,20190707,11,50,8281,49,CN
	50,Phil,Abberley,Male,20190831,31,100,8520,50,CN
	51,Lolly,Bowery,Female,20190702,79,71,2896,51,US
	52,Sal,Horche,Female,20181112,27,7,4152,52,RU
	53,Iseabal,Shires,Female,20181123,90,39,4866,53,RU
	54,Cesar,Carnier,Male,20191003,47,76,3732,54,RU
	55,Edithe,Kleisle,Female,20181218,11,51,4256,55,CN
	56,Quinta,Chisnell,Female,20190912,78,37,6179,56,RU
	57,Boycey,Lovemore,Male,20190822,3,5,1336,57,JP
	58,Anallese,Giacomi,Female,20190424,17,73,1058,58,RU
	59,Keen,Willetts,Male,20181031,2,58,1966,59,US
	60,Alick,Howels,Male,20190710,94,36,8366,60,RU
	61,Nanny,Cutriss,Female,20190324,80,25,6139,61,CN
	62,Eula,Cantor,Female,20190713,84,61,1222,62,US
	63,Bronson,Remnant,Male,20190723,4,62,7460,63,CN
	64,Nicola,Mitchelmore,Female,20181127,1,87,1627,64,CN
	65,Danice,Blaker,Female,20181112,46,96,2779,65,US
	66,Elsie,Tatters,Female,20181208,48,65,8936,66,CN
	67,Ella,Poacher,Female,20190324,80,67,2196,67,US
	68,Rhoda,Kiendl,Female,20190211,77,81,9107,68,CN
	69,Giovanna,Bineham,Female,20190514,49,75,1525,69,CN
	70,Ardath,Roony,Female,20181015,24,84,6870,70,CN
	71,Stewart,Skeath,Male,20190522,89,2,1217,71,CN
	72,Sallyann,Hubbucke,Female,20190601,99,26,8694,72,CN
	73,Salomo,Cerie,Male,20181112,100,68,5667,73,CN
	74,Loree,Wiggall,Female,20181012,58,38,5233,74,RU
	75,Trudey,Hawyes,Female,20190221,98,27,2153,75,CN
	76,Ario,Beynke,Male,20190219,4,86,6544,76,RU
	77,Stillmann,Haxell,Male,20190714,60,93,5061,77,US
	78,Ode,Callard,Male,20190907,33,79,1600,78,JP
	79,Merrily,Dacke,Female,20190308,60,45,5528,79,CA
	80,Zorina,Galway,Female,20190614,64,20,7136,80,CN
	81,Vern,Ballantyne,Male,20190802,19,82,6625,81,CN
	82,Shoshanna,Dignan,Female,20190628,54,16,2500,82,CN
	83,Ingamar,Cleft,Male,20190105,13,24,5739,83,CA
	84,Cherida,Dulinty,Female,20190711,47,3,9746,84,RU
	85,Tyler,Stockhill,Male,20190826,65,26,3005,85,US
	86,Romona,Indgs,Female,20190221,51,89,2966,86,CN
	87,Ashley,Dykins,Male,20190703,86,72,8174,87,CN
	88,Verge,Soppeth,Male,20181113,26,39,7974,88,CN
	89,Ave,Peterffy,Male,20190427,1,62,4647,89,JP
	90,Dominic,Penniall,Male,20190408,43,50,7431,90,CN
	91,Chandra,Thornhill,Female,20181019,7,47,7476,91,CN
	92,Price,Whitehurst,Male,20181202,8,55,5019,92,JP
	93,Deedee,Cristou,Female,20190712,86,3,761,93,JP
	94,Terrijo,Nafzger,Female,20190226,51,43,9525,94,CN
	95,Patti,Gue,Female,20190427,87,64,1823,95,CN
	96,Andie,Ducrow,Male,20190530,71,74,917,96,CN
	97,Isac,Labden,Male,20181116,45,5,7739,97,CN
	98,Hugues,Lummis,Male,20190330,50,89,1935,98,RU
	99,Fernanda,MacCroary,Female,20190121,55,24,8006,99,CN
	100,Karlyn,Gatrill,Female,20190913,9,78,6219,100,CN
}

Court = {
	CID:number, name:string,capacity:number
	001,  shinNipori,4000
	002,  AVIVA,1
	003,  whhhah,50000
	004,  gagarinStart,60000
}

Tournament={
	TID:number,slam:string,dsipline:string
	21,AO,female
	22,AO,male
	31,FO,female
	32,FO,male
	41,UO,female
	42,UO,male
	51,W,female
	52,W,male
}

Voucher={
	VID:number,dateIssued:number,EID:number
	10083,201803191115,0079
	10084,201803191115,0079
	10085,201803191115,0079
	10086,201803191115,0079
	10087,201803151430,0079
	10088,201904052030,0080
	10089,201906041730,0081
	10090,201803191115,0082
	10091,201803151530,0080
	10092,201904052030,0081
	10093,201906041730,0082
	10094,201906041730,0089
}

Event={
	EID:number,date:number,tournID:number,courtID:number,playerA:number,playerB:number,setswonA:number,setswonB:number
 0079,20180320,32,001,3,7,4,3
 0080,20180320,31,002,43,47,3,4
 0081,20190406,31,003,51,52,2,5
 0082,20190405,32,003,78,81,1,4
 0083,20190605,52,001,89,63,2,5
 0084,20180316,21,003,95,99,2,5
 0085,20180316,22,001,98,97,3,4
 0086,20180316,22,004,98,97,3,4
 0089,20190605,41,003,66,67,2,5
}