Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 7,001–7,025 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 7001 | 3683 | 3 | 2017-03-21 11:13:52 |
| 7002 | 3684 | 3 | 2017-03-21 11:14:31 |
| 7003 | 3683 | 2 | 2017-03-21 12:12:31 |
| 7004 | 3684 | 2 | 2017-03-21 12:35:10 |
| 7005 | 3690 | 2 | 2017-03-23 14:38:02 |
| 7006 | 3692 | 1 | 2017-03-25 10:26:03 |
| 7007 | 3624 | 2 | 2017-03-25 11:12:30 |
| 7008 | 3625 | 2 | 2017-03-25 11:15:37 |
| 7009 | 3625 | 1 | 2017-03-25 11:45:13 |
| 7010 | 3692 | 2 | 2017-03-25 11:47:54 |
| 7011 | 3561 | 3 | 2017-03-25 11:57:02 |
| 7012 | 3562 | 2 | 2017-03-25 11:59:59 |
| 7013 | 3624 | 3 | 2017-03-25 12:38:55 |
| 7014 | 3562 | 3 | 2017-03-25 13:01:52 |
| 7015 | 3691 | 1 | 2017-03-25 13:09:23 |
| 7016 | 3691 | 2 | 2017-03-25 14:17:04 |
| 7017 | 3613 | 3 | 2017-03-25 15:00:25 |
| 7018 | 3612 | 2 | 2017-03-25 15:05:03 |
| 7019 | 3614 | 3 | 2017-03-25 15:13:13 |
| 7020 | 3633 | 2 | 2017-03-25 15:38:10 |
| 7021 | 3632 | 3 | 2017-03-25 15:40:18 |
| 7022 | 3633 | 3 | 2017-03-25 16:53:02 |
| 7023 | 3632 | 1 | 2017-03-25 17:12:55 |
| 7024 | 3633 | 2 | 2017-03-25 17:31:59 |
| 7025 | 3686 | 1 | 2017-03-27 10:19:19 |
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;