Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 9,151–9,175 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 9151 | 3009151691829 | 4932 |
| 9152 | 3009152344380 | 4935 |
| 9153 | 3009153658565 | 4935 |
| 9154 | 3009154058470 | 4936 |
| 9155 | 3009155710261 | 4936 |
| 9156 | 3009156515014 | 4937 |
| 9157 | 3009157030402 | 4937 |
| 9158 | 3009158396997 | 4937 |
| 9159 | 3009159987341 | 4937 |
| 9160 | 3009160821910 | 4938 |
| 9161 | 3009161901974 | 4938 |
| 9162 | 3009162848846 | 4940 |
| 9163 | 3009163991430 | 4941 |
| 9164 | 3009164718327 | 4942 |
| 9165 | 3009165833158 | 4942 |
| 9166 | 3009166862130 | 4943 |
| 9167 | 3009167142958 | 4943 |
| 9168 | 3009168314756 | 4946 |
| 9169 | 3009169993171 | 4946 |
| 9170 | 3009170692338 | 4948 |
| 9171 | 3009171991358 | 4950 |
| 9172 | 3009172327540 | 4951 |
| 9173 | 3009173044815 | 4952 |
| 9174 | 3009174023131 | 4953 |
| 9175 | 3009175920899 | 4955 |
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;