Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 4,501–4,525 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 4501 | 2388 | 3 | 2016-06-18 13:15:45 |
| 4502 | 2387 | 3 | 2016-06-18 13:16:06 |
| 4503 | 2389 | 1 | 2016-06-18 13:46:21 |
| 4504 | 2388 | 1 | 2016-06-18 13:49:26 |
| 4505 | 2387 | 1 | 2016-06-18 14:50:25 |
| 4506 | 2391 | 1 | 2016-06-19 14:48:19 |
| 4507 | 2392 | 1 | 2016-06-19 14:48:25 |
| 4508 | 2395 | 3 | 2016-06-20 10:50:19 |
| 4509 | 2394 | 3 | 2016-06-20 10:52:18 |
| 4510 | 2393 | 3 | 2016-06-20 10:54:33 |
| 4511 | 2394 | 1 | 2016-06-20 11:54:36 |
| 4512 | 2395 | 1 | 2016-06-20 12:12:56 |
| 4513 | 2393 | 1 | 2016-06-20 12:20:11 |
| 4514 | 2394 | 3 | 2016-06-20 13:08:43 |
| 4515 | 2393 | 3 | 2016-06-20 13:24:56 |
| 4516 | 2209 | 3 | 2016-06-22 09:42:48 |
| 4517 | 2214 | 3 | 2016-06-22 09:44:35 |
| 4518 | 2236 | 3 | 2016-06-22 09:46:07 |
| 4519 | 2213 | 3 | 2016-06-22 09:46:53 |
| 4520 | 2223 | 3 | 2016-06-22 09:48:45 |
| 4521 | 2238 | 3 | 2016-06-22 09:48:56 |
| 4522 | 2212 | 3 | 2016-06-22 09:49:05 |
| 4523 | 2217 | 3 | 2016-06-22 09:49:38 |
| 4524 | 2240 | 3 | 2016-06-22 09:50:27 |
| 4525 | 2227 | 3 | 2016-06-22 09:50:45 |
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;