Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 6,826–6,850 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 6826 | 3006826896159 | 3730 |
| 6827 | 3006827897491 | 3730 |
| 6828 | 3006828268582 | 3730 |
| 6829 | 3006829723382 | 3731 |
| 6830 | 3006830665448 | 3731 |
| 6831 | 3006831178363 | 3732 |
| 6832 | 3006832377773 | 3733 |
| 6833 | 3006833814680 | 3733 |
| 6834 | 3006834692513 | 3734 |
| 6835 | 3006835966537 | 3734 |
| 6836 | 3006836796114 | 3735 |
| 6837 | 3006837525663 | 3735 |
| 6838 | 3006838542289 | 3735 |
| 6839 | 3006839320629 | 3736 |
| 6840 | 3006840518772 | 3738 |
| 6841 | 3006841879008 | 3738 |
| 6842 | 3006842466747 | 3738 |
| 6843 | 3006843561686 | 3738 |
| 6844 | 3006844123188 | 3739 |
| 6845 | 3006845089379 | 3739 |
| 6846 | 3006846536062 | 3739 |
| 6847 | 3006847571392 | 3739 |
| 6848 | 3006848852316 | 3739 |
| 6849 | 3006849887781 | 3740 |
| 6850 | 3006850581693 | 3745 |
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;