Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 17,476–17,500 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 17476 | 8832 | 3 | 2019-08-28 15:03:22 |
| 17477 | 8832 | 2 | 2019-08-28 16:05:34 |
| 17478 | 8775 | 1 | 2019-08-28 16:48:40 |
| 17479 | 8774 | 1 | 2019-08-28 16:51:47 |
| 17480 | 8775 | 2 | 2019-08-28 17:34:11 |
| 17481 | 8774 | 2 | 2019-08-28 17:47:14 |
| 17482 | 8846 | 3 | 2019-08-29 09:56:10 |
| 17483 | 8847 | 3 | 2019-08-29 09:56:16 |
| 17484 | 8789 | 2 | 2019-08-29 10:57:48 |
| 17485 | 8788 | 2 | 2019-08-29 11:07:24 |
| 17486 | 8847 | 2 | 2019-08-29 11:10:21 |
| 17487 | 8846 | 2 | 2019-08-29 11:10:39 |
| 17488 | 8847 | 3 | 2019-08-29 11:37:37 |
| 17489 | 8788 | 3 | 2019-08-29 11:38:20 |
| 17490 | 8789 | 3 | 2019-08-29 11:45:06 |
| 17491 | 8847 | 2 | 2019-08-29 12:23:20 |
| 17492 | 8846 | 3 | 2019-08-29 12:24:58 |
| 17493 | 8788 | 2 | 2019-08-29 12:35:15 |
| 17494 | 8846 | 2 | 2019-08-29 12:57:23 |
| 17495 | 8789 | 2 | 2019-08-29 13:11:51 |
| 17496 | 8855 | 1 | 2019-08-30 09:51:31 |
| 17497 | 8854 | 2 | 2019-08-30 09:56:15 |
| 17498 | 8856 | 3 | 2019-08-30 10:39:56 |
| 17499 | 8858 | 2 | 2019-08-30 10:40:00 |
| 17500 | 8855 | 2 | 2019-08-30 10:41:59 |
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;