Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 9,776–9,800 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 9776 | 3009776733071 | 5361 |
| 9777 | 3009777109777 | 5362 |
| 9778 | 3009778441635 | 5362 |
| 9779 | 3009779441410 | 5364 |
| 9780 | 3009780722780 | 5364 |
| 9781 | 3009781595737 | 5367 |
| 9782 | 3009782291797 | 5368 |
| 9783 | 3009783448506 | 5368 |
| 9784 | 3009784808228 | 5369 |
| 9785 | 3009785588645 | 5369 |
| 9786 | 3009786767284 | 5370 |
| 9787 | 3009787358110 | 5371 |
| 9788 | 3009788386473 | 5372 |
| 9789 | 3009789113395 | 5372 |
| 9790 | 3009790229590 | 5373 |
| 9791 | 3009791852723 | 5373 |
| 9792 | 3009792926365 | 5375 |
| 9793 | 3009793017813 | 5375 |
| 9794 | 3009794282304 | 5375 |
| 9795 | 3009795837311 | 5378 |
| 9796 | 3009796066591 | 5378 |
| 9797 | 3009797643103 | 5382 |
| 9798 | 3009798516803 | 5382 |
| 9799 | 3009799731633 | 5382 |
| 9800 | 3009800643700 | 5382 |
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;