Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 2,226–2,250 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 2226 | 1306 | 2 | 2015-10-11 13:44:30 |
| 2227 | 1305 | 2 | 2015-10-11 14:10:42 |
| 2228 | 1304 | 2 | 2015-10-11 14:38:53 |
| 2229 | 1305 | 3 | 2015-10-11 15:21:30 |
| 2230 | 1312 | 1 | 2015-10-12 15:01:30 |
| 2231 | 1311 | 1 | 2015-10-12 15:01:57 |
| 2232 | 1309 | 1 | 2015-10-12 15:08:32 |
| 2233 | 1310 | 1 | 2015-10-12 15:08:36 |
| 2234 | 1313 | 2 | 2015-10-12 15:54:35 |
| 2235 | 1314 | 1 | 2015-10-12 16:08:01 |
| 2236 | 1313 | 3 | 2015-10-12 16:30:21 |
| 2237 | 1314 | 2 | 2015-10-12 16:37:28 |
| 2238 | 1297 | 2 | 2015-10-13 09:40:19 |
| 2239 | 1298 | 2 | 2015-10-13 09:41:42 |
| 2240 | 1278 | 2 | 2015-10-13 11:10:01 |
| 2241 | 1277 | 2 | 2015-10-13 11:14:27 |
| 2242 | 1276 | 2 | 2015-10-13 11:15:06 |
| 2243 | 1276 | 3 | 2015-10-13 11:51:14 |
| 2244 | 1278 | 1 | 2015-10-13 12:28:46 |
| 2245 | 1277 | 1 | 2015-10-13 12:30:10 |
| 2246 | 1276 | 2 | 2015-10-13 12:31:13 |
| 2247 | 1277 | 2 | 2015-10-13 13:28:50 |
| 2248 | 1093 | 2 | 2015-10-13 13:28:59 |
| 2249 | 1100 | 2 | 2015-10-13 13:29:27 |
| 2250 | 1106 | 2 | 2015-10-13 13:30:13 |
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;