Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 7,301–7,325 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 7301 | 3007301210094 | 3993 |
| 7302 | 3007302563002 | 3993 |
| 7303 | 3007303379891 | 3993 |
| 7304 | 3007304321637 | 3993 |
| 7305 | 3007305497194 | 3993 |
| 7306 | 3007306579699 | 3993 |
| 7307 | 3007307536132 | 3993 |
| 7308 | 3007308780389 | 3993 |
| 7309 | 3007309187731 | 3993 |
| 7310 | 3007310640843 | 3993 |
| 7311 | 3007311688912 | 3993 |
| 7312 | 3007312610459 | 3993 |
| 7313 | 3007313092690 | 3993 |
| 7314 | 3007314679442 | 3993 |
| 7315 | 3007315395616 | 3993 |
| 7316 | 3007316433989 | 3993 |
| 7317 | 3007317701583 | 3993 |
| 7318 | 3007318320864 | 3993 |
| 7319 | 3007319362589 | 3993 |
| 7320 | 3007320728762 | 3993 |
| 7321 | 3007321046827 | 3993 |
| 7322 | 3007322938473 | 3993 |
| 7323 | 3007323242694 | 3993 |
| 7324 | 3007324843299 | 3993 |
| 7325 | 3007325555155 | 3993 |
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;