Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 12,276–12,300 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 12276 | 6414 | 2 | 2018-08-07 16:49:33 |
| 12277 | 6413 | 1 | 2018-08-07 17:39:22 |
| 12278 | 6415 | 3 | 2018-08-08 11:30:44 |
| 12279 | 6423 | 3 | 2018-08-09 10:37:55 |
| 12280 | 6424 | 2 | 2018-08-09 10:41:16 |
| 12281 | 6425 | 2 | 2018-08-09 11:40:07 |
| 12282 | 6427 | 2 | 2018-08-09 11:44:24 |
| 12283 | 6423 | 1 | 2018-08-09 11:46:10 |
| 12284 | 6428 | 2 | 2018-08-09 11:49:27 |
| 12285 | 6429 | 2 | 2018-08-09 11:51:50 |
| 12286 | 6345 | 2 | 2018-08-09 11:52:09 |
| 12287 | 6424 | 1 | 2018-08-09 11:52:29 |
| 12288 | 6426 | 2 | 2018-08-09 11:53:21 |
| 12289 | 6427 | 1 | 2018-08-09 12:37:58 |
| 12290 | 6425 | 1 | 2018-08-09 12:40:51 |
| 12291 | 6428 | 1 | 2018-08-09 12:45:58 |
| 12292 | 6424 | 2 | 2018-08-09 13:00:23 |
| 12293 | 6429 | 1 | 2018-08-09 13:06:44 |
| 12294 | 6426 | 1 | 2018-08-09 13:10:39 |
| 12295 | 6424 | 3 | 2018-08-09 13:47:08 |
| 12296 | 6432 | 2 | 2018-08-09 13:47:08 |
| 12297 | 6425 | 2 | 2018-08-09 13:47:32 |
| 12298 | 6433 | 2 | 2018-08-09 13:50:57 |
| 12299 | 6428 | 2 | 2018-08-09 13:53:55 |
| 12300 | 6431 | 2 | 2018-08-09 13:54: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;