Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 14,776–14,800 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 14776 | 7425 | 2 | 2019-02-19 11:22:14 |
| 14777 | 7396 | 1 | 2019-02-19 11:22:22 |
| 14778 | 7404 | 1 | 2019-02-19 11:23:32 |
| 14779 | 7420 | 2 | 2019-02-19 11:24:15 |
| 14780 | 7418 | 2 | 2019-02-19 11:24:35 |
| 14781 | 7656 | 1 | 2019-02-19 11:25:57 |
| 14782 | 7431 | 2 | 2019-02-19 11:26:11 |
| 14783 | 7437 | 2 | 2019-02-19 11:26:58 |
| 14784 | 7432 | 1 | 2019-02-19 11:27:22 |
| 14785 | 7405 | 1 | 2019-02-19 11:28:11 |
| 14786 | 7441 | 1 | 2019-02-19 11:29:13 |
| 14787 | 7393 | 2 | 2019-02-19 11:29:36 |
| 14788 | 7410 | 1 | 2019-02-19 11:30:39 |
| 14789 | 7401 | 2 | 2019-02-19 11:32:42 |
| 14790 | 7412 | 2 | 2019-02-19 11:32:42 |
| 14791 | 7421 | 2 | 2019-02-19 11:32:42 |
| 14792 | 7400 | 2 | 2019-02-19 11:33:33 |
| 14793 | 7435 | 2 | 2019-02-19 11:37:05 |
| 14794 | 7414 | 2 | 2019-02-19 11:37:08 |
| 14795 | 7428 | 2 | 2019-02-19 11:37:54 |
| 14796 | 7411 | 2 | 2019-02-19 11:38:21 |
| 14797 | 7389 | 2 | 2019-02-19 11:42:45 |
| 14798 | 7392 | 2 | 2019-02-19 11:42:54 |
| 14799 | 7424 | 2 | 2019-02-19 11:44:04 |
| 14800 | 7464 | 2 | 2019-02-19 11:45:46 |
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;