Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 7,851–7,875 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 7851 | 3007851371189 | 4219 |
| 7852 | 3007852832576 | 4219 |
| 7853 | 3007853517744 | 4219 |
| 7854 | 3007854362655 | 4219 |
| 7855 | 3007855693725 | 4219 |
| 7856 | 3007856855775 | 4219 |
| 7857 | 3007857636110 | 4219 |
| 7858 | 3007858569763 | 4219 |
| 7859 | 3007859530959 | 4219 |
| 7860 | 3007860520478 | 4219 |
| 7861 | 3007861202733 | 4219 |
| 7862 | 3007862154138 | 4219 |
| 7863 | 3007863069626 | 4219 |
| 7864 | 3007864753638 | 4219 |
| 7865 | 3007865639707 | 4219 |
| 7866 | 3007866959720 | 4219 |
| 7867 | 3007867959232 | 4219 |
| 7868 | 3007868848545 | 4219 |
| 7869 | 3007869114723 | 4219 |
| 7870 | 3007870248340 | 4219 |
| 7871 | 3007871253799 | 4219 |
| 7872 | 3007872112058 | 4219 |
| 7873 | 3007873765762 | 4219 |
| 7874 | 3007874306896 | 4219 |
| 7875 | 3007875077518 | 4220 |
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;