Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 7,601–7,625 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 7601 | 3007601301446 | 4100 |
| 7602 | 3007602085397 | 4101 |
| 7603 | 3007603045909 | 4101 |
| 7604 | 3007604456546 | 4101 |
| 7605 | 3007605286092 | 4102 |
| 7606 | 3007606449790 | 4103 |
| 7607 | 3007607202444 | 4103 |
| 7608 | 3007608748662 | 4103 |
| 7609 | 3007609250387 | 4103 |
| 7610 | 3007610417395 | 4104 |
| 7611 | 3007611713780 | 4104 |
| 7612 | 3007612186761 | 4104 |
| 7613 | 3007613985361 | 4106 |
| 7614 | 3007614979852 | 4106 |
| 7615 | 3007615465853 | 4106 |
| 7616 | 3007616641053 | 4107 |
| 7617 | 3007617129492 | 4108 |
| 7618 | 3007618946872 | 4108 |
| 7619 | 3007619884846 | 4108 |
| 7620 | 3007620185421 | 4108 |
| 7621 | 3007621015835 | 4108 |
| 7622 | 3007622451008 | 4109 |
| 7623 | 3007623998187 | 4109 |
| 7624 | 3007624781575 | 4110 |
| 7625 | 3007625545561 | 4110 |
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;