Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 9,426–9,450 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 9426 | 3009426575176 | 5090 |
| 9427 | 3009427344784 | 5090 |
| 9428 | 3009428038141 | 5091 |
| 9429 | 3009429677468 | 5091 |
| 9430 | 3009430409796 | 5092 |
| 9431 | 3009431568013 | 5092 |
| 9432 | 3009432679991 | 5092 |
| 9433 | 3009433847536 | 5092 |
| 9434 | 3009434427350 | 5093 |
| 9435 | 3009435553902 | 5094 |
| 9436 | 3009436464305 | 5094 |
| 9437 | 3009437031414 | 5095 |
| 9438 | 3009438397276 | 5095 |
| 9439 | 3009439192346 | 5096 |
| 9440 | 3009440429191 | 5096 |
| 9441 | 3009441278800 | 5096 |
| 9442 | 3009442609016 | 5096 |
| 9443 | 3009443579699 | 5097 |
| 9444 | 3009444054568 | 5097 |
| 9445 | 3009445083109 | 5097 |
| 9446 | 3009446296743 | 5097 |
| 9447 | 3009447700005 | 5097 |
| 9448 | 3009448242464 | 5100 |
| 9449 | 3009449968773 | 5101 |
| 9450 | 3009450755784 | 5101 |
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;