Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 8,776–8,800 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 8776 | 3008776630314 | 4777 |
| 8777 | 3008777382977 | 4778 |
| 8778 | 3008778078261 | 4778 |
| 8779 | 3008779734104 | 4781 |
| 8780 | 3008780980371 | 4783 |
| 8781 | 3008781249693 | 4784 |
| 8782 | 3008782553500 | 4784 |
| 8783 | 3008783281621 | 4785 |
| 8784 | 3008784092764 | 4786 |
| 8785 | 3008785594343 | 4786 |
| 8786 | 3008786424509 | 4788 |
| 8787 | 3008787166846 | 4788 |
| 8788 | 3008788121099 | 4790 |
| 8789 | 3008789440549 | 4790 |
| 8790 | 3008790327505 | 4793 |
| 8791 | 3008791185250 | 4793 |
| 8792 | 3008792361268 | 4794 |
| 8793 | 3008793649657 | 4795 |
| 8794 | 3008794741869 | 4795 |
| 8795 | 3008795498547 | 4796 |
| 8796 | 3008796426989 | 4796 |
| 8797 | 3008797483622 | 4797 |
| 8798 | 3008798541974 | 4798 |
| 8799 | 3008799050623 | 4799 |
| 8800 | 3008800310027 | 4799 |
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;