Prize
8 rows where round_id = 134
This data as json, CSV (advanced)
| Link | rowid ▼ | round_id | prize_id | amount | keys |
|---|---|---|---|---|---|
| 560 | 560 | 2012-07-16 134 | FIRST_NEARBY 6 | 50000 | 904051 904049 |
| 561 | 561 | 2012-07-16 134 | FIRST 1 | 2000000 | 904050 |
| 562 | 562 | 2012-07-16 134 | SECOND 2 | 100000 | 560273 420284 210066 047572 860919 |
| 563 | 563 | 2012-07-16 134 | THIRD 3 | 40000 | 173368 938250 134397 491391 777457 005798 994110 729459 184875 123882 |
| 564 | 564 | 2012-07-16 134 | FOURTH 4 | 20000 | 477426 319889 343798 445285 825559 994521 919778 668271 644448 363894 813476 790855 423310 092005 414712 412791 761436 312779 311572 947530 372861 788128 448822 070060 994797 523908 935857 461656 764197 357382 928902 625896 358901 652944 481790 499723 377725 141594 108646 805992 304629 094659 057558 367204 986955 274620 926575 840599 637313 066497 |
| 565 | 565 | 2012-07-16 134 | FIFTH 5 | 10000 | 015445 022366 026463 041326 046412 054927 056121 064806 070938 073956 083200 085026 087619 093299 096594 115275 117929 125591 159686 168616 169252 169306 177267 182553 183537 190083 194058 216891 219209 227091 230421 252475 256754 266301 280522 294103 314954 339811 343240 353192 357984 380337 426155 429969 453116 498223 506116 526671 529326 534630 540062 543879 562832 566643 586235 588638 606488 614575 639418 660676 690368 690706 704384 712492 723893 729507 740320 744551 745486 746542 771000 771294 777331 792599 793149 794922 797150 809168 813094 815146 828404 831120 847852 850280 858272 866815 872569 881101 881383 891140 895713 897944 903198 904673 930373 967795 974368 975143 990737 994804 |
| 566 | 566 | 2012-07-16 134 | TWO 9 | 1000 | 11 |
| 567 | 567 | 2012-07-16 134 | THREE 7 | 2000 | 897 224 159 042 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE Prize(
round_id integer not null,
prize_id integer not null,
amount integer not null,
keys text not null,
foreign key (round_id) references Round(id),
foreign key (prize_id) references PrizeType(id)
);