Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 16,526–16,550 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 16526 | 8406 | 2 | 2019-06-22 10:03:04 |
| 16527 | 8416 | 1 | 2019-06-22 10:04:06 |
| 16528 | 8418 | 1 | 2019-06-22 10:05:59 |
| 16529 | 8405 | 2 | 2019-06-22 10:07:27 |
| 16530 | 8417 | 1 | 2019-06-22 10:11:22 |
| 16531 | 8404 | 2 | 2019-06-22 10:13:25 |
| 16532 | 8419 | 1 | 2019-06-22 10:17:19 |
| 16533 | 8396 | 2 | 2019-06-22 10:33:29 |
| 16534 | 8365 | 2 | 2019-06-22 11:20:57 |
| 16535 | 8366 | 2 | 2019-06-22 11:23:55 |
| 16536 | 8416 | 3 | 2019-06-22 11:24:17 |
| 16537 | 8419 | 3 | 2019-06-22 11:30:19 |
| 16538 | 8418 | 3 | 2019-06-22 11:37:33 |
| 16539 | 8404 | 3 | 2019-06-22 11:37:36 |
| 16540 | 8417 | 3 | 2019-06-22 11:44:54 |
| 16541 | 8401 | 3 | 2019-06-22 12:00:39 |
| 16542 | 8400 | 1 | 2019-06-22 12:00:40 |
| 16543 | 8404 | 2 | 2019-06-22 12:05:58 |
| 16544 | 8403 | 3 | 2019-06-22 12:05:59 |
| 16545 | 8402 | 2 | 2019-06-22 12:08:03 |
| 16546 | 8359 | 3 | 2019-06-22 12:23:37 |
| 16547 | 8358 | 3 | 2019-06-22 12:27:53 |
| 16548 | 8401 | 2 | 2019-06-22 12:28:56 |
| 16549 | 8354 | 3 | 2019-06-22 12:31:27 |
| 16550 | 8353 | 3 | 2019-06-22 12:35:22 |
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;