Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 5,326–5,350 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 5326 | 2739 | 2 | 2016-08-26 09:32:17 |
| 5327 | 2740 | 2 | 2016-08-26 10:00:44 |
| 5328 | 2741 | 2 | 2016-08-26 10:10:44 |
| 5329 | 2740 | 1 | 2016-08-26 10:47:58 |
| 5330 | 2741 | 1 | 2016-08-26 11:10:40 |
| 5331 | 2746 | 3 | 2016-08-26 12:06:03 |
| 5332 | 2745 | 2 | 2016-08-26 12:10:42 |
| 5333 | 2745 | 1 | 2016-08-26 12:48:31 |
| 5334 | 2746 | 2 | 2016-08-26 13:05:23 |
| 5335 | 2745 | 3 | 2016-08-26 13:23:49 |
| 5336 | 2746 | 3 | 2016-08-26 13:35:15 |
| 5337 | 2657 | 1 | 2016-08-26 14:53:56 |
| 5338 | 2656 | 1 | 2016-08-26 14:53:57 |
| 5339 | 2747 | 3 | 2016-08-27 10:19:36 |
| 5340 | 2749 | 2 | 2016-08-28 10:25:09 |
| 5341 | 2748 | 2 | 2016-08-28 10:41:21 |
| 5342 | 2749 | 3 | 2016-08-28 11:10:16 |
| 5343 | 2752 | 2 | 2016-08-28 11:33:03 |
| 5344 | 2748 | 3 | 2016-08-28 12:15:11 |
| 5345 | 2752 | 1 | 2016-08-28 13:08:07 |
| 5346 | 2752 | 2 | 2016-08-28 14:15:04 |
| 5347 | 2750 | 2 | 2016-08-29 09:59:04 |
| 5348 | 2751 | 3 | 2016-08-29 10:05:51 |
| 5349 | 2751 | 1 | 2016-08-29 11:03:07 |
| 5350 | 2750 | 1 | 2016-08-29 11:11:16 |
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;