Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 11,451–11,475 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 11451 | 5946 | 3 | 2018-06-09 17:14:12 |
| 11452 | 5953 | 1 | 2018-06-10 10:12:36 |
| 11453 | 5952 | 1 | 2018-06-10 10:16:21 |
| 11454 | 5951 | 1 | 2018-06-10 10:19:33 |
| 11455 | 6015 | 2 | 2018-06-10 10:47:16 |
| 11456 | 6016 | 1 | 2018-06-10 11:11:09 |
| 11457 | 5951 | 3 | 2018-06-10 11:13:48 |
| 11458 | 6017 | 2 | 2018-06-10 11:13:54 |
| 11459 | 5953 | 3 | 2018-06-10 11:16:48 |
| 11460 | 6015 | 3 | 2018-06-10 11:25:18 |
| 11461 | 5952 | 3 | 2018-06-10 11:46:46 |
| 11462 | 6017 | 1 | 2018-06-10 12:14:08 |
| 11463 | 6016 | 3 | 2018-06-10 12:35:28 |
| 11464 | 6015 | 1 | 2018-06-10 12:36:19 |
| 11465 | 6021 | 1 | 2018-06-10 12:56:24 |
| 11466 | 6022 | 1 | 2018-06-11 16:32:51 |
| 11467 | 6031 | 1 | 2018-06-12 15:20:53 |
| 11468 | 6028 | 1 | 2018-06-12 15:23:07 |
| 11469 | 6030 | 1 | 2018-06-12 15:27:32 |
| 11470 | 6029 | 1 | 2018-06-12 15:28:34 |
| 11471 | 6030 | 2 | 2018-06-12 16:07:54 |
| 11472 | 6028 | 3 | 2018-06-12 16:34:15 |
| 11473 | 6030 | 1 | 2018-06-12 16:40:36 |
| 11474 | 6031 | 2 | 2018-06-12 16:55:03 |
| 11475 | 6029 | 2 | 2018-06-12 16:59:58 |
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;