Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 6,801–6,825 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 6801 | 3006801232378 | 3730 |
| 6802 | 3006802943036 | 3730 |
| 6803 | 3006803616331 | 3730 |
| 6804 | 3006804905418 | 3730 |
| 6805 | 3006805855805 | 3730 |
| 6806 | 3006806118368 | 3730 |
| 6807 | 3006807473030 | 3730 |
| 6808 | 3006808908028 | 3730 |
| 6809 | 3006809855046 | 3730 |
| 6810 | 3006810474959 | 3730 |
| 6811 | 3006811113046 | 3730 |
| 6812 | 3006812886486 | 3730 |
| 6813 | 3006813286395 | 3730 |
| 6814 | 3006814627928 | 3730 |
| 6815 | 3006815635034 | 3730 |
| 6816 | 3006816083895 | 3730 |
| 6817 | 3006817387486 | 3730 |
| 6818 | 3006818109751 | 3730 |
| 6819 | 3006819122945 | 3730 |
| 6820 | 3006820159355 | 3730 |
| 6821 | 3006821115477 | 3730 |
| 6822 | 3006822026344 | 3730 |
| 6823 | 3006823508976 | 3730 |
| 6824 | 3006824082002 | 3730 |
| 6825 | 3006825294905 | 3730 |
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;