Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 8,751–8,775 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 8751 | 3008751625661 | 4763 |
| 8752 | 3008752464091 | 4764 |
| 8753 | 3008753703700 | 4764 |
| 8754 | 3008754814652 | 4765 |
| 8755 | 3008755397863 | 4765 |
| 8756 | 3008756110491 | 4765 |
| 8757 | 3008757571109 | 4766 |
| 8758 | 3008758029781 | 4767 |
| 8759 | 3008759165481 | 4768 |
| 8760 | 3008760552627 | 4769 |
| 8761 | 3008761462987 | 4771 |
| 8762 | 3008762323309 | 4772 |
| 8763 | 3008763172241 | 4772 |
| 8764 | 3008764993210 | 4772 |
| 8765 | 3008765080420 | 4772 |
| 8766 | 3008766082554 | 4772 |
| 8767 | 3008767697034 | 4773 |
| 8768 | 3008768504592 | 4773 |
| 8769 | 3008769969285 | 4774 |
| 8770 | 3008770726937 | 4775 |
| 8771 | 3008771819975 | 4775 |
| 8772 | 3008772618976 | 4775 |
| 8773 | 3008773939304 | 4775 |
| 8774 | 3008774662102 | 4776 |
| 8775 | 3008775049486 | 4776 |
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;