Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 8,251–8,275 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 8251 | 3008251037371 | 4433 |
| 8252 | 3008252847579 | 4433 |
| 8253 | 3008253069580 | 4434 |
| 8254 | 3008254447564 | 4435 |
| 8255 | 3008255698245 | 4436 |
| 8256 | 3008256000394 | 4436 |
| 8257 | 3008257404520 | 4436 |
| 8258 | 3008258152090 | 4436 |
| 8259 | 3008259463367 | 4439 |
| 8260 | 3008260490840 | 4439 |
| 8261 | 3008261409861 | 4439 |
| 8262 | 3008262900410 | 4439 |
| 8263 | 3008263580495 | 4440 |
| 8264 | 3008264150065 | 4440 |
| 8265 | 3008265499491 | 4440 |
| 8266 | 3008266044917 | 4442 |
| 8267 | 3008267749336 | 4445 |
| 8268 | 3008268504055 | 4445 |
| 8269 | 3008269689474 | 4445 |
| 8270 | 3008270088409 | 4445 |
| 8271 | 3008271291530 | 4447 |
| 8272 | 3008272179113 | 4447 |
| 8273 | 3008273664852 | 4448 |
| 8274 | 3008274103102 | 4448 |
| 8275 | 3008275430194 | 4451 |
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;