Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 4,701–4,725 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 4701 | 1927 | 1 | 2016-07-01 14:43:47 |
| 4702 | 1949 | 1 | 2016-07-01 14:44:52 |
| 4703 | 1940 | 1 | 2016-07-01 14:46:24 |
| 4704 | 1912 | 1 | 2016-07-01 14:47:33 |
| 4705 | 1925 | 1 | 2016-07-01 14:47:40 |
| 4706 | 1910 | 1 | 2016-07-01 14:49:16 |
| 4707 | 1932 | 1 | 2016-07-01 14:52:10 |
| 4708 | 1943 | 1 | 2016-07-01 14:52:25 |
| 4709 | 1914 | 1 | 2016-07-01 14:52:54 |
| 4710 | 2434 | 1 | 2016-07-01 14:55:07 |
| 4711 | 2438 | 2 | 2016-07-01 14:58:00 |
| 4712 | 1911 | 1 | 2016-07-01 14:58:36 |
| 4713 | 1901 | 1 | 2016-07-01 15:00:39 |
| 4714 | 1944 | 1 | 2016-07-01 15:02:24 |
| 4715 | 1896 | 1 | 2016-07-01 15:02:26 |
| 4716 | 1926 | 1 | 2016-07-01 15:03:07 |
| 4717 | 1894 | 1 | 2016-07-01 15:03:34 |
| 4718 | 1899 | 1 | 2016-07-01 15:05:39 |
| 4719 | 1928 | 1 | 2016-07-01 15:06:30 |
| 4720 | 1945 | 1 | 2016-07-01 15:07:57 |
| 4721 | 1915 | 1 | 2016-07-01 15:08:26 |
| 4722 | 1909 | 1 | 2016-07-01 15:08:44 |
| 4723 | 1920 | 1 | 2016-07-01 15:08:46 |
| 4724 | 1924 | 1 | 2016-07-01 15:09:12 |
| 4725 | 1897 | 1 | 2016-07-01 15:10:01 |
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;