Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 9,401–9,425 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 9401 | 3009401039671 | 5064 |
| 9402 | 3009402662621 | 5064 |
| 9403 | 3009403598209 | 5067 |
| 9404 | 3009404717630 | 5069 |
| 9405 | 3009405436998 | 5069 |
| 9406 | 3009406870772 | 5069 |
| 9407 | 3009407546613 | 5069 |
| 9408 | 3009408993125 | 5070 |
| 9409 | 3009409921009 | 5070 |
| 9410 | 3009410457827 | 5071 |
| 9411 | 3009411259835 | 5071 |
| 9412 | 3009412263514 | 5072 |
| 9413 | 3009413153029 | 5073 |
| 9414 | 3009414086261 | 5074 |
| 9415 | 3009415949921 | 5079 |
| 9416 | 3009416297953 | 5079 |
| 9417 | 3009417758193 | 5080 |
| 9418 | 3009418566093 | 5080 |
| 9419 | 3009419949941 | 5081 |
| 9420 | 3009420798599 | 5081 |
| 9421 | 3009421581185 | 5084 |
| 9422 | 3009422817827 | 5084 |
| 9423 | 3009423922117 | 5085 |
| 9424 | 3009424597269 | 5088 |
| 9425 | 3009425498077 | 5088 |
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;