Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 8,726–8,750 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 8726 | 3008726047582 | 4745 |
| 8727 | 3008727088911 | 4746 |
| 8728 | 3008728149365 | 4746 |
| 8729 | 3008729702408 | 4747 |
| 8730 | 3008730227465 | 4747 |
| 8731 | 3008731816329 | 4748 |
| 8732 | 3008732397437 | 4748 |
| 8733 | 3008733701297 | 4749 |
| 8734 | 3008734568605 | 4749 |
| 8735 | 3008735834046 | 4749 |
| 8736 | 3008736070149 | 4750 |
| 8737 | 3008737227407 | 4754 |
| 8738 | 3008738598066 | 4754 |
| 8739 | 3008739398314 | 4755 |
| 8740 | 3008740319022 | 4755 |
| 8741 | 3008741487186 | 4758 |
| 8742 | 3008742178982 | 4758 |
| 8743 | 3008743542364 | 4758 |
| 8744 | 3008744319978 | 4758 |
| 8745 | 3008745721811 | 4761 |
| 8746 | 3008746826650 | 4761 |
| 8747 | 3008747626032 | 4763 |
| 8748 | 3008748436098 | 4763 |
| 8749 | 3008749124289 | 4763 |
| 8750 | 3008750929450 | 4763 |
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;