Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 6,576–6,600 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 6576 | 3006576520291 | 3627 |
| 6577 | 3006577277391 | 3627 |
| 6578 | 3006578443183 | 3627 |
| 6579 | 3006579170711 | 3627 |
| 6580 | 3006580116217 | 3628 |
| 6581 | 3006581655971 | 3628 |
| 6582 | 3006582779872 | 3628 |
| 6583 | 3006583049976 | 3629 |
| 6584 | 3006584734592 | 3629 |
| 6585 | 3006585065338 | 3630 |
| 6586 | 3006586070790 | 3630 |
| 6587 | 3006587125362 | 3631 |
| 6588 | 3006588919165 | 3632 |
| 6589 | 3006589359127 | 3632 |
| 6590 | 3006590772071 | 3632 |
| 6591 | 3006591066493 | 3632 |
| 6592 | 3006592784510 | 3632 |
| 6593 | 3006593747683 | 3633 |
| 6594 | 3006594519732 | 3633 |
| 6595 | 3006595674007 | 3633 |
| 6596 | 3006596317173 | 3633 |
| 6597 | 3006597360223 | 3633 |
| 6598 | 3006598504089 | 3635 |
| 6599 | 3006599269608 | 3635 |
| 6600 | 3006600536077 | 3635 |
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;