Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 7,351–7,375 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 7351 | 3007351850847 | 4009 |
| 7352 | 3007352309381 | 4010 |
| 7353 | 3007353168204 | 4010 |
| 7354 | 3007354344012 | 4010 |
| 7355 | 3007355107276 | 4010 |
| 7356 | 3007356164486 | 4011 |
| 7357 | 3007357021525 | 4011 |
| 7358 | 3007358672450 | 4011 |
| 7359 | 3007359691737 | 4011 |
| 7360 | 3007360281316 | 4012 |
| 7361 | 3007361915426 | 4013 |
| 7362 | 3007362610303 | 4016 |
| 7363 | 3007363259051 | 4016 |
| 7364 | 3007364682191 | 4017 |
| 7365 | 3007365450549 | 4017 |
| 7366 | 3007366442962 | 4020 |
| 7367 | 3007367559873 | 4020 |
| 7368 | 3007368917526 | 4026 |
| 7369 | 3007369269948 | 4027 |
| 7370 | 3007370370571 | 4027 |
| 7371 | 3007371298332 | 4028 |
| 7372 | 3007372775285 | 4028 |
| 7373 | 3007373472654 | 4029 |
| 7374 | 3007374990423 | 4029 |
| 7375 | 3007375332309 | 4029 |
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;