Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 10,451–10,475 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 10451 | 5334 | 1 | 2018-03-20 14:49:03 |
| 10452 | 5334 | 3 | 2018-03-20 15:58:44 |
| 10453 | 5443 | 1 | 2018-03-21 09:39:41 |
| 10454 | 5444 | 1 | 2018-03-21 09:41:12 |
| 10455 | 5308 | 2 | 2018-03-21 09:50:02 |
| 10456 | 5309 | 2 | 2018-03-21 09:51:55 |
| 10457 | 5451 | 1 | 2018-03-21 09:54:47 |
| 10458 | 5307 | 2 | 2018-03-21 10:03:44 |
| 10459 | 5451 | 3 | 2018-03-21 10:52:26 |
| 10460 | 5357 | 2 | 2018-03-21 12:16:42 |
| 10461 | 5357 | 1 | 2018-03-21 13:39:29 |
| 10462 | 5429 | 1 | 2018-03-22 09:11:09 |
| 10463 | 5430 | 1 | 2018-03-22 09:20:16 |
| 10464 | 5429 | 3 | 2018-03-22 10:05:11 |
| 10465 | 5430 | 3 | 2018-03-22 10:32:29 |
| 10466 | 5156 | 2 | 2018-03-23 12:12:13 |
| 10467 | 5153 | 2 | 2018-03-23 12:12:41 |
| 10468 | 5164 | 2 | 2018-03-23 12:12:53 |
| 10469 | 5174 | 2 | 2018-03-23 12:14:23 |
| 10470 | 5152 | 2 | 2018-03-23 12:14:25 |
| 10471 | 5197 | 2 | 2018-03-23 12:14:36 |
| 10472 | 5151 | 2 | 2018-03-23 12:14:42 |
| 10473 | 5161 | 2 | 2018-03-23 12:15:21 |
| 10474 | 5160 | 2 | 2018-03-23 12:15:25 |
| 10475 | 5184 | 2 | 2018-03-23 12:15:27 |
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;