Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 6,451–6,475 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 6451 | 3478 | 2 | 2017-01-27 13:39:38 |
| 6452 | 3479 | 2 | 2017-01-27 13:42:02 |
| 6453 | 3479 | 1 | 2017-01-27 14:19:42 |
| 6454 | 3478 | 3 | 2017-01-27 14:20:37 |
| 6455 | 3479 | 2 | 2017-01-27 15:09:45 |
| 6456 | 3489 | 2 | 2017-01-27 15:31:12 |
| 6457 | 3491 | 2 | 2017-01-27 15:33:49 |
| 6458 | 3488 | 2 | 2017-01-27 15:34:44 |
| 6459 | 3490 | 2 | 2017-01-27 15:34:54 |
| 6460 | 3491 | 1 | 2017-01-27 16:14:07 |
| 6461 | 3488 | 1 | 2017-01-27 16:20:49 |
| 6462 | 3489 | 1 | 2017-01-27 16:54:51 |
| 6463 | 3490 | 1 | 2017-01-27 17:00:18 |
| 6464 | 3491 | 2 | 2017-01-27 17:05:15 |
| 6465 | 3489 | 2 | 2017-01-27 17:26:24 |
| 6466 | 3488 | 2 | 2017-01-27 17:40:27 |
| 6467 | 3399 | 2 | 2017-01-28 10:41:07 |
| 6468 | 3398 | 2 | 2017-01-28 10:46:11 |
| 6469 | 3400 | 2 | 2017-01-28 10:54:28 |
| 6470 | 3398 | 3 | 2017-01-28 11:21:37 |
| 6471 | 3400 | 3 | 2017-01-28 11:35:13 |
| 6472 | 3399 | 3 | 2017-01-28 12:09:09 |
| 6473 | 3493 | 2 | 2017-01-31 11:28:04 |
| 6474 | 3493 | 3 | 2017-01-31 12:59:57 |
| 6475 | 3476 | 1 | 2017-02-01 10:57:20 |
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;