Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 8,326–8,350 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 8326 | 3008326741579 | 4493 |
| 8327 | 3008327725687 | 4494 |
| 8328 | 3008328375464 | 4494 |
| 8329 | 3008329754446 | 4495 |
| 8330 | 3008330644151 | 4496 |
| 8331 | 3008331979251 | 4496 |
| 8332 | 3008332871901 | 4497 |
| 8333 | 3008333899100 | 4502 |
| 8334 | 3008334012780 | 4502 |
| 8335 | 3008335524144 | 4502 |
| 8336 | 3008336858073 | 4503 |
| 8337 | 3008337107617 | 4504 |
| 8338 | 3008338228366 | 4505 |
| 8339 | 3008339908692 | 4505 |
| 8340 | 3008340926104 | 4508 |
| 8341 | 3008341598891 | 4508 |
| 8342 | 3008342465706 | 4512 |
| 8343 | 3008343123686 | 4512 |
| 8344 | 3008344450632 | 4512 |
| 8345 | 3008345816270 | 4512 |
| 8346 | 3008346398791 | 4512 |
| 8347 | 3008347869786 | 4513 |
| 8348 | 3008348452659 | 4513 |
| 8349 | 3008349016977 | 4513 |
| 8350 | 3008350246481 | 4513 |
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;