Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 8,101–8,125 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 8101 | 3008101929928 | 4334 |
| 8102 | 3008102879166 | 4336 |
| 8103 | 3008103650001 | 4336 |
| 8104 | 3008104727631 | 4337 |
| 8105 | 3008105023939 | 4338 |
| 8106 | 3008106628867 | 4338 |
| 8107 | 3008107535595 | 4339 |
| 8108 | 3008108702730 | 4339 |
| 8109 | 3008109304126 | 4341 |
| 8110 | 3008110563658 | 4341 |
| 8111 | 3008111683597 | 4342 |
| 8112 | 3008112443981 | 4342 |
| 8113 | 3008113207721 | 4342 |
| 8114 | 3008114642477 | 4342 |
| 8115 | 3008115886030 | 4343 |
| 8116 | 3008116124676 | 4343 |
| 8117 | 3008117387677 | 4344 |
| 8118 | 3008118290443 | 4344 |
| 8119 | 3008119356537 | 4345 |
| 8120 | 3008120520413 | 4345 |
| 8121 | 3008121031347 | 4345 |
| 8122 | 3008122910342 | 4347 |
| 8123 | 3008123562264 | 4347 |
| 8124 | 3008124808778 | 4349 |
| 8125 | 3008125126919 | 4349 |
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;