Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 5,251–5,275 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 5251 | 2631 | 2 | 2016-08-20 15:29:08 |
| 5252 | 2632 | 3 | 2016-08-20 15:32:36 |
| 5253 | 2633 | 2 | 2016-08-20 15:37:16 |
| 5254 | 2632 | 2 | 2016-08-20 16:26:24 |
| 5255 | 2631 | 1 | 2016-08-20 16:41:54 |
| 5256 | 2632 | 1 | 2016-08-20 16:56:12 |
| 5257 | 2633 | 1 | 2016-08-20 17:06:17 |
| 5258 | 2631 | 2 | 2016-08-20 17:29:25 |
| 5259 | 2633 | 2 | 2016-08-20 17:41:56 |
| 5260 | 2672 | 3 | 2016-08-21 10:43:02 |
| 5261 | 2674 | 3 | 2016-08-21 10:45:11 |
| 5262 | 2671 | 3 | 2016-08-21 10:46:13 |
| 5263 | 2675 | 3 | 2016-08-21 10:52:31 |
| 5264 | 2673 | 3 | 2016-08-21 10:52:55 |
| 5265 | 2674 | 2 | 2016-08-21 12:07:51 |
| 5266 | 2674 | 3 | 2016-08-21 13:14:48 |
| 5267 | 2670 | 2 | 2016-08-21 13:57:15 |
| 5268 | 2669 | 2 | 2016-08-21 14:00:39 |
| 5269 | 2680 | 3 | 2016-08-21 14:42:46 |
| 5270 | 2679 | 3 | 2016-08-21 14:43:01 |
| 5271 | 2676 | 3 | 2016-08-21 14:43:08 |
| 5272 | 2678 | 3 | 2016-08-21 14:47:54 |
| 5273 | 2677 | 3 | 2016-08-21 14:49:02 |
| 5274 | 2653 | 2 | 2016-08-21 14:53:19 |
| 5275 | 2676 | 1 | 2016-08-21 15:13:25 |
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;