Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 9,101–9,125 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 9101 | 3009101910458 | 4901 |
| 9102 | 3009102815960 | 4901 |
| 9103 | 3009103058777 | 4901 |
| 9104 | 3009104386419 | 4904 |
| 9105 | 3009105522121 | 4904 |
| 9106 | 3009106924134 | 4904 |
| 9107 | 3009107446965 | 4905 |
| 9108 | 3009108344203 | 4905 |
| 9109 | 3009109730697 | 4907 |
| 9110 | 3009110697091 | 4907 |
| 9111 | 3009111462875 | 4907 |
| 9112 | 3009112735996 | 4907 |
| 9113 | 3009113430554 | 4908 |
| 9114 | 3009114664064 | 4908 |
| 9115 | 3009115329172 | 4910 |
| 9116 | 3009116281223 | 4911 |
| 9117 | 3009117632035 | 4913 |
| 9118 | 3009118875477 | 4913 |
| 9119 | 3009119845313 | 4915 |
| 9120 | 3009120411618 | 4915 |
| 9121 | 3009121593705 | 4917 |
| 9122 | 3009122649798 | 4918 |
| 9123 | 3009123612923 | 4918 |
| 9124 | 3009124683750 | 4918 |
| 9125 | 3009125387558 | 4918 |
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;