Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 7,051–7,075 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 7051 | 3007051588836 | 3861 |
| 7052 | 3007052002049 | 3862 |
| 7053 | 3007053197546 | 3863 |
| 7054 | 3007054120967 | 3863 |
| 7055 | 3007055276549 | 3863 |
| 7056 | 3007056849135 | 3863 |
| 7057 | 3007057597558 | 3863 |
| 7058 | 3007058897025 | 3865 |
| 7059 | 3007059137263 | 3865 |
| 7060 | 3007060355917 | 3865 |
| 7061 | 3007061093572 | 3865 |
| 7062 | 3007062826327 | 3866 |
| 7063 | 3007063873520 | 3867 |
| 7064 | 3007064104223 | 3868 |
| 7065 | 3007065979338 | 3868 |
| 7066 | 3007066211828 | 3869 |
| 7067 | 3007067232153 | 3870 |
| 7068 | 3007068685773 | 3871 |
| 7069 | 3007069939710 | 3871 |
| 7070 | 3007070275449 | 3871 |
| 7071 | 3007071489808 | 3873 |
| 7072 | 3007072006534 | 3874 |
| 7073 | 3007073376941 | 3877 |
| 7074 | 3007074645267 | 3877 |
| 7075 | 3007075486682 | 3877 |
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;