Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 5,901–5,925 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 5901 | 3005901831139 | 3296 |
| 5902 | 3005902971538 | 3296 |
| 5903 | 3005903047100 | 3296 |
| 5904 | 3005904617191 | 3296 |
| 5905 | 3005905215734 | 3296 |
| 5906 | 3005906009020 | 3296 |
| 5907 | 3005907718674 | 3296 |
| 5908 | 3005908191040 | 3296 |
| 5909 | 3005909669090 | 3296 |
| 5910 | 3005910857847 | 3296 |
| 5911 | 3005911032121 | 3296 |
| 5912 | 3005912678079 | 3296 |
| 5913 | 3005913361652 | 3296 |
| 5914 | 3005914861309 | 3296 |
| 5915 | 3005915230112 | 3296 |
| 5916 | 3005916081435 | 3296 |
| 5917 | 3005917822219 | 3296 |
| 5918 | 3005918459341 | 3296 |
| 5919 | 3005919722993 | 3296 |
| 5920 | 3005920875045 | 3296 |
| 5921 | 3005921639034 | 3296 |
| 5922 | 3005922954065 | 3296 |
| 5923 | 3005923466172 | 3296 |
| 5924 | 3005924827770 | 3296 |
| 5925 | 3005925972882 | 3296 |
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;