Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 9,001–9,025 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 9001 | 4678 | 2 | 2017-09-30 09:08:06 |
| 9002 | 4679 | 2 | 2017-09-30 09:10:07 |
| 9003 | 4676 | 2 | 2017-09-30 09:17:45 |
| 9004 | 4677 | 2 | 2017-09-30 09:21:11 |
| 9005 | 4671 | 2 | 2017-09-30 09:25:51 |
| 9006 | 4672 | 2 | 2017-09-30 09:28:16 |
| 9007 | 4673 | 2 | 2017-09-30 09:31:57 |
| 9008 | 4678 | 1 | 2017-09-30 09:50:46 |
| 9009 | 4672 | 1 | 2017-09-30 09:56:24 |
| 9010 | 4677 | 1 | 2017-09-30 10:04:27 |
| 9011 | 4671 | 3 | 2017-09-30 10:07:11 |
| 9012 | 4673 | 3 | 2017-09-30 10:22:20 |
| 9013 | 4679 | 1 | 2017-09-30 10:25:19 |
| 9014 | 4677 | 2 | 2017-09-30 10:51:45 |
| 9015 | 4676 | 1 | 2017-09-30 10:51:58 |
| 9016 | 4678 | 2 | 2017-09-30 11:01:34 |
| 9017 | 4672 | 3 | 2017-09-30 11:15:30 |
| 9018 | 4679 | 2 | 2017-09-30 11:40:45 |
| 9019 | 4676 | 2 | 2017-09-30 12:01:41 |
| 9020 | 4683 | 1 | 2017-10-01 09:47:23 |
| 9021 | 4683 | 3 | 2017-10-01 10:29:49 |
| 9022 | 4654 | 3 | 2017-10-01 10:44:29 |
| 9023 | 4655 | 2 | 2017-10-01 10:45:58 |
| 9024 | 4654 | 1 | 2017-10-01 11:43:38 |
| 9025 | 4655 | 3 | 2017-10-01 12:19:30 |
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;