Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 7,126–7,150 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 7126 | 3007126273846 | 3887 |
| 7127 | 3007127334283 | 3887 |
| 7128 | 3007128657620 | 3887 |
| 7129 | 3007129003504 | 3887 |
| 7130 | 3007130794862 | 3887 |
| 7131 | 3007131312692 | 3887 |
| 7132 | 3007132604234 | 3887 |
| 7133 | 3007133556921 | 3887 |
| 7134 | 3007134191260 | 3887 |
| 7135 | 3007135939074 | 3887 |
| 7136 | 3007136247872 | 3887 |
| 7137 | 3007137173506 | 3887 |
| 7138 | 3007138851390 | 3887 |
| 7139 | 3007139048222 | 3887 |
| 7140 | 3007140570744 | 3887 |
| 7141 | 3007141960285 | 3887 |
| 7142 | 3007142389256 | 3887 |
| 7143 | 3007143109230 | 3887 |
| 7144 | 3007144251115 | 3887 |
| 7145 | 3007145213391 | 3888 |
| 7146 | 3007146505222 | 3888 |
| 7147 | 3007147038476 | 3888 |
| 7148 | 3007148690356 | 3888 |
| 7149 | 3007149153609 | 3888 |
| 7150 | 3007150874510 | 3890 |
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;