Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 12,251–12,275 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 12251 | 6350 | 1 | 2018-08-06 13:40:05 |
| 12252 | 6351 | 2 | 2018-08-06 13:43:19 |
| 12253 | 6406 | 1 | 2018-08-06 13:58:49 |
| 12254 | 6405 | 1 | 2018-08-06 14:16:41 |
| 12255 | 6405 | 3 | 2018-08-06 15:00:42 |
| 12256 | 6405 | 1 | 2018-08-06 16:27:26 |
| 12257 | 6314 | 2 | 2018-08-07 09:37:59 |
| 12258 | 6313 | 2 | 2018-08-07 09:43:51 |
| 12259 | 6311 | 2 | 2018-08-07 09:45:41 |
| 12260 | 6312 | 2 | 2018-08-07 09:48:39 |
| 12261 | 6315 | 2 | 2018-08-07 09:51:19 |
| 12262 | 6295 | 3 | 2018-08-07 10:50:06 |
| 12263 | 6294 | 3 | 2018-08-07 10:50:19 |
| 12264 | 6411 | 3 | 2018-08-07 10:54:48 |
| 12265 | 6412 | 3 | 2018-08-07 11:00:37 |
| 12266 | 6410 | 3 | 2018-08-07 11:04:21 |
| 12267 | 6294 | 1 | 2018-08-07 11:27:21 |
| 12268 | 6412 | 2 | 2018-08-07 11:43:16 |
| 12269 | 6295 | 1 | 2018-08-07 11:46:10 |
| 12270 | 6412 | 1 | 2018-08-07 12:09:26 |
| 12271 | 6410 | 2 | 2018-08-07 12:16:44 |
| 12272 | 6294 | 2 | 2018-08-07 12:57:47 |
| 12273 | 6410 | 1 | 2018-08-07 13:10:24 |
| 12274 | 6295 | 2 | 2018-08-07 13:21:15 |
| 12275 | 6413 | 2 | 2018-08-07 16:37:52 |
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;