Prize
8 rows where round_id = 135
This data as json, CSV (advanced)
| Link | rowid ▼ | round_id | prize_id | amount | keys |
|---|---|---|---|---|---|
| 552 | 552 | 2012-08-01 135 | FIRST_NEARBY 6 | 50000 | 895589 895591 |
| 553 | 553 | 2012-08-01 135 | FIRST 1 | 2000000 | 895590 |
| 554 | 554 | 2012-08-01 135 | SECOND 2 | 100000 | 516488 883421 932739 118054 127106 |
| 555 | 555 | 2012-08-01 135 | THIRD 3 | 40000 | 489109 151813 603021 291902 194695 552549 776647 871671 110903 328457 |
| 556 | 556 | 2012-08-01 135 | FOURTH 4 | 20000 | 051400 057774 080481 115350 145772 160186 169736 198450 205280 219397 225699 232194 248243 311309 326928 330293 387095 409936 413741 445778 445955 449563 472018 544035 578666 603434 621932 630087 655668 702140 738578 760190 761151 768258 785921 791600 807093 857287 857399 876150 882998 884712 888371 889027 910061 934315 941838 955374 961677 987051 |
| 557 | 557 | 2012-08-01 135 | FIFTH 5 | 10000 | 662356 561085 839436 513754 523739 878520 327814 082670 108135 986796 183767 513784 279448 440236 048661 518831 815834 435138 018753 160203 623953 730312 734732 620285 060502 924612 817174 998458 246505 803117 982084 055264 762191 617762 928740 317289 520766 782374 689484 342711 563007 243698 019691 936385 302705 246343 968136 191735 218904 019698 555322 449271 991360 221704 237639 358479 245781 783464 255269 557183 607331 072479 804995 168579 100474 767091 510412 964622 623789 236568 654731 699694 297735 245392 662810 737291 957813 800437 644173 694402 012902 440023 672835 277964 420621 876069 805264 760495 924711 151159 971034 601227 466013 738923 084580 181202 314427 456905 012901 690613 |
| 558 | 558 | 2012-08-01 135 | TWO 9 | 1000 | 50 |
| 559 | 559 | 2012-08-01 135 | THREE 7 | 2000 | 820 599 796 745 |
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)
);