Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 3,551–3,575 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 3551 | 3003551825368 | 1946 |
| 3552 | 3003552760675 | 1946 |
| 3553 | 3003553316304 | 1947 |
| 3554 | 3003554228242 | 1947 |
| 3555 | 3003555836738 | 1947 |
| 3556 | 3003556672312 | 1948 |
| 3557 | 3003557278192 | 1949 |
| 3558 | 3003558167377 | 1950 |
| 3559 | 3003559091675 | 1951 |
| 3560 | 3003560148099 | 1954 |
| 3561 | 3003561581395 | 1955 |
| 3562 | 3003562162834 | 1955 |
| 3563 | 3003563791209 | 1958 |
| 3564 | 3003564099178 | 1959 |
| 3565 | 3003565374258 | 1959 |
| 3566 | 3003566496613 | 1959 |
| 3567 | 3003567353500 | 1959 |
| 3568 | 3003568504091 | 1961 |
| 3569 | 3003569354812 | 1961 |
| 3570 | 3003570300871 | 1962 |
| 3571 | 3003571067442 | 1962 |
| 3572 | 3003572321042 | 1963 |
| 3573 | 3003573512005 | 1963 |
| 3574 | 3003574617520 | 1963 |
| 3575 | 3003575830764 | 1963 |
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;