Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 9,226–9,250 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 9226 | 3009226023110 | 4967 |
| 9227 | 3009227879531 | 4967 |
| 9228 | 3009228225863 | 4968 |
| 9229 | 3009229221912 | 4968 |
| 9230 | 3009230770272 | 4969 |
| 9231 | 3009231830743 | 4969 |
| 9232 | 3009232676370 | 4969 |
| 9233 | 3009233461652 | 4969 |
| 9234 | 3009234017507 | 4970 |
| 9235 | 3009235759555 | 4970 |
| 9236 | 3009236817103 | 4972 |
| 9237 | 3009237555157 | 4972 |
| 9238 | 3009238538690 | 4972 |
| 9239 | 3009239886429 | 4973 |
| 9240 | 3009240233791 | 4973 |
| 9241 | 3009241162354 | 4974 |
| 9242 | 3009242444528 | 4974 |
| 9243 | 3009243050649 | 4974 |
| 9244 | 3009244235046 | 4974 |
| 9245 | 3009245477948 | 4974 |
| 9246 | 3009246019173 | 4974 |
| 9247 | 3009247634472 | 4974 |
| 9248 | 3009248641509 | 4974 |
| 9249 | 3009249018473 | 4974 |
| 9250 | 3009250017393 | 4974 |
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;