Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 9,476–9,500 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 9476 | 3009476217459 | 5112 |
| 9477 | 3009477951101 | 5112 |
| 9478 | 3009478189575 | 5114 |
| 9479 | 3009479751496 | 5115 |
| 9480 | 3009480107915 | 5116 |
| 9481 | 3009481954650 | 5116 |
| 9482 | 3009482990486 | 5116 |
| 9483 | 3009483915669 | 5116 |
| 9484 | 3009484260719 | 5119 |
| 9485 | 3009485969934 | 5119 |
| 9486 | 3009486744960 | 5119 |
| 9487 | 3009487910024 | 5121 |
| 9488 | 3009488098011 | 5122 |
| 9489 | 3009489588656 | 5122 |
| 9490 | 3009490366433 | 5122 |
| 9491 | 3009491208475 | 5123 |
| 9492 | 3009492979692 | 5123 |
| 9493 | 3009493031904 | 5124 |
| 9494 | 3009494780995 | 5125 |
| 9495 | 3009495286316 | 5126 |
| 9496 | 3009496736347 | 5126 |
| 9497 | 3009497364366 | 5128 |
| 9498 | 3009498761148 | 5128 |
| 9499 | 3009499084691 | 5128 |
| 9500 | 3009500520049 | 5128 |
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;