Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 8,676–8,700 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 8676 | 3008676943165 | 4711 |
| 8677 | 3008677489145 | 4711 |
| 8678 | 3008678301368 | 4712 |
| 8679 | 3008679255538 | 4712 |
| 8680 | 3008680814572 | 4712 |
| 8681 | 3008681811107 | 4712 |
| 8682 | 3008682103716 | 4712 |
| 8683 | 3008683506772 | 4713 |
| 8684 | 3008684963951 | 4713 |
| 8685 | 3008685605560 | 4715 |
| 8686 | 3008686270034 | 4715 |
| 8687 | 3008687088076 | 4716 |
| 8688 | 3008688260191 | 4716 |
| 8689 | 3008689494362 | 4716 |
| 8690 | 3008690075118 | 4716 |
| 8691 | 3008691964744 | 4717 |
| 8692 | 3008692203076 | 4717 |
| 8693 | 3008693607301 | 4718 |
| 8694 | 3008694388433 | 4718 |
| 8695 | 3008695330542 | 4718 |
| 8696 | 3008696505339 | 4719 |
| 8697 | 3008697287667 | 4719 |
| 8698 | 3008698312075 | 4721 |
| 8699 | 3008699571479 | 4721 |
| 8700 | 3008700800253 | 4721 |
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;