Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 2,076–2,100 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 2076 | 3002076527043 | 1148 |
| 2077 | 3002077222005 | 1148 |
| 2078 | 3002078438534 | 1148 |
| 2079 | 3002079993379 | 1149 |
| 2080 | 3002080558600 | 1149 |
| 2081 | 3002081509948 | 1149 |
| 2082 | 3002082007159 | 1149 |
| 2083 | 3002083347806 | 1150 |
| 2084 | 3002084261897 | 1154 |
| 2085 | 3002085886440 | 1154 |
| 2086 | 3002086493712 | 1157 |
| 2087 | 3002087785338 | 1160 |
| 2088 | 3002088855868 | 1160 |
| 2089 | 3002089020202 | 1162 |
| 2090 | 3002090162643 | 1164 |
| 2091 | 3002091540411 | 1164 |
| 2092 | 3002092451352 | 1164 |
| 2093 | 3002093580283 | 1165 |
| 2094 | 3002094321793 | 1165 |
| 2095 | 3002095874392 | 1165 |
| 2096 | 3002096346286 | 1166 |
| 2097 | 3002097323165 | 1166 |
| 2098 | 3002098399049 | 1166 |
| 2099 | 3002099032697 | 1166 |
| 2100 | 3002100510658 | 1167 |
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;