Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 851–875 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 851 | 614 | 3 | 2015-05-25 17:31:40 |
| 852 | 123 | 2 | 2015-05-28 10:11:36 |
| 853 | 138 | 2 | 2015-05-28 10:12:56 |
| 854 | 116 | 2 | 2015-05-28 10:13:01 |
| 855 | 136 | 2 | 2015-05-28 10:13:02 |
| 856 | 143 | 2 | 2015-05-28 10:15:50 |
| 857 | 130 | 2 | 2015-05-28 10:16:34 |
| 858 | 134 | 2 | 2015-05-28 10:17:11 |
| 859 | 150 | 2 | 2015-05-28 10:17:20 |
| 860 | 132 | 2 | 2015-05-28 10:18:56 |
| 861 | 133 | 2 | 2015-05-28 10:19:10 |
| 862 | 154 | 2 | 2015-05-28 10:19:29 |
| 863 | 148 | 2 | 2015-05-28 10:20:04 |
| 864 | 114 | 2 | 2015-05-28 10:20:11 |
| 865 | 115 | 2 | 2015-05-28 10:20:14 |
| 866 | 118 | 2 | 2015-05-28 10:21:45 |
| 867 | 131 | 2 | 2015-05-28 10:21:45 |
| 868 | 127 | 2 | 2015-05-28 10:21:46 |
| 869 | 140 | 2 | 2015-05-28 10:21:51 |
| 870 | 119 | 2 | 2015-05-28 10:22:00 |
| 871 | 124 | 2 | 2015-05-28 10:22:15 |
| 872 | 113 | 2 | 2015-05-28 10:23:54 |
| 873 | 125 | 2 | 2015-05-28 10:24:39 |
| 874 | 129 | 2 | 2015-05-28 10:24:43 |
| 875 | 139 | 2 | 2015-05-28 10:24:55 |
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;