Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 5,501–5,525 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 5501 | 2821 | 1 | 2016-09-19 12:42:20 |
| 5502 | 2820 | 1 | 2016-09-19 12:48:50 |
| 5503 | 2819 | 1 | 2016-09-19 12:49:28 |
| 5504 | 2824 | 1 | 2016-09-19 16:20:30 |
| 5505 | 2823 | 1 | 2016-09-19 16:26:05 |
| 5506 | 2825 | 1 | 2016-09-19 16:32:38 |
| 5507 | 2824 | 2 | 2016-09-19 16:56:21 |
| 5508 | 2823 | 2 | 2016-09-19 17:06:14 |
| 5509 | 2825 | 2 | 2016-09-19 17:14:02 |
| 5510 | 2822 | 3 | 2016-09-20 09:48:21 |
| 5511 | 2822 | 1 | 2016-09-20 11:07:34 |
| 5512 | 2822 | 3 | 2016-09-20 12:40:06 |
| 5513 | 2822 | 2 | 2016-09-20 13:09:13 |
| 5514 | 2815 | 2 | 2016-09-21 11:17:35 |
| 5515 | 2814 | 2 | 2016-09-21 11:22:37 |
| 5516 | 2815 | 3 | 2016-09-21 11:45:03 |
| 5517 | 2815 | 1 | 2016-09-21 12:27:30 |
| 5518 | 2814 | 3 | 2016-09-21 12:41:25 |
| 5519 | 2828 | 2 | 2016-09-21 12:47:49 |
| 5520 | 2829 | 2 | 2016-09-21 13:00:11 |
| 5521 | 2828 | 3 | 2016-09-21 13:15:14 |
| 5522 | 2829 | 3 | 2016-09-21 14:10:46 |
| 5523 | 2814 | 1 | 2016-09-21 14:14:52 |
| 5524 | 2787 | 2 | 2016-09-21 16:36:23 |
| 5525 | 2788 | 1 | 2016-09-21 16:44:36 |
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;