Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- group: Tennis Tournament Database
- Country = {
- CTRYID, name
- CAN, CANADA
- ETH, ETHIOPIA
- USA, USA
- JAM, JAMAICA
- PHI, PHILLIPINES
- ISR, ISRAEL
- BAN, BANGLADESH
- FIN, FINLAND
- }
- Player = {
- PID, fname, lname, gender, activeSince, wins, losses, totalPoints, globalRank, ctryID
- 1, umar, abdulselam, male, 1997, 100, 0, 300, 100, ETH
- 2, hanan, faris, female, 1996, 96, 1, 299, 99, USA
- 3, tamim, chowdhury, male, 1995, 10, 10, 200, 99, BAN
- 4, francis, malcolm, male, 1996, 50, 10, 100, 67, JAM
- 5, patricia, reyes, female, 1995, 5, 17, 13, 6, PHI
- 6, jordan, cohen, male, 1993, 70, 45, 57, 53, ISR
- 7, musaab, abdulselam, male, 2005, 75, 24, 225, 2, CAN
- 8, nouf, yeslem, female, 1989, 99, 7, 9, 99, USA
- 9, samah, abdulselam, female, 1995, 61, 3, 45, 19, CAN
- 10, marwa, abdulselam, female, 2002, 89, 39, 87, 15, CAN
- 11, fatuma, yahya, female, 1974, 34, 21, 96, 76, ETH
- 12, mj, jemal, male, 1996, 78, 21, 97, 85, FIN
- 13, muadh, abdulselam, male, 1999, 89, 22, 87, 89, CAN
- 14, imran, abdulselam, male, 1999, 80, 22, 226, 89, FIN
- }
- Court = {
- CID, name, capacity
- 1, OldTrafford, 75000
- 2, Emptihad, 45000
- 3, Anfield, 75000
- }
- Tournament = {
- TID, slam, discipline
- 1, W, male
- 2, AO, female
- 3, FO, male
- 4, UO, male
- }
- Voucher = {
- VID, dateIssued, EID
- 1, 201910050001, 1
- 2, 201910061000, 2
- 3, 201910052359, 1
- 4, 201910060900, 2
- 5, 201910071100, 3
- 6, 201910041200, 4
- 7, 201910041200, 5
- 8, 201910041200, 5
- 9, 201910051200, 6
- 10, 201910051200, 6
- 11, 201910051200, 6
- 12, 201910051200, 7
- 13, 201910111100, 8
- 14, 201910111000, 8
- 15, 201910051200, 9
- }
- Event = {
- EID, date, tournID, courtID, playerA, playerB, setswonA, setswonB
- 1, 201910052359, 1, 1, 1, 12, 0, 3
- 2, 201910061100, 1, 1, 1, 7, 0, 3
- 3, 201910071100, 1, 2, 1, 3, 0, 4
- 4, 201910081100, 1, 3, 12, 5, 2, 1
- 5, 201910091100, 1, 2, 2, 8, 1, 2
- 6, 201910091100, 1, 2, 8, 11, 1, 1
- 7, 201910101100, 1, 2, 9, 10, 1, 2
- 8, 201910111100, 1, 2, 9, 11, 0, 3
- 9, 201910111100, 1, 2, 2, 9, 3, 0
- 10, 201910111100, 1, 2, 3, 4, 3, 0
- 11, 201910121100, 1, 2, 3, 6, 3, 0
- 12, 201910121100, 1, 2, 4, 6, 0, 3
- 13, 201910121100, 1, 2, 5, 8, 3, 0
- 14, 201910131100, 1, 2, 13, 11, 2, 1
- 15, 201910131100, 1, 2, 1, 4, 3, 0
- 16, 201910131100, 1, 2, 7, 3, 3, 0
- 17, 201910141100, 1, 2, 7, 4, 1, 2
- 18, 201910141100, 1, 2, 7, 6, 2, 1
- 19, 201910141100, 1, 2, 11, 2, 0, 3
- 20, 201910151100, 1, 2, 5, 10, 0, 3
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement