Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 6,501–6,525 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 6501 | 3006501818689 | 3596 |
| 6502 | 3006502844921 | 3596 |
| 6503 | 3006503776905 | 3597 |
| 6504 | 3006504714826 | 3597 |
| 6505 | 3006505308431 | 3599 |
| 6506 | 3006506109245 | 3599 |
| 6507 | 3006507468341 | 3601 |
| 6508 | 3006508802516 | 3601 |
| 6509 | 3006509377388 | 3602 |
| 6510 | 3006510523202 | 3602 |
| 6511 | 3006511899655 | 3602 |
| 6512 | 3006512424032 | 3602 |
| 6513 | 3006513410765 | 3604 |
| 6514 | 3006514615025 | 3605 |
| 6515 | 3006515633849 | 3605 |
| 6516 | 3006516374971 | 3605 |
| 6517 | 3006517910708 | 3606 |
| 6518 | 3006518076122 | 3608 |
| 6519 | 3006519954188 | 3608 |
| 6520 | 3006520867270 | 3608 |
| 6521 | 3006521350789 | 3608 |
| 6522 | 3006522544532 | 3608 |
| 6523 | 3006523019003 | 3608 |
| 6524 | 3006524219712 | 3608 |
| 6525 | 3006525278187 | 3608 |
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;