Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 7,626–7,650 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 7626 | 3007626199210 | 4110 |
| 7627 | 3007627941290 | 4110 |
| 7628 | 3007628451856 | 4111 |
| 7629 | 3007629237029 | 4111 |
| 7630 | 3007630030109 | 4112 |
| 7631 | 3007631692278 | 4112 |
| 7632 | 3007632077447 | 4113 |
| 7633 | 3007633841711 | 4114 |
| 7634 | 3007634278592 | 4114 |
| 7635 | 3007635889430 | 4114 |
| 7636 | 3007636594399 | 4116 |
| 7637 | 3007637833806 | 4116 |
| 7638 | 3007638862947 | 4117 |
| 7639 | 3007639108988 | 4117 |
| 7640 | 3007640684431 | 4119 |
| 7641 | 3007641182672 | 4119 |
| 7642 | 3007642123132 | 4119 |
| 7643 | 3007643419864 | 4119 |
| 7644 | 3007644800394 | 4120 |
| 7645 | 3007645442186 | 4122 |
| 7646 | 3007646873555 | 4125 |
| 7647 | 3007647700162 | 4125 |
| 7648 | 3007648977267 | 4125 |
| 7649 | 3007649722276 | 4125 |
| 7650 | 3007650248833 | 4125 |
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;