Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 9,626–9,650 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 9626 | 3009626760658 | 5239 |
| 9627 | 3009627608705 | 5239 |
| 9628 | 3009628783083 | 5243 |
| 9629 | 3009629382146 | 5243 |
| 9630 | 3009630243434 | 5244 |
| 9631 | 3009631743242 | 5244 |
| 9632 | 3009632355614 | 5245 |
| 9633 | 3009633758052 | 5245 |
| 9634 | 3009634692410 | 5247 |
| 9635 | 3009635762345 | 5247 |
| 9636 | 3009636623377 | 5247 |
| 9637 | 3009637207123 | 5247 |
| 9638 | 3009638064659 | 5248 |
| 9639 | 3009639738306 | 5248 |
| 9640 | 3009640154418 | 5249 |
| 9641 | 3009641223442 | 5253 |
| 9642 | 3009642470616 | 5253 |
| 9643 | 3009643473325 | 5254 |
| 9644 | 3009644984339 | 5258 |
| 9645 | 3009645666334 | 5258 |
| 9646 | 3009646310419 | 5260 |
| 9647 | 3009647359044 | 5262 |
| 9648 | 3009648582322 | 5263 |
| 9649 | 3009649025669 | 5263 |
| 9650 | 3009650193259 | 5264 |
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;