Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 1,876–1,900 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 1876 | 3001876844432 | 1044 |
| 1877 | 3001877736110 | 1044 |
| 1878 | 3001878021376 | 1045 |
| 1879 | 3001879165420 | 1045 |
| 1880 | 3001880645853 | 1046 |
| 1881 | 3001881388151 | 1046 |
| 1882 | 3001882834961 | 1049 |
| 1883 | 3001883352628 | 1049 |
| 1884 | 3001884227909 | 1049 |
| 1885 | 3001885373485 | 1049 |
| 1886 | 3001886371099 | 1051 |
| 1887 | 3001887325857 | 1052 |
| 1888 | 3001888665282 | 1053 |
| 1889 | 3001889782579 | 1053 |
| 1890 | 3001890121068 | 1053 |
| 1891 | 3001891736029 | 1053 |
| 1892 | 3001892321996 | 1055 |
| 1893 | 3001893814707 | 1055 |
| 1894 | 3001894445352 | 1055 |
| 1895 | 3001895653710 | 1055 |
| 1896 | 3001896953026 | 1055 |
| 1897 | 3001897287151 | 1055 |
| 1898 | 3001898830167 | 1055 |
| 1899 | 3001899277994 | 1055 |
| 1900 | 3001900376178 | 1055 |
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;