Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 5,676–5,700 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 5676 | 3005676054440 | 3166 |
| 5677 | 3005677609909 | 3167 |
| 5678 | 3005678754877 | 3169 |
| 5679 | 3005679308192 | 3169 |
| 5680 | 3005680787880 | 3169 |
| 5681 | 3005681035400 | 3169 |
| 5682 | 3005682805127 | 3169 |
| 5683 | 3005683074222 | 3170 |
| 5684 | 3005684085338 | 3170 |
| 5685 | 3005685287789 | 3171 |
| 5686 | 3005686798468 | 3172 |
| 5687 | 3005687663479 | 3173 |
| 5688 | 3005688719616 | 3173 |
| 5689 | 3005689700742 | 3175 |
| 5690 | 3005690485918 | 3176 |
| 5691 | 3005691568589 | 3177 |
| 5692 | 3005692622445 | 3177 |
| 5693 | 3005693154979 | 3179 |
| 5694 | 3005694582571 | 3179 |
| 5695 | 3005695144980 | 3182 |
| 5696 | 3005696931989 | 3182 |
| 5697 | 3005697438054 | 3183 |
| 5698 | 3005698288177 | 3183 |
| 5699 | 3005699403984 | 3183 |
| 5700 | 3005700102830 | 3183 |
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;