Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 4,351–4,375 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 4351 | 3004351289990 | 2423 |
| 4352 | 3004352614450 | 2423 |
| 4353 | 3004353935167 | 2425 |
| 4354 | 3004354196513 | 2425 |
| 4355 | 3004355594783 | 2427 |
| 4356 | 3004356079613 | 2429 |
| 4357 | 3004357535915 | 2429 |
| 4358 | 3004358373021 | 2430 |
| 4359 | 3004359147640 | 2430 |
| 4360 | 3004360817416 | 2432 |
| 4361 | 3004361284145 | 2432 |
| 4362 | 3004362107777 | 2432 |
| 4363 | 3004363597687 | 2433 |
| 4364 | 3004364815962 | 2433 |
| 4365 | 3004365538176 | 2434 |
| 4366 | 3004366528770 | 2434 |
| 4367 | 3004367573928 | 2435 |
| 4368 | 3004368027451 | 2435 |
| 4369 | 3004369489980 | 2439 |
| 4370 | 3004370459529 | 2439 |
| 4371 | 3004371013102 | 2439 |
| 4372 | 3004372389573 | 2439 |
| 4373 | 3004373930434 | 2439 |
| 4374 | 3004374184699 | 2440 |
| 4375 | 3004375325074 | 2441 |
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;