Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 7,026–7,050 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 7026 | 3685 | 1 | 2017-03-27 10:20:40 |
| 7027 | 3686 | 3 | 2017-03-27 10:52:10 |
| 7028 | 3685 | 3 | 2017-03-27 10:53:48 |
| 7029 | 3685 | 2 | 2017-03-27 11:37:40 |
| 7030 | 3686 | 2 | 2017-03-27 12:24:24 |
| 7031 | 3701 | 3 | 2017-03-28 11:04:49 |
| 7032 | 3697 | 3 | 2017-03-28 11:10:18 |
| 7033 | 3698 | 3 | 2017-03-28 11:12:40 |
| 7034 | 3700 | 3 | 2017-03-28 11:19:01 |
| 7035 | 3699 | 3 | 2017-03-28 11:19:20 |
| 7036 | 3701 | 2 | 2017-03-28 12:14:57 |
| 7037 | 3697 | 2 | 2017-03-28 12:16:57 |
| 7038 | 3694 | 2 | 2017-03-28 12:21:29 |
| 7039 | 3700 | 2 | 2017-03-28 12:30:25 |
| 7040 | 3698 | 2 | 2017-03-28 12:45:15 |
| 7041 | 3699 | 2 | 2017-03-28 12:54:25 |
| 7042 | 3694 | 3 | 2017-03-28 13:05:06 |
| 7043 | 3689 | 1 | 2017-03-29 11:14:09 |
| 7044 | 3689 | 2 | 2017-03-29 12:07:36 |
| 7045 | 3689 | 1 | 2017-03-29 12:56:54 |
| 7046 | 3689 | 2 | 2017-03-29 14:09:11 |
| 7047 | 3702 | 2 | 2017-03-31 13:12:24 |
| 7048 | 3706 | 2 | 2017-03-31 13:25:18 |
| 7049 | 3703 | 2 | 2017-03-31 13:27:41 |
| 7050 | 3705 | 2 | 2017-03-31 13:29:29 |
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;