Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 10,226–10,250 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 10226 | 5287 | 3 | 2018-02-16 15:55:27 |
| 10227 | 5287 | 1 | 2018-02-16 16:44:49 |
| 10228 | 5288 | 2 | 2018-02-16 16:57:09 |
| 10229 | 5261 | 2 | 2018-02-17 10:51:40 |
| 10230 | 5291 | 2 | 2018-02-17 14:12:52 |
| 10231 | 5291 | 3 | 2018-02-17 15:03:36 |
| 10232 | 5298 | 1 | 2018-02-18 15:51:57 |
| 10233 | 5297 | 1 | 2018-02-18 15:59:42 |
| 10234 | 5270 | 2 | 2018-02-21 13:13:27 |
| 10235 | 5272 | 2 | 2018-02-21 13:17:29 |
| 10236 | 5271 | 2 | 2018-02-21 13:18:23 |
| 10237 | 5272 | 1 | 2018-02-21 14:30:46 |
| 10238 | 5270 | 3 | 2018-02-21 14:42:28 |
| 10239 | 5271 | 1 | 2018-02-21 14:52:58 |
| 10240 | 5271 | 2 | 2018-02-21 15:19:04 |
| 10241 | 5272 | 2 | 2018-02-21 15:58:27 |
| 10242 | 5259 | 2 | 2018-02-21 16:39:06 |
| 10243 | 5260 | 2 | 2018-02-21 16:44:52 |
| 10244 | 5259 | 1 | 2018-02-21 17:49:31 |
| 10245 | 5269 | 2 | 2018-02-22 10:14:46 |
| 10246 | 5268 | 2 | 2018-02-22 10:15:14 |
| 10247 | 5268 | 3 | 2018-02-22 10:53:42 |
| 10248 | 5306 | 2 | 2018-02-22 11:29:44 |
| 10249 | 5269 | 3 | 2018-02-22 11:49:27 |
| 10250 | 5306 | 3 | 2018-02-22 12:19:46 |
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;