Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 15,251–15,275 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 15251 | 7747 | 1 | 2019-03-17 16:28:43 |
| 15252 | 7748 | 1 | 2019-03-17 16:30:52 |
| 15253 | 7746 | 1 | 2019-03-17 16:39:00 |
| 15254 | 7749 | 1 | 2019-03-17 16:40:36 |
| 15255 | 7749 | 2 | 2019-03-17 17:17:03 |
| 15256 | 7750 | 3 | 2019-03-17 17:21:38 |
| 15257 | 7747 | 2 | 2019-03-17 17:21:46 |
| 15258 | 7746 | 2 | 2019-03-17 17:38:22 |
| 15259 | 7811 | 3 | 2019-03-18 10:50:47 |
| 15260 | 7811 | 2 | 2019-03-18 12:14:38 |
| 15261 | 7819 | 2 | 2019-03-18 12:34:02 |
| 15262 | 7819 | 3 | 2019-03-18 14:00:01 |
| 15263 | 7820 | 2 | 2019-03-18 15:06:30 |
| 15264 | 7819 | 1 | 2019-03-18 15:22:07 |
| 15265 | 7628 | 2 | 2019-03-19 10:55:15 |
| 15266 | 7629 | 1 | 2019-03-19 10:58:36 |
| 15267 | 7629 | 3 | 2019-03-19 11:43:45 |
| 15268 | 7628 | 1 | 2019-03-19 11:50:02 |
| 15269 | 7629 | 1 | 2019-03-19 13:14:27 |
| 15270 | 7628 | 2 | 2019-03-19 13:15:08 |
| 15271 | 7877 | 2 | 2019-03-19 13:39:45 |
| 15272 | 7876 | 2 | 2019-03-19 13:41:14 |
| 15273 | 7629 | 3 | 2019-03-19 14:04:40 |
| 15274 | 7876 | 3 | 2019-03-19 14:11:48 |
| 15275 | 7877 | 3 | 2019-03-19 14:40:58 |
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;