Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 1,926–1,950 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 1926 | 3001926948944 | 1055 |
| 1927 | 3001927308289 | 1055 |
| 1928 | 3001928514310 | 1055 |
| 1929 | 3001929260136 | 1055 |
| 1930 | 3001930867720 | 1055 |
| 1931 | 3001931995889 | 1055 |
| 1932 | 3001932839132 | 1055 |
| 1933 | 3001933979989 | 1055 |
| 1934 | 3001934418003 | 1055 |
| 1935 | 3001935374470 | 1055 |
| 1936 | 3001936497676 | 1055 |
| 1937 | 3001937494157 | 1055 |
| 1938 | 3001938326617 | 1055 |
| 1939 | 3001939730389 | 1055 |
| 1940 | 3001940517518 | 1055 |
| 1941 | 3001941884501 | 1055 |
| 1942 | 3001942346309 | 1055 |
| 1943 | 3001943053917 | 1055 |
| 1944 | 3001944670153 | 1055 |
| 1945 | 3001945944838 | 1055 |
| 1946 | 3001946150638 | 1055 |
| 1947 | 3001947656738 | 1055 |
| 1948 | 3001948414360 | 1055 |
| 1949 | 3001949643226 | 1055 |
| 1950 | 3001950448432 | 1056 |
Table definition
CREATE TABLE ticket (
ticket_id INTEGER PRIMARY KEY,
barcode TEXT NOT NULL UNIQUE CHECK (length(barcode) = 13 AND barcode NOT GLOB '*[^0-9]*'),
order_id INTEGER NOT NULL REFERENCES purchase_order (order_id)
) STRICT;