Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 15,101–15,125 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 15101 | 7485 | 3 | 2019-03-15 13:15:39 |
| 15102 | 7486 | 3 | 2019-03-15 13:15:51 |
| 15103 | 7495 | 3 | 2019-03-15 13:17:47 |
| 15104 | 7521 | 3 | 2019-03-15 13:17:55 |
| 15105 | 7505 | 3 | 2019-03-15 13:18:01 |
| 15106 | 7501 | 3 | 2019-03-15 13:18:20 |
| 15107 | 7493 | 3 | 2019-03-15 13:18:26 |
| 15108 | 7514 | 3 | 2019-03-15 13:18:33 |
| 15109 | 7498 | 3 | 2019-03-15 13:19:02 |
| 15110 | 7503 | 3 | 2019-03-15 13:19:13 |
| 15111 | 7519 | 3 | 2019-03-15 13:19:36 |
| 15112 | 7502 | 3 | 2019-03-15 13:19:54 |
| 15113 | 7508 | 3 | 2019-03-15 13:19:59 |
| 15114 | 7482 | 3 | 2019-03-15 13:20:47 |
| 15115 | 7484 | 3 | 2019-03-15 13:20:58 |
| 15116 | 7510 | 3 | 2019-03-15 13:21:53 |
| 15117 | 7481 | 3 | 2019-03-15 13:22:00 |
| 15118 | 7492 | 3 | 2019-03-15 13:22:36 |
| 15119 | 7504 | 3 | 2019-03-15 13:22:51 |
| 15120 | 7520 | 3 | 2019-03-15 13:22:53 |
| 15121 | 7479 | 3 | 2019-03-15 13:22:58 |
| 15122 | 7480 | 3 | 2019-03-15 13:23:31 |
| 15123 | 7518 | 3 | 2019-03-15 13:23:37 |
| 15124 | 7491 | 3 | 2019-03-15 13:23:48 |
| 15125 | 7524 | 3 | 2019-03-15 13:24:15 |
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;