Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 10,476–10,500 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 10476 | 5170 | 2 | 2018-03-23 12:15:35 |
| 10477 | 5178 | 2 | 2018-03-23 12:15:37 |
| 10478 | 5194 | 2 | 2018-03-23 12:15:49 |
| 10479 | 5165 | 2 | 2018-03-23 12:16:17 |
| 10480 | 5159 | 2 | 2018-03-23 12:16:59 |
| 10481 | 5180 | 2 | 2018-03-23 12:17:21 |
| 10482 | 5189 | 2 | 2018-03-23 12:17:23 |
| 10483 | 5172 | 2 | 2018-03-23 12:17:25 |
| 10484 | 5175 | 2 | 2018-03-23 12:17:27 |
| 10485 | 5191 | 2 | 2018-03-23 12:17:59 |
| 10486 | 5192 | 2 | 2018-03-23 12:19:03 |
| 10487 | 5182 | 2 | 2018-03-23 12:19:34 |
| 10488 | 5186 | 2 | 2018-03-23 12:19:42 |
| 10489 | 5185 | 2 | 2018-03-23 12:20:27 |
| 10490 | 5190 | 2 | 2018-03-23 12:21:27 |
| 10491 | 5196 | 2 | 2018-03-23 12:21:59 |
| 10492 | 5171 | 2 | 2018-03-23 12:23:17 |
| 10493 | 5179 | 2 | 2018-03-23 12:23:55 |
| 10494 | 5177 | 2 | 2018-03-23 12:24:33 |
| 10495 | 5150 | 2 | 2018-03-23 12:26:25 |
| 10496 | 5163 | 2 | 2018-03-23 12:26:49 |
| 10497 | 5183 | 2 | 2018-03-23 12:26:50 |
| 10498 | 5176 | 2 | 2018-03-23 12:26:55 |
| 10499 | 5158 | 2 | 2018-03-23 12:27:02 |
| 10500 | 5168 | 2 | 2018-03-23 12:27:03 |
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;