Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 1,201–1,225 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 1201 | 3001201704434 | 666 |
| 1202 | 3001202185740 | 669 |
| 1203 | 3001203999041 | 669 |
| 1204 | 3001204409077 | 669 |
| 1205 | 3001205242265 | 669 |
| 1206 | 3001206318792 | 669 |
| 1207 | 3001207271735 | 669 |
| 1208 | 3001208777550 | 669 |
| 1209 | 3001209223407 | 669 |
| 1210 | 3001210309203 | 669 |
| 1211 | 3001211915041 | 669 |
| 1212 | 3001212857143 | 669 |
| 1213 | 3001213129101 | 669 |
| 1214 | 3001214428344 | 669 |
| 1215 | 3001215894709 | 669 |
| 1216 | 3001216139205 | 669 |
| 1217 | 3001217723556 | 669 |
| 1218 | 3001218346763 | 669 |
| 1219 | 3001219953963 | 669 |
| 1220 | 3001220942877 | 669 |
| 1221 | 3001221392392 | 669 |
| 1222 | 3001222267373 | 669 |
| 1223 | 3001223294006 | 669 |
| 1224 | 3001224599414 | 669 |
| 1225 | 3001225871597 | 669 |
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;