Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 17,051–17,075 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 17051 | 8567 | 1 | 2019-07-27 10:20:41 |
| 17052 | 8569 | 1 | 2019-07-27 10:25:52 |
| 17053 | 8568 | 1 | 2019-07-27 10:36:13 |
| 17054 | 8634 | 1 | 2019-07-27 11:30:52 |
| 17055 | 8633 | 1 | 2019-07-27 11:34:55 |
| 17056 | 8647 | 2 | 2019-07-27 12:21:28 |
| 17057 | 8645 | 2 | 2019-07-27 12:23:18 |
| 17058 | 8646 | 2 | 2019-07-27 12:28:51 |
| 17059 | 8649 | 2 | 2019-07-27 12:46:10 |
| 17060 | 8648 | 2 | 2019-07-27 12:55:08 |
| 17061 | 8647 | 1 | 2019-07-27 13:00:24 |
| 17062 | 8646 | 1 | 2019-07-27 13:11:00 |
| 17063 | 8645 | 1 | 2019-07-27 13:38:58 |
| 17064 | 8650 | 2 | 2019-07-27 15:10:51 |
| 17065 | 8651 | 2 | 2019-07-27 15:15:07 |
| 17066 | 8651 | 3 | 2019-07-27 16:12:21 |
| 17067 | 8650 | 3 | 2019-07-27 16:22:21 |
| 17068 | 8524 | 2 | 2019-07-28 09:11:49 |
| 17069 | 8523 | 1 | 2019-07-28 09:13:09 |
| 17070 | 8525 | 2 | 2019-07-28 09:13:30 |
| 17071 | 8526 | 2 | 2019-07-28 09:14:55 |
| 17072 | 8654 | 1 | 2019-07-28 14:00:25 |
| 17073 | 8654 | 2 | 2019-07-28 14:29:52 |
| 17074 | 8654 | 3 | 2019-07-28 16:00:18 |
| 17075 | 8640 | 2 | 2019-07-29 14:09:18 |
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;