Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 4,201–4,225 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 4201 | 3004201090621 | 2343 |
| 4202 | 3004202196730 | 2343 |
| 4203 | 3004203045697 | 2343 |
| 4204 | 3004204298908 | 2343 |
| 4205 | 3004205042096 | 2343 |
| 4206 | 3004206480508 | 2343 |
| 4207 | 3004207825200 | 2343 |
| 4208 | 3004208110832 | 2343 |
| 4209 | 3004209999486 | 2343 |
| 4210 | 3004210355519 | 2343 |
| 4211 | 3004211893199 | 2343 |
| 4212 | 3004212086974 | 2343 |
| 4213 | 3004213736469 | 2343 |
| 4214 | 3004214581279 | 2343 |
| 4215 | 3004215612771 | 2343 |
| 4216 | 3004216095644 | 2343 |
| 4217 | 3004217245282 | 2343 |
| 4218 | 3004218285489 | 2343 |
| 4219 | 3004219052514 | 2343 |
| 4220 | 3004220233997 | 2343 |
| 4221 | 3004221026530 | 2343 |
| 4222 | 3004222829796 | 2343 |
| 4223 | 3004223466912 | 2343 |
| 4224 | 3004224131428 | 2343 |
| 4225 | 3004225766481 | 2343 |
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;