Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 18,251–18,275 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 18251 | 9359 | 1 | 2019-11-09 14:55:45 |
| 18252 | 9361 | 1 | 2019-11-09 14:57:08 |
| 18253 | 9360 | 1 | 2019-11-09 14:58:27 |
| 18254 | 9340 | 3 | 2019-11-10 11:05:25 |
| 18255 | 9383 | 2 | 2019-11-10 11:06:48 |
| 18256 | 9341 | 3 | 2019-11-10 11:07:54 |
| 18257 | 9383 | 1 | 2019-11-10 11:41:07 |
| 18258 | 9340 | 2 | 2019-11-10 11:53:23 |
| 18259 | 9341 | 2 | 2019-11-10 12:18:53 |
| 18260 | 9341 | 1 | 2019-11-10 12:51:53 |
| 18261 | 9340 | 1 | 2019-11-10 12:56:39 |
| 18262 | 9340 | 3 | 2019-11-10 13:33:24 |
| 18263 | 9341 | 3 | 2019-11-10 14:20:13 |
| 18264 | 9385 | 2 | 2019-11-11 09:34:49 |
| 18265 | 9386 | 2 | 2019-11-11 09:40:24 |
| 18266 | 9391 | 2 | 2019-11-11 09:41:54 |
| 18267 | 9387 | 2 | 2019-11-11 09:46:46 |
| 18268 | 9392 | 2 | 2019-11-11 09:47:28 |
| 18269 | 9389 | 2 | 2019-11-11 09:47:30 |
| 18270 | 9390 | 2 | 2019-11-11 09:48:27 |
| 18271 | 9388 | 2 | 2019-11-11 09:54:20 |
| 18272 | 9384 | 2 | 2019-11-11 10:04:01 |
| 18273 | 9385 | 1 | 2019-11-11 10:06:44 |
| 18274 | 9389 | 3 | 2019-11-11 10:19:07 |
| 18275 | 9391 | 3 | 2019-11-11 10:44:47 |
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;