Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 6,701–6,725 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 6701 | 3006701770480 | 3661 |
| 6702 | 3006702760743 | 3662 |
| 6703 | 3006703647935 | 3662 |
| 6704 | 3006704556311 | 3664 |
| 6705 | 3006705641556 | 3664 |
| 6706 | 3006706534716 | 3664 |
| 6707 | 3006707486665 | 3664 |
| 6708 | 3006708804026 | 3666 |
| 6709 | 3006709694748 | 3666 |
| 6710 | 3006710905463 | 3668 |
| 6711 | 3006711073151 | 3669 |
| 6712 | 3006712924784 | 3669 |
| 6713 | 3006713321742 | 3670 |
| 6714 | 3006714940640 | 3670 |
| 6715 | 3006715290780 | 3670 |
| 6716 | 3006716818530 | 3671 |
| 6717 | 3006717615655 | 3671 |
| 6718 | 3006718777923 | 3673 |
| 6719 | 3006719970667 | 3673 |
| 6720 | 3006720880957 | 3674 |
| 6721 | 3006721744349 | 3675 |
| 6722 | 3006722231869 | 3675 |
| 6723 | 3006723485151 | 3675 |
| 6724 | 3006724258356 | 3675 |
| 6725 | 3006725637446 | 3676 |
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;