Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 9,126–9,150 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 9126 | 3009126937982 | 4919 |
| 9127 | 3009127136250 | 4919 |
| 9128 | 3009128758767 | 4920 |
| 9129 | 3009129505306 | 4920 |
| 9130 | 3009130714334 | 4920 |
| 9131 | 3009131536719 | 4921 |
| 9132 | 3009132344904 | 4921 |
| 9133 | 3009133884803 | 4923 |
| 9134 | 3009134496597 | 4923 |
| 9135 | 3009135426191 | 4924 |
| 9136 | 3009136371501 | 4924 |
| 9137 | 3009137627666 | 4924 |
| 9138 | 3009138433095 | 4926 |
| 9139 | 3009139985632 | 4926 |
| 9140 | 3009140999122 | 4927 |
| 9141 | 3009141005755 | 4927 |
| 9142 | 3009142314235 | 4928 |
| 9143 | 3009143232055 | 4928 |
| 9144 | 3009144702999 | 4929 |
| 9145 | 3009145192303 | 4931 |
| 9146 | 3009146830681 | 4931 |
| 9147 | 3009147529071 | 4932 |
| 9148 | 3009148791422 | 4932 |
| 9149 | 3009149101069 | 4932 |
| 9150 | 3009150267404 | 4932 |
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;