Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 7,426–7,450 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 7426 | 3007426940690 | 4044 |
| 7427 | 3007427077736 | 4044 |
| 7428 | 3007428224253 | 4044 |
| 7429 | 3007429304098 | 4044 |
| 7430 | 3007430458695 | 4044 |
| 7431 | 3007431517045 | 4044 |
| 7432 | 3007432194065 | 4044 |
| 7433 | 3007433661633 | 4044 |
| 7434 | 3007434378642 | 4044 |
| 7435 | 3007435923565 | 4044 |
| 7436 | 3007436075536 | 4044 |
| 7437 | 3007437801028 | 4044 |
| 7438 | 3007438899083 | 4044 |
| 7439 | 3007439139409 | 4044 |
| 7440 | 3007440368476 | 4044 |
| 7441 | 3007441345337 | 4044 |
| 7442 | 3007442760084 | 4044 |
| 7443 | 3007443375535 | 4044 |
| 7444 | 3007444992514 | 4045 |
| 7445 | 3007445747341 | 4045 |
| 7446 | 3007446180091 | 4046 |
| 7447 | 3007447383153 | 4046 |
| 7448 | 3007448325526 | 4048 |
| 7449 | 3007449379089 | 4050 |
| 7450 | 3007450001905 | 4050 |
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;