Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 2,176–2,200 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 2176 | 1285 | 3 | 2015-10-02 13:05:06 |
| 2177 | 1286 | 2 | 2015-10-02 13:37:14 |
| 2178 | 1288 | 2 | 2015-10-02 14:57:05 |
| 2179 | 1287 | 2 | 2015-10-02 14:57:21 |
| 2180 | 1289 | 2 | 2015-10-02 14:59:08 |
| 2181 | 1271 | 2 | 2015-10-02 15:13:30 |
| 2182 | 1267 | 2 | 2015-10-02 15:15:46 |
| 2183 | 1270 | 2 | 2015-10-02 15:16:22 |
| 2184 | 1268 | 2 | 2015-10-02 15:21:09 |
| 2185 | 1269 | 2 | 2015-10-02 15:27:46 |
| 2186 | 1071 | 3 | 2015-10-04 10:43:57 |
| 2187 | 1070 | 3 | 2015-10-04 10:47:16 |
| 2188 | 1071 | 1 | 2015-10-04 12:03:41 |
| 2189 | 1070 | 1 | 2015-10-04 12:20:21 |
| 2190 | 1070 | 2 | 2015-10-04 12:46:06 |
| 2191 | 1291 | 2 | 2015-10-04 12:54:45 |
| 2192 | 1294 | 2 | 2015-10-04 12:56:26 |
| 2193 | 1293 | 2 | 2015-10-04 13:04:41 |
| 2194 | 1292 | 2 | 2015-10-04 13:08:31 |
| 2195 | 1071 | 2 | 2015-10-04 13:35:54 |
| 2196 | 1070 | 3 | 2015-10-04 13:55:14 |
| 2197 | 1071 | 3 | 2015-10-04 14:35:54 |
| 2198 | 1266 | 3 | 2015-10-05 10:44:45 |
| 2199 | 1265 | 3 | 2015-10-05 10:46:33 |
| 2200 | 1266 | 1 | 2015-10-05 11:40:22 |
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;