Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 9,601–9,625 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 9601 | 3009601373598 | 5220 |
| 9602 | 3009602405983 | 5220 |
| 9603 | 3009603199014 | 5220 |
| 9604 | 3009604854331 | 5220 |
| 9605 | 3009605853724 | 5223 |
| 9606 | 3009606034430 | 5223 |
| 9607 | 3009607555928 | 5224 |
| 9608 | 3009608238566 | 5224 |
| 9609 | 3009609922044 | 5226 |
| 9610 | 3009610419742 | 5226 |
| 9611 | 3009611633188 | 5226 |
| 9612 | 3009612690639 | 5226 |
| 9613 | 3009613602180 | 5226 |
| 9614 | 3009614801875 | 5228 |
| 9615 | 3009615378739 | 5228 |
| 9616 | 3009616533208 | 5228 |
| 9617 | 3009617651783 | 5229 |
| 9618 | 3009618336285 | 5231 |
| 9619 | 3009619801377 | 5231 |
| 9620 | 3009620296050 | 5233 |
| 9621 | 3009621136861 | 5234 |
| 9622 | 3009622956343 | 5234 |
| 9623 | 3009623985227 | 5236 |
| 9624 | 3009624286025 | 5236 |
| 9625 | 3009625583905 | 5238 |
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;