Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 4,676–4,700 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 4676 | 1946 | 2 | 2016-07-01 14:13:32 |
| 4677 | 1943 | 2 | 2016-07-01 14:13:33 |
| 4678 | 1949 | 2 | 2016-07-01 14:15:30 |
| 4679 | 1927 | 2 | 2016-07-01 14:16:32 |
| 4680 | 1933 | 2 | 2016-07-01 14:16:46 |
| 4681 | 2436 | 2 | 2016-07-01 14:19:05 |
| 4682 | 1947 | 2 | 2016-07-01 14:19:24 |
| 4683 | 1935 | 2 | 2016-07-01 14:19:39 |
| 4684 | 2438 | 3 | 2016-07-01 14:23:25 |
| 4685 | 2397 | 2 | 2016-07-01 14:26:37 |
| 4686 | 2437 | 2 | 2016-07-01 14:26:55 |
| 4687 | 1918 | 1 | 2016-07-01 14:27:39 |
| 4688 | 1895 | 1 | 2016-07-01 14:29:27 |
| 4689 | 2433 | 1 | 2016-07-01 14:29:29 |
| 4690 | 1913 | 1 | 2016-07-01 14:29:46 |
| 4691 | 1892 | 1 | 2016-07-01 14:32:17 |
| 4692 | 1908 | 1 | 2016-07-01 14:32:23 |
| 4693 | 1902 | 1 | 2016-07-01 14:35:29 |
| 4694 | 1900 | 1 | 2016-07-01 14:35:54 |
| 4695 | 1937 | 1 | 2016-07-01 14:37:42 |
| 4696 | 1893 | 1 | 2016-07-01 14:38:45 |
| 4697 | 1923 | 1 | 2016-07-01 14:38:53 |
| 4698 | 1898 | 1 | 2016-07-01 14:38:56 |
| 4699 | 1931 | 1 | 2016-07-01 14:42:39 |
| 4700 | 1922 | 1 | 2016-07-01 14:42:50 |
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;