Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 17,251–17,275 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 17251 | 8695 | 2 | 2019-08-10 15:10:26 |
| 17252 | 8693 | 2 | 2019-08-10 16:38:37 |
| 17253 | 8587 | 1 | 2019-08-11 10:19:48 |
| 17254 | 8586 | 1 | 2019-08-11 10:21:24 |
| 17255 | 8587 | 2 | 2019-08-11 11:08:02 |
| 17256 | 8586 | 2 | 2019-08-11 11:13:56 |
| 17257 | 8587 | 3 | 2019-08-11 11:42:04 |
| 17258 | 8586 | 3 | 2019-08-11 12:00:20 |
| 17259 | 8751 | 2 | 2019-08-11 12:14:46 |
| 17260 | 8747 | 3 | 2019-08-11 12:19:29 |
| 17261 | 8749 | 3 | 2019-08-11 12:19:43 |
| 17262 | 8750 | 3 | 2019-08-11 12:23:47 |
| 17263 | 8748 | 3 | 2019-08-11 12:26:22 |
| 17264 | 8751 | 3 | 2019-08-11 13:42:15 |
| 17265 | 8672 | 2 | 2019-08-12 11:07:49 |
| 17266 | 8670 | 2 | 2019-08-12 11:10:19 |
| 17267 | 8671 | 2 | 2019-08-12 11:13:10 |
| 17268 | 8739 | 1 | 2019-08-12 11:50:52 |
| 17269 | 8740 | 3 | 2019-08-12 11:52:43 |
| 17270 | 8672 | 1 | 2019-08-12 12:02:26 |
| 17271 | 8670 | 1 | 2019-08-12 12:23:23 |
| 17272 | 8671 | 1 | 2019-08-12 12:23:26 |
| 17273 | 8740 | 2 | 2019-08-12 12:50:37 |
| 17274 | 8672 | 2 | 2019-08-12 12:59:16 |
| 17275 | 8670 | 2 | 2019-08-12 13:01:19 |
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;