Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 3,876–3,900 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 3876 | 3003876648246 | 2126 |
| 3877 | 3003877619892 | 2127 |
| 3878 | 3003878183764 | 2127 |
| 3879 | 3003879919751 | 2128 |
| 3880 | 3003880404029 | 2130 |
| 3881 | 3003881330408 | 2130 |
| 3882 | 3003882272708 | 2130 |
| 3883 | 3003883231375 | 2130 |
| 3884 | 3003884265572 | 2130 |
| 3885 | 3003885210860 | 2132 |
| 3886 | 3003886728352 | 2133 |
| 3887 | 3003887448584 | 2135 |
| 3888 | 3003888607616 | 2135 |
| 3889 | 3003889286371 | 2135 |
| 3890 | 3003890771760 | 2135 |
| 3891 | 3003891412302 | 2138 |
| 3892 | 3003892942655 | 2139 |
| 3893 | 3003893998592 | 2139 |
| 3894 | 3003894932655 | 2139 |
| 3895 | 3003895224998 | 2140 |
| 3896 | 3003896033398 | 2140 |
| 3897 | 3003897528677 | 2141 |
| 3898 | 3003898514899 | 2141 |
| 3899 | 3003899911950 | 2141 |
| 3900 | 3003900794850 | 2141 |
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;