Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 1,901–1,925 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 1901 | 3001901345048 | 1055 |
| 1902 | 3001902520172 | 1055 |
| 1903 | 3001903301847 | 1055 |
| 1904 | 3001904036081 | 1055 |
| 1905 | 3001905895770 | 1055 |
| 1906 | 3001906549762 | 1055 |
| 1907 | 3001907353957 | 1055 |
| 1908 | 3001908850378 | 1055 |
| 1909 | 3001909676099 | 1055 |
| 1910 | 3001910252325 | 1055 |
| 1911 | 3001911660848 | 1055 |
| 1912 | 3001912615606 | 1055 |
| 1913 | 3001913280030 | 1055 |
| 1914 | 3001914511720 | 1055 |
| 1915 | 3001915621226 | 1055 |
| 1916 | 3001916445175 | 1055 |
| 1917 | 3001917568584 | 1055 |
| 1918 | 3001918025405 | 1055 |
| 1919 | 3001919565438 | 1055 |
| 1920 | 3001920102600 | 1055 |
| 1921 | 3001921062420 | 1055 |
| 1922 | 3001922419629 | 1055 |
| 1923 | 3001923707406 | 1055 |
| 1924 | 3001924750269 | 1055 |
| 1925 | 3001925771628 | 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;