Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 5,276–5,300 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 5276 | 2680 | 1 | 2016-08-21 15:18:41 |
| 5277 | 2679 | 1 | 2016-08-21 15:19:37 |
| 5278 | 2677 | 1 | 2016-08-21 15:22:45 |
| 5279 | 2653 | 1 | 2016-08-21 15:42:46 |
| 5280 | 2678 | 1 | 2016-08-21 16:11:34 |
| 5281 | 2659 | 2 | 2016-08-23 12:37:52 |
| 5282 | 2658 | 2 | 2016-08-23 12:43:38 |
| 5283 | 2661 | 2 | 2016-08-23 12:45:44 |
| 5284 | 2660 | 2 | 2016-08-23 12:51:18 |
| 5285 | 2624 | 1 | 2016-08-23 12:59:02 |
| 5286 | 2626 | 1 | 2016-08-23 13:00:37 |
| 5287 | 2625 | 1 | 2016-08-23 13:05:16 |
| 5288 | 2627 | 1 | 2016-08-23 13:09:10 |
| 5289 | 2658 | 1 | 2016-08-23 13:34:47 |
| 5290 | 2624 | 2 | 2016-08-23 13:53:00 |
| 5291 | 2626 | 2 | 2016-08-23 13:55:40 |
| 5292 | 2627 | 2 | 2016-08-23 14:20:32 |
| 5293 | 2658 | 2 | 2016-08-23 14:22:25 |
| 5294 | 2693 | 1 | 2016-08-24 09:22:24 |
| 5295 | 2692 | 1 | 2016-08-24 09:25:09 |
| 5296 | 2693 | 2 | 2016-08-24 09:54:10 |
| 5297 | 2663 | 2 | 2016-08-24 10:10:19 |
| 5298 | 2662 | 2 | 2016-08-24 10:23:33 |
| 5299 | 2692 | 2 | 2016-08-24 10:27:16 |
| 5300 | 2693 | 1 | 2016-08-24 10:39:11 |
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;