Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 10,251–10,275 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 10251 | 5306 | 1 | 2018-02-22 12:49:37 |
| 10252 | 5314 | 1 | 2018-02-23 12:29:24 |
| 10253 | 5313 | 1 | 2018-02-23 12:29:33 |
| 10254 | 5313 | 2 | 2018-02-23 13:12:11 |
| 10255 | 5314 | 2 | 2018-02-23 13:42:50 |
| 10256 | 5317 | 2 | 2018-02-24 10:59:34 |
| 10257 | 5318 | 1 | 2018-02-24 11:09:22 |
| 10258 | 5316 | 1 | 2018-02-24 11:10:11 |
| 10259 | 5289 | 1 | 2018-02-24 11:33:38 |
| 10260 | 5290 | 1 | 2018-02-24 11:37:23 |
| 10261 | 5319 | 2 | 2018-02-24 11:50:41 |
| 10262 | 5320 | 2 | 2018-02-24 11:54:28 |
| 10263 | 5316 | 3 | 2018-02-24 12:09:55 |
| 10264 | 5317 | 1 | 2018-02-24 12:21:38 |
| 10265 | 5319 | 3 | 2018-02-24 12:40:47 |
| 10266 | 5320 | 3 | 2018-02-24 12:44:23 |
| 10267 | 5316 | 1 | 2018-02-24 13:00:57 |
| 10268 | 5319 | 2 | 2018-02-24 13:20:40 |
| 10269 | 5317 | 2 | 2018-02-24 13:26:52 |
| 10270 | 5320 | 2 | 2018-02-24 13:27:00 |
| 10271 | 5316 | 2 | 2018-02-24 14:14:04 |
| 10272 | 5317 | 3 | 2018-02-24 14:26:28 |
| 10273 | 5321 | 2 | 2018-02-25 09:35:24 |
| 10274 | 5237 | 2 | 2018-02-25 10:08:03 |
| 10275 | 5321 | 1 | 2018-02-25 10:12:06 |
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;