Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 14,676–14,700 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 14676 | 7401 | 2 | 2019-02-19 09:50:28 |
| 14677 | 7416 | 2 | 2019-02-19 09:50:48 |
| 14678 | 7431 | 2 | 2019-02-19 09:50:50 |
| 14679 | 7415 | 2 | 2019-02-19 09:51:33 |
| 14680 | 7438 | 2 | 2019-02-19 09:51:38 |
| 14681 | 7420 | 2 | 2019-02-19 09:51:43 |
| 14682 | 7432 | 2 | 2019-02-19 09:51:48 |
| 14683 | 7429 | 2 | 2019-02-19 09:51:58 |
| 14684 | 7404 | 2 | 2019-02-19 09:51:59 |
| 14685 | 7400 | 2 | 2019-02-19 09:52:08 |
| 14686 | 7403 | 2 | 2019-02-19 09:52:09 |
| 14687 | 7436 | 2 | 2019-02-19 09:52:09 |
| 14688 | 7389 | 2 | 2019-02-19 09:52:44 |
| 14689 | 7419 | 2 | 2019-02-19 09:52:52 |
| 14690 | 7439 | 2 | 2019-02-19 09:53:13 |
| 14691 | 7392 | 2 | 2019-02-19 09:54:32 |
| 14692 | 7442 | 2 | 2019-02-19 09:55:06 |
| 14693 | 7426 | 2 | 2019-02-19 09:55:12 |
| 14694 | 7424 | 2 | 2019-02-19 09:55:23 |
| 14695 | 7418 | 2 | 2019-02-19 09:55:25 |
| 14696 | 7410 | 2 | 2019-02-19 09:55:46 |
| 14697 | 7408 | 2 | 2019-02-19 09:55:56 |
| 14698 | 7427 | 2 | 2019-02-19 09:56:00 |
| 14699 | 7435 | 2 | 2019-02-19 09:56:02 |
| 14700 | 7406 | 2 | 2019-02-19 09:56:08 |
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;