Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 11,026–11,050 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 11026 | 5688 | 1 | 2018-05-04 15:28:48 |
| 11027 | 5691 | 2 | 2018-05-05 09:44:32 |
| 11028 | 5692 | 2 | 2018-05-05 09:48:01 |
| 11029 | 5691 | 1 | 2018-05-05 10:26:10 |
| 11030 | 5692 | 1 | 2018-05-05 10:26:46 |
| 11031 | 5693 | 2 | 2018-05-05 10:27:53 |
| 11032 | 5694 | 2 | 2018-05-05 10:35:18 |
| 11033 | 5694 | 3 | 2018-05-05 11:16:57 |
| 11034 | 5693 | 3 | 2018-05-05 11:41:07 |
| 11035 | 5692 | 3 | 2018-05-05 12:00:40 |
| 11036 | 5694 | 2 | 2018-05-05 12:01:43 |
| 11037 | 5693 | 2 | 2018-05-05 12:14:48 |
| 11038 | 5692 | 2 | 2018-05-05 12:30:59 |
| 11039 | 5690 | 1 | 2018-05-05 13:14:50 |
| 11040 | 5699 | 2 | 2018-05-06 09:53:36 |
| 11041 | 5697 | 2 | 2018-05-06 09:59:29 |
| 11042 | 5700 | 2 | 2018-05-06 10:01:14 |
| 11043 | 5698 | 2 | 2018-05-06 10:04:21 |
| 11044 | 5695 | 2 | 2018-05-06 10:16:01 |
| 11045 | 5696 | 3 | 2018-05-06 10:17:20 |
| 11046 | 5655 | 2 | 2018-05-06 10:25:08 |
| 11047 | 5656 | 2 | 2018-05-06 10:25:59 |
| 11048 | 5698 | 1 | 2018-05-06 10:47:29 |
| 11049 | 5699 | 1 | 2018-05-06 10:54:04 |
| 11050 | 5656 | 3 | 2018-05-06 11:06:35 |
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;