Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 7,776–7,800 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 7776 | 3007776924051 | 4178 |
| 7777 | 3007777450500 | 4178 |
| 7778 | 3007778990535 | 4178 |
| 7779 | 3007779993037 | 4178 |
| 7780 | 3007780743175 | 4179 |
| 7781 | 3007781413076 | 4179 |
| 7782 | 3007782566887 | 4180 |
| 7783 | 3007783622326 | 4180 |
| 7784 | 3007784564897 | 4181 |
| 7785 | 3007785577313 | 4181 |
| 7786 | 3007786074414 | 4181 |
| 7787 | 3007787534524 | 4181 |
| 7788 | 3007788004800 | 4186 |
| 7789 | 3007789855096 | 4186 |
| 7790 | 3007790993585 | 4186 |
| 7791 | 3007791320549 | 4186 |
| 7792 | 3007792614569 | 4187 |
| 7793 | 3007793699860 | 4187 |
| 7794 | 3007794383708 | 4187 |
| 7795 | 3007795502318 | 4189 |
| 7796 | 3007796560661 | 4189 |
| 7797 | 3007797595918 | 4189 |
| 7798 | 3007798624331 | 4190 |
| 7799 | 3007799168072 | 4190 |
| 7800 | 3007800289387 | 4191 |
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;