Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 8,001–8,025 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 8001 | 4093 | 3 | 2017-06-25 16:24:41 |
| 8002 | 4081 | 3 | 2017-06-25 16:49:45 |
| 8003 | 4093 | 1 | 2017-06-25 17:22:40 |
| 8004 | 4083 | 2 | 2017-06-26 10:50:10 |
| 8005 | 4084 | 2 | 2017-06-26 10:57:56 |
| 8006 | 4098 | 3 | 2017-06-26 11:24:05 |
| 8007 | 4098 | 2 | 2017-06-26 11:59:43 |
| 8008 | 4098 | 3 | 2017-06-26 13:18:00 |
| 8009 | 4096 | 2 | 2017-06-28 14:41:36 |
| 8010 | 4097 | 2 | 2017-06-28 14:45:34 |
| 8011 | 4059 | 1 | 2017-06-29 14:52:23 |
| 8012 | 4060 | 3 | 2017-06-29 15:01:06 |
| 8013 | 4060 | 1 | 2017-06-29 15:51:47 |
| 8014 | 4143 | 2 | 2017-06-30 14:40:11 |
| 8015 | 4142 | 2 | 2017-06-30 14:41:05 |
| 8016 | 4062 | 2 | 2017-06-30 15:02:05 |
| 8017 | 4143 | 1 | 2017-06-30 15:49:31 |
| 8018 | 4142 | 1 | 2017-06-30 16:06:14 |
| 8019 | 4062 | 3 | 2017-06-30 16:19:36 |
| 8020 | 4143 | 3 | 2017-06-30 16:24:26 |
| 8021 | 4142 | 3 | 2017-06-30 16:53:45 |
| 8022 | 4062 | 1 | 2017-06-30 17:11:26 |
| 8023 | 4154 | 2 | 2017-07-01 09:33:03 |
| 8024 | 4157 | 2 | 2017-07-01 09:37:30 |
| 8025 | 4156 | 2 | 2017-07-01 09:41:28 |
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;