Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 5,226–5,250 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 5226 | 2644 | 2 | 2016-08-15 13:59:01 |
| 5227 | 2643 | 2 | 2016-08-15 14:10:47 |
| 5228 | 2645 | 2 | 2016-08-15 14:10:47 |
| 5229 | 2646 | 2 | 2016-08-15 14:12:43 |
| 5230 | 2645 | 1 | 2016-08-15 14:47:59 |
| 5231 | 2644 | 3 | 2016-08-15 15:30:15 |
| 5232 | 2649 | 1 | 2016-08-16 12:02:47 |
| 5233 | 2648 | 2 | 2016-08-16 12:04:15 |
| 5234 | 2651 | 1 | 2016-08-16 12:04:40 |
| 5235 | 2652 | 2 | 2016-08-16 12:12:13 |
| 5236 | 2650 | 2 | 2016-08-16 12:15:33 |
| 5237 | 2652 | 1 | 2016-08-16 13:20:10 |
| 5238 | 2652 | 3 | 2016-08-16 14:41:55 |
| 5239 | 2664 | 1 | 2016-08-18 11:05:22 |
| 5240 | 2664 | 2 | 2016-08-18 11:54:50 |
| 5241 | 2581 | 2 | 2016-08-19 14:44:06 |
| 5242 | 2582 | 1 | 2016-08-19 14:58:41 |
| 5243 | 2581 | 3 | 2016-08-19 15:42:12 |
| 5244 | 2582 | 3 | 2016-08-19 15:58:07 |
| 5245 | 2582 | 2 | 2016-08-19 17:19:11 |
| 5246 | 2667 | 2 | 2016-08-20 11:18:35 |
| 5247 | 2668 | 3 | 2016-08-20 11:30:18 |
| 5248 | 2667 | 3 | 2016-08-20 12:01:29 |
| 5249 | 2667 | 2 | 2016-08-20 13:35:26 |
| 5250 | 2667 | 3 | 2016-08-20 14:34:31 |
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;