Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 9,451–9,475 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 9451 | 4869 | 3 | 2017-11-21 11:39:16 |
| 9452 | 4870 | 3 | 2017-11-21 11:43:11 |
| 9453 | 4860 | 3 | 2017-11-21 12:06:32 |
| 9454 | 4870 | 2 | 2017-11-21 12:23:32 |
| 9455 | 4869 | 2 | 2017-11-21 13:13:15 |
| 9456 | 4811 | 1 | 2017-11-21 14:37:29 |
| 9457 | 4813 | 2 | 2017-11-21 14:39:49 |
| 9458 | 4812 | 3 | 2017-11-21 14:46:59 |
| 9459 | 4811 | 3 | 2017-11-21 15:52:12 |
| 9460 | 4812 | 2 | 2017-11-21 15:59:12 |
| 9461 | 4811 | 2 | 2017-11-21 16:22:25 |
| 9462 | 4812 | 3 | 2017-11-21 17:03:31 |
| 9463 | 4871 | 1 | 2017-11-22 10:01:49 |
| 9464 | 4872 | 1 | 2017-11-22 10:03:58 |
| 9465 | 4876 | 2 | 2017-11-22 10:07:02 |
| 9466 | 4873 | 1 | 2017-11-22 10:09:02 |
| 9467 | 4875 | 2 | 2017-11-22 10:13:45 |
| 9468 | 4874 | 1 | 2017-11-22 10:16:07 |
| 9469 | 4878 | 3 | 2017-11-22 10:29:25 |
| 9470 | 4877 | 3 | 2017-11-22 10:37:50 |
| 9471 | 4873 | 3 | 2017-11-22 10:40:12 |
| 9472 | 4693 | 2 | 2017-11-22 12:19:20 |
| 9473 | 4689 | 2 | 2017-11-22 12:20:30 |
| 9474 | 4723 | 2 | 2017-11-22 12:22:33 |
| 9475 | 4707 | 2 | 2017-11-22 12:23:12 |
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;