Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 1,926–1,950 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 1926 | 467 | 2 | 2015-09-02 12:26:30 |
| 1927 | 458 | 2 | 2015-09-02 12:26:49 |
| 1928 | 461 | 2 | 2015-09-02 12:28:13 |
| 1929 | 492 | 2 | 2015-09-02 12:29:23 |
| 1930 | 475 | 2 | 2015-09-02 12:29:47 |
| 1931 | 478 | 2 | 2015-09-02 12:29:54 |
| 1932 | 453 | 2 | 2015-09-02 12:30:05 |
| 1933 | 469 | 2 | 2015-09-02 12:30:25 |
| 1934 | 486 | 2 | 2015-09-02 12:31:11 |
| 1935 | 470 | 2 | 2015-09-02 12:31:15 |
| 1936 | 463 | 2 | 2015-09-02 12:31:51 |
| 1937 | 472 | 2 | 2015-09-02 12:32:38 |
| 1938 | 473 | 2 | 2015-09-02 12:33:20 |
| 1939 | 456 | 2 | 2015-09-02 12:33:32 |
| 1940 | 491 | 2 | 2015-09-02 12:33:57 |
| 1941 | 477 | 2 | 2015-09-02 12:34:18 |
| 1942 | 487 | 2 | 2015-09-02 12:34:35 |
| 1943 | 497 | 2 | 2015-09-02 12:34:42 |
| 1944 | 464 | 2 | 2015-09-02 12:34:46 |
| 1945 | 465 | 2 | 2015-09-02 12:35:15 |
| 1946 | 488 | 2 | 2015-09-02 12:35:45 |
| 1947 | 476 | 2 | 2015-09-02 12:37:56 |
| 1948 | 1066 | 1 | 2015-09-02 12:57:43 |
| 1949 | 1065 | 1 | 2015-09-02 12:58:05 |
| 1950 | 1066 | 2 | 2015-09-02 13:44:24 |
Table definition
CREATE TABLE wing_scan (
scan_id INTEGER PRIMARY KEY,
ticket_id INTEGER NOT NULL REFERENCES ticket (ticket_id),
wing_id INTEGER NOT NULL REFERENCES wing (wing_id),
scanned_at TEXT NOT NULL
) STRICT;