Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 11,101–11,125 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 11101 | 5383 | 3 | 2018-05-07 12:15:46 |
| 11102 | 5385 | 3 | 2018-05-07 12:16:00 |
| 11103 | 5409 | 3 | 2018-05-07 12:16:09 |
| 11104 | 5426 | 3 | 2018-05-07 12:17:18 |
| 11105 | 5387 | 3 | 2018-05-07 12:17:42 |
| 11106 | 5420 | 3 | 2018-05-07 12:18:27 |
| 11107 | 5405 | 3 | 2018-05-07 12:18:53 |
| 11108 | 5402 | 3 | 2018-05-07 12:19:34 |
| 11109 | 5424 | 3 | 2018-05-07 12:19:46 |
| 11110 | 5382 | 3 | 2018-05-07 12:19:56 |
| 11111 | 5396 | 3 | 2018-05-07 12:20:11 |
| 11112 | 5419 | 3 | 2018-05-07 12:20:18 |
| 11113 | 5379 | 3 | 2018-05-07 12:20:24 |
| 11114 | 5414 | 3 | 2018-05-07 12:20:53 |
| 11115 | 5391 | 3 | 2018-05-07 12:21:23 |
| 11116 | 5395 | 3 | 2018-05-07 12:21:32 |
| 11117 | 5388 | 3 | 2018-05-07 12:21:48 |
| 11118 | 5393 | 3 | 2018-05-07 12:21:51 |
| 11119 | 5400 | 3 | 2018-05-07 12:22:01 |
| 11120 | 5425 | 3 | 2018-05-07 12:22:32 |
| 11121 | 5401 | 3 | 2018-05-07 12:24:10 |
| 11122 | 5403 | 3 | 2018-05-07 12:26:07 |
| 11123 | 5404 | 3 | 2018-05-07 12:26:33 |
| 11124 | 5421 | 3 | 2018-05-07 12:26:35 |
| 11125 | 5417 | 3 | 2018-05-07 12:26:43 |
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;