Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 6,676–6,700 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 6676 | 3006676175077 | 3651 |
| 6677 | 3006677992308 | 3651 |
| 6678 | 3006678753184 | 3651 |
| 6679 | 3006679227373 | 3651 |
| 6680 | 3006680309074 | 3651 |
| 6681 | 3006681811276 | 3651 |
| 6682 | 3006682818540 | 3651 |
| 6683 | 3006683558429 | 3651 |
| 6684 | 3006684146495 | 3651 |
| 6685 | 3006685308178 | 3652 |
| 6686 | 3006686223430 | 3653 |
| 6687 | 3006687850031 | 3653 |
| 6688 | 3006688936798 | 3654 |
| 6689 | 3006689694272 | 3654 |
| 6690 | 3006690060813 | 3655 |
| 6691 | 3006691919004 | 3655 |
| 6692 | 3006692279143 | 3656 |
| 6693 | 3006693147468 | 3657 |
| 6694 | 3006694269274 | 3658 |
| 6695 | 3006695788001 | 3658 |
| 6696 | 3006696134681 | 3658 |
| 6697 | 3006697195530 | 3660 |
| 6698 | 3006698272183 | 3660 |
| 6699 | 3006699574992 | 3660 |
| 6700 | 3006700438003 | 3661 |
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;