Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 12,676–12,700 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 12676 | 5908 | 1 | 2018-08-27 11:43:00 |
| 12677 | 5913 | 1 | 2018-08-27 11:43:01 |
| 12678 | 5898 | 2 | 2018-08-27 11:43:14 |
| 12679 | 5933 | 1 | 2018-08-27 11:44:48 |
| 12680 | 5936 | 2 | 2018-08-27 11:44:55 |
| 12681 | 5900 | 1 | 2018-08-27 11:45:00 |
| 12682 | 5727 | 3 | 2018-08-27 11:45:05 |
| 12683 | 5904 | 2 | 2018-08-27 11:46:14 |
| 12684 | 5926 | 2 | 2018-08-27 11:47:08 |
| 12685 | 5723 | 3 | 2018-08-27 11:48:27 |
| 12686 | 5905 | 1 | 2018-08-27 11:49:20 |
| 12687 | 5928 | 1 | 2018-08-27 11:49:47 |
| 12688 | 5927 | 2 | 2018-08-27 11:49:56 |
| 12689 | 5722 | 3 | 2018-08-27 11:50:27 |
| 12690 | 6559 | 3 | 2018-08-27 11:50:44 |
| 12691 | 5906 | 1 | 2018-08-27 11:51:03 |
| 12692 | 5909 | 1 | 2018-08-27 11:51:49 |
| 12693 | 5934 | 1 | 2018-08-27 11:56:18 |
| 12694 | 5712 | 3 | 2018-08-27 11:56:19 |
| 12695 | 5930 | 1 | 2018-08-27 12:04:11 |
| 12696 | 5897 | 1 | 2018-08-27 12:04:34 |
| 12697 | 5732 | 3 | 2018-08-27 12:05:55 |
| 12698 | 5935 | 1 | 2018-08-27 12:05:55 |
| 12699 | 5728 | 3 | 2018-08-27 12:07:47 |
| 12700 | 5912 | 2 | 2018-08-27 12:08:23 |
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;