Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 4,251–4,275 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 4251 | 2269 | 1 | 2016-05-23 10:50:45 |
| 4252 | 2142 | 2 | 2016-05-25 10:33:29 |
| 4253 | 2140 | 2 | 2016-05-25 10:37:22 |
| 4254 | 2289 | 3 | 2016-05-25 10:37:51 |
| 4255 | 2141 | 2 | 2016-05-25 10:42:26 |
| 4256 | 2288 | 2 | 2016-05-25 10:43:41 |
| 4257 | 2140 | 3 | 2016-05-25 11:03:34 |
| 4258 | 2142 | 3 | 2016-05-25 11:06:06 |
| 4259 | 2141 | 3 | 2016-05-25 11:10:26 |
| 4260 | 2142 | 2 | 2016-05-25 11:53:18 |
| 4261 | 2141 | 2 | 2016-05-25 12:25:29 |
| 4262 | 2292 | 1 | 2016-05-26 11:38:37 |
| 4263 | 2293 | 2 | 2016-05-26 14:20:49 |
| 4264 | 2294 | 2 | 2016-05-26 14:29:26 |
| 4265 | 2201 | 2 | 2016-05-26 15:24:52 |
| 4266 | 2200 | 2 | 2016-05-26 15:26:12 |
| 4267 | 2201 | 1 | 2016-05-26 16:59:07 |
| 4268 | 2283 | 1 | 2016-05-27 12:34:55 |
| 4269 | 2284 | 1 | 2016-05-27 12:35:05 |
| 4270 | 2287 | 2 | 2016-05-27 15:16:01 |
| 4271 | 2297 | 3 | 2016-05-28 10:50:16 |
| 4272 | 2296 | 1 | 2016-05-28 10:50:39 |
| 4273 | 2254 | 2 | 2016-05-28 11:12:25 |
| 4274 | 2296 | 2 | 2016-05-28 11:25:00 |
| 4275 | 2297 | 2 | 2016-05-28 11:49:18 |
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;