Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 8,076–8,100 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 8076 | 3008076479870 | 4311 |
| 8077 | 3008077506762 | 4312 |
| 8078 | 3008078605123 | 4313 |
| 8079 | 3008079657135 | 4313 |
| 8080 | 3008080333319 | 4313 |
| 8081 | 3008081408296 | 4316 |
| 8082 | 3008082002779 | 4317 |
| 8083 | 3008083008538 | 4319 |
| 8084 | 3008084206126 | 4319 |
| 8085 | 3008085370884 | 4321 |
| 8086 | 3008086725953 | 4322 |
| 8087 | 3008087198483 | 4323 |
| 8088 | 3008088876899 | 4324 |
| 8089 | 3008089096241 | 4324 |
| 8090 | 3008090292115 | 4325 |
| 8091 | 3008091656744 | 4325 |
| 8092 | 3008092734340 | 4325 |
| 8093 | 3008093572562 | 4328 |
| 8094 | 3008094263762 | 4328 |
| 8095 | 3008095617163 | 4329 |
| 8096 | 3008096692597 | 4329 |
| 8097 | 3008097597333 | 4331 |
| 8098 | 3008098723945 | 4331 |
| 8099 | 3008099958575 | 4333 |
| 8100 | 3008100491335 | 4333 |
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;