Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 9,576–9,600 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 9576 | 3009576914101 | 5197 |
| 9577 | 3009577556600 | 5197 |
| 9578 | 3009578766733 | 5198 |
| 9579 | 3009579812797 | 5199 |
| 9580 | 3009580953458 | 5203 |
| 9581 | 3009581805188 | 5204 |
| 9582 | 3009582129171 | 5205 |
| 9583 | 3009583951374 | 5207 |
| 9584 | 3009584852177 | 5207 |
| 9585 | 3009585143446 | 5207 |
| 9586 | 3009586280626 | 5207 |
| 9587 | 3009587372795 | 5207 |
| 9588 | 3009588458903 | 5208 |
| 9589 | 3009589612536 | 5208 |
| 9590 | 3009590825927 | 5210 |
| 9591 | 3009591854330 | 5211 |
| 9592 | 3009592312638 | 5211 |
| 9593 | 3009593772228 | 5212 |
| 9594 | 3009594145889 | 5212 |
| 9595 | 3009595046705 | 5213 |
| 9596 | 3009596915169 | 5213 |
| 9597 | 3009597713712 | 5213 |
| 9598 | 3009598667145 | 5214 |
| 9599 | 3009599861477 | 5218 |
| 9600 | 3009600330480 | 5218 |
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;