Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 8,351–8,375 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 8351 | 4316 | 1 | 2017-07-30 14:41:58 |
| 8352 | 4319 | 2 | 2017-07-31 09:26:33 |
| 8353 | 4320 | 3 | 2017-07-31 09:35:24 |
| 8354 | 4320 | 1 | 2017-07-31 11:01:55 |
| 8355 | 4323 | 2 | 2017-07-31 11:27:24 |
| 8356 | 4323 | 1 | 2017-07-31 12:23:32 |
| 8357 | 4317 | 1 | 2017-07-31 14:07:43 |
| 8358 | 4318 | 1 | 2017-07-31 14:20:26 |
| 8359 | 4317 | 3 | 2017-07-31 14:41:40 |
| 8360 | 4318 | 3 | 2017-07-31 15:38:48 |
| 8361 | 4321 | 1 | 2017-08-01 16:19:10 |
| 8362 | 4322 | 2 | 2017-08-01 16:29:45 |
| 8363 | 4331 | 2 | 2017-08-02 16:00:24 |
| 8364 | 4332 | 2 | 2017-08-02 16:04:20 |
| 8365 | 4330 | 2 | 2017-08-02 16:07:34 |
| 8366 | 4328 | 2 | 2017-08-02 16:07:36 |
| 8367 | 4329 | 2 | 2017-08-02 16:14:45 |
| 8368 | 4332 | 1 | 2017-08-02 16:49:57 |
| 8369 | 4331 | 3 | 2017-08-02 17:10:44 |
| 8370 | 4330 | 3 | 2017-08-02 17:15:03 |
| 8371 | 4328 | 3 | 2017-08-02 17:19:53 |
| 8372 | 4329 | 3 | 2017-08-02 17:22:27 |
| 8373 | 4333 | 2 | 2017-08-04 12:04:25 |
| 8374 | 4192 | 2 | 2017-08-04 16:10:00 |
| 8375 | 4324 | 2 | 2017-08-05 10:36:21 |
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;