PrizeType

9 rows where lotto_id = 1

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ lotto_id name
1 L6 1 FIRST
2 L6 1 SECOND
3 L6 1 THIRD
4 L6 1 FOURTH
5 L6 1 FIFTH
6 L6 1 FIRST_NEARBY
7 L6 1 THREE
8 L6 1 THREE_FRONT
9 L6 1 TWO

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE PrizeType(
    id integer primary key,
    lotto_id  integer not null,
    name text integer not null,
    foreign key (lotto_id) references LottoType(id)
);