Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 6,626–6,650 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 6626 | 3006626214923 | 3651 |
| 6627 | 3006627474925 | 3651 |
| 6628 | 3006628133232 | 3651 |
| 6629 | 3006629238667 | 3651 |
| 6630 | 3006630287829 | 3651 |
| 6631 | 3006631078953 | 3651 |
| 6632 | 3006632895489 | 3651 |
| 6633 | 3006633482516 | 3651 |
| 6634 | 3006634790923 | 3651 |
| 6635 | 3006635891958 | 3651 |
| 6636 | 3006636703451 | 3651 |
| 6637 | 3006637966248 | 3651 |
| 6638 | 3006638676916 | 3651 |
| 6639 | 3006639759593 | 3651 |
| 6640 | 3006640879138 | 3651 |
| 6641 | 3006641072393 | 3651 |
| 6642 | 3006642577717 | 3651 |
| 6643 | 3006643606797 | 3651 |
| 6644 | 3006644067341 | 3651 |
| 6645 | 3006645723877 | 3651 |
| 6646 | 3006646175958 | 3651 |
| 6647 | 3006647033323 | 3651 |
| 6648 | 3006648078839 | 3651 |
| 6649 | 3006649318329 | 3651 |
| 6650 | 3006650359750 | 3651 |
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;