Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 9,451–9,475 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 9451 | 3009451397890 | 5101 |
| 9452 | 3009452759842 | 5101 |
| 9453 | 3009453404051 | 5101 |
| 9454 | 3009454454664 | 5102 |
| 9455 | 3009455459474 | 5102 |
| 9456 | 3009456244828 | 5102 |
| 9457 | 3009457867877 | 5102 |
| 9458 | 3009458362047 | 5102 |
| 9459 | 3009459796172 | 5103 |
| 9460 | 3009460659998 | 5103 |
| 9461 | 3009461220855 | 5103 |
| 9462 | 3009462445308 | 5103 |
| 9463 | 3009463766598 | 5105 |
| 9464 | 3009464861566 | 5105 |
| 9465 | 3009465532320 | 5106 |
| 9466 | 3009466499892 | 5106 |
| 9467 | 3009467485811 | 5106 |
| 9468 | 3009468592824 | 5108 |
| 9469 | 3009469501900 | 5108 |
| 9470 | 3009470168946 | 5109 |
| 9471 | 3009471085149 | 5109 |
| 9472 | 3009472488305 | 5109 |
| 9473 | 3009473602031 | 5109 |
| 9474 | 3009474625546 | 5111 |
| 9475 | 3009475004206 | 5111 |
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;