Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 6,126–6,150 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 6126 | 3006126806120 | 3386 |
| 6127 | 3006127702051 | 3386 |
| 6128 | 3006128901296 | 3386 |
| 6129 | 3006129102562 | 3386 |
| 6130 | 3006130059606 | 3386 |
| 6131 | 3006131990037 | 3386 |
| 6132 | 3006132494534 | 3386 |
| 6133 | 3006133776215 | 3386 |
| 6134 | 3006134826859 | 3386 |
| 6135 | 3006135754054 | 3386 |
| 6136 | 3006136296882 | 3386 |
| 6137 | 3006137308823 | 3386 |
| 6138 | 3006138936287 | 3386 |
| 6139 | 3006139453401 | 3386 |
| 6140 | 3006140540573 | 3386 |
| 6141 | 3006141375924 | 3386 |
| 6142 | 3006142330006 | 3386 |
| 6143 | 3006143545570 | 3386 |
| 6144 | 3006144767020 | 3386 |
| 6145 | 3006145209780 | 3386 |
| 6146 | 3006146597985 | 3386 |
| 6147 | 3006147692697 | 3386 |
| 6148 | 3006148258227 | 3386 |
| 6149 | 3006149155300 | 3386 |
| 6150 | 3006150948270 | 3386 |
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;