Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 5,376–5,400 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 5376 | 2769 | 2 | 2016-09-01 11:46:57 |
| 5377 | 2776 | 3 | 2016-09-01 11:51:36 |
| 5378 | 2774 | 3 | 2016-09-01 12:36:32 |
| 5379 | 2775 | 2 | 2016-09-01 12:42:37 |
| 5380 | 2780 | 2 | 2016-09-02 11:34:02 |
| 5381 | 2781 | 2 | 2016-09-02 11:34:56 |
| 5382 | 2654 | 1 | 2016-09-03 09:52:25 |
| 5383 | 2655 | 1 | 2016-09-03 09:53:47 |
| 5384 | 2654 | 3 | 2016-09-03 10:40:29 |
| 5385 | 2743 | 3 | 2016-09-03 10:46:58 |
| 5386 | 2744 | 3 | 2016-09-03 10:55:07 |
| 5387 | 2742 | 3 | 2016-09-03 11:00:30 |
| 5388 | 2655 | 2 | 2016-09-03 11:15:43 |
| 5389 | 2654 | 2 | 2016-09-03 11:32:59 |
| 5390 | 2744 | 2 | 2016-09-03 11:36:17 |
| 5391 | 2743 | 2 | 2016-09-03 11:58:57 |
| 5392 | 2744 | 3 | 2016-09-03 12:20:52 |
| 5393 | 2742 | 2 | 2016-09-03 12:21:51 |
| 5394 | 2743 | 3 | 2016-09-03 12:27:49 |
| 5395 | 2654 | 3 | 2016-09-03 12:41:14 |
| 5396 | 2742 | 3 | 2016-09-03 13:41:43 |
| 5397 | 2782 | 1 | 2016-09-04 12:33:09 |
| 5398 | 2782 | 3 | 2016-09-04 13:51:35 |
| 5399 | 2786 | 2 | 2016-09-05 10:28:24 |
| 5400 | 2786 | 3 | 2016-09-05 11:18:14 |
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;