Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 9,076–9,100 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 9076 | 3009076271747 | 4888 |
| 9077 | 3009077231939 | 4888 |
| 9078 | 3009078793623 | 4888 |
| 9079 | 3009079542823 | 4888 |
| 9080 | 3009080745386 | 4888 |
| 9081 | 3009081700457 | 4888 |
| 9082 | 3009082725054 | 4888 |
| 9083 | 3009083084812 | 4888 |
| 9084 | 3009084331652 | 4889 |
| 9085 | 3009085616340 | 4890 |
| 9086 | 3009086156622 | 4890 |
| 9087 | 3009087791260 | 4893 |
| 9088 | 3009088599664 | 4895 |
| 9089 | 3009089425722 | 4896 |
| 9090 | 3009090868871 | 4897 |
| 9091 | 3009091580563 | 4897 |
| 9092 | 3009092272065 | 4897 |
| 9093 | 3009093231304 | 4897 |
| 9094 | 3009094202118 | 4898 |
| 9095 | 3009095666329 | 4898 |
| 9096 | 3009096646295 | 4899 |
| 9097 | 3009097419107 | 4900 |
| 9098 | 3009098177830 | 4900 |
| 9099 | 3009099602034 | 4900 |
| 9100 | 3009100517464 | 4901 |
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;