Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 8,826–8,850 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 8826 | 3008826095513 | 4812 |
| 8827 | 3008827488801 | 4812 |
| 8828 | 3008828941454 | 4813 |
| 8829 | 3008829153887 | 4814 |
| 8830 | 3008830835472 | 4814 |
| 8831 | 3008831857628 | 4816 |
| 8832 | 3008832402413 | 4816 |
| 8833 | 3008833584019 | 4817 |
| 8834 | 3008834728281 | 4818 |
| 8835 | 3008835436241 | 4820 |
| 8836 | 3008836926175 | 4820 |
| 8837 | 3008837712596 | 4820 |
| 8838 | 3008838236536 | 4820 |
| 8839 | 3008839354076 | 4820 |
| 8840 | 3008840950774 | 4823 |
| 8841 | 3008841157504 | 4823 |
| 8842 | 3008842692714 | 4823 |
| 8843 | 3008843493406 | 4823 |
| 8844 | 3008844584443 | 4824 |
| 8845 | 3008845181179 | 4826 |
| 8846 | 3008846095064 | 4827 |
| 8847 | 3008847641918 | 4827 |
| 8848 | 3008848184204 | 4828 |
| 8849 | 3008849451819 | 4828 |
| 8850 | 3008850148817 | 4828 |
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;