Prize
8 rows where round_id = 1
This data as json, CSV (advanced)
| Link | rowid ▼ | round_id | prize_id | amount | keys |
|---|---|---|---|---|---|
| 1 | 1 | 2007-12-01 1 | FIRST 1 | 2000000 | 113410 |
| 2 | 2 | 2007-12-01 1 | SECOND 2 | 100000 | 649320 730224 775857 809782 916738 |
| 3 | 3 | 2007-12-01 1 | THIRD 3 | 40000 | 071443 165883 355375 391620 833247 151772 273768 369190 421744 982277 |
| 4 | 4 | 2007-12-01 1 | FOURTH 4 | 20000 | 128613 212667 379875 561992 788943 131148 213091 388579 567147 815943 140843 267183 393926 598388 852268 147695 285312 401386 632425 855902 158012 286396 442808 636254 859656 166031 287909 471803 663928 888954 166545 293750 480545 672735 909567 198826 300508 496521 740146 921725 203869 302757 544231 751903 926377 212614 374693 561909 760279 941622 |
| 5 | 5 | 2007-12-01 1 | FIFTH 5 | 10000 | 016676 171415 367091 614308 796093 040926 172040 367974 620618 796512 045739 174539 379014 631494 805345 052128 181086 393686 633943 823134 053942 187428 398703 650539 825964 063104 197785 400241 656561 871309 083371 226817 422873 661112 876162 087468 237699 461349 664525 884986 088360 271069 476734 673082 903012 107757 283707 492397 673949 914648 123707 320273 496595 674767 924925 124131 321583 521320 677177 947467 127058 321810 525977 677542 948890 127641 323782 532030 686749 963722 130283 325253 590568 706382 979309 132472 332634 592875 707442 984033 148445 344837 598982 718220 985541 155659 363241 600140 721175 988191 161643 363692 601569 740960 991813 164642 366730 612039 775377 996768 |
| 6 | 6 | 2007-12-01 1 | FIRST_NEARBY 6 | 50000 | 113409 113411 |
| 7 | 7 | 2007-12-01 1 | THREE 7 | 2000 | 418 485 627 659 |
| 8 | 8 | 2007-12-01 1 | TWO 9 | 1000 | 18 |
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)
);