Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 18,051–18,075 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 18051 | 9327 | 1 | 2019-10-29 13:16:08 |
| 18052 | 9315 | 2 | 2019-10-29 13:20:46 |
| 18053 | 9307 | 1 | 2019-10-29 13:23:45 |
| 18054 | 9314 | 2 | 2019-10-29 13:28:07 |
| 18055 | 9317 | 2 | 2019-10-29 13:28:56 |
| 18056 | 9308 | 1 | 2019-10-29 13:31:40 |
| 18057 | 9313 | 2 | 2019-10-29 13:31:52 |
| 18058 | 9316 | 2 | 2019-10-29 13:32:21 |
| 18059 | 9314 | 3 | 2019-10-29 13:54:25 |
| 18060 | 9317 | 3 | 2019-10-29 13:56:15 |
| 18061 | 9313 | 3 | 2019-10-29 13:59:14 |
| 18062 | 9307 | 2 | 2019-10-29 14:14:33 |
| 18063 | 9329 | 1 | 2019-10-29 14:18:57 |
| 18064 | 9308 | 2 | 2019-10-29 14:28:25 |
| 18065 | 9315 | 3 | 2019-10-29 14:29:55 |
| 18066 | 9308 | 3 | 2019-10-29 14:55:02 |
| 18067 | 9316 | 3 | 2019-10-29 15:05:41 |
| 18068 | 9334 | 2 | 2019-10-29 15:08:42 |
| 18069 | 9307 | 3 | 2019-10-29 15:11:00 |
| 18070 | 9332 | 2 | 2019-10-29 15:14:50 |
| 18071 | 9333 | 2 | 2019-10-29 15:15:56 |
| 18072 | 9331 | 2 | 2019-10-29 15:18:26 |
| 18073 | 9333 | 1 | 2019-10-29 16:12:53 |
| 18074 | 9334 | 1 | 2019-10-29 16:17:46 |
| 18075 | 9332 | 1 | 2019-10-29 16:19:47 |
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;