Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 11,051–11,075 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 11051 | 5697 | 1 | 2018-05-06 11:10:39 |
| 11052 | 5695 | 3 | 2018-05-06 11:16:11 |
| 11053 | 5700 | 1 | 2018-05-06 11:27:39 |
| 11054 | 5655 | 3 | 2018-05-06 11:33:15 |
| 11055 | 5698 | 2 | 2018-05-06 11:45:07 |
| 11056 | 5697 | 2 | 2018-05-06 11:52:53 |
| 11057 | 5699 | 2 | 2018-05-06 11:53:48 |
| 11058 | 5695 | 1 | 2018-05-06 12:11:34 |
| 11059 | 5700 | 2 | 2018-05-06 12:18:34 |
| 11060 | 5699 | 1 | 2018-05-06 12:23:27 |
| 11061 | 5698 | 1 | 2018-05-06 12:39:26 |
| 11062 | 5697 | 1 | 2018-05-06 13:06:36 |
| 11063 | 5700 | 1 | 2018-05-06 13:09:24 |
| 11064 | 5581 | 3 | 2018-05-06 13:29:33 |
| 11065 | 5578 | 2 | 2018-05-06 13:32:49 |
| 11066 | 5580 | 2 | 2018-05-06 13:34:15 |
| 11067 | 5579 | 2 | 2018-05-06 13:36:57 |
| 11068 | 5581 | 1 | 2018-05-06 14:01:27 |
| 11069 | 5578 | 1 | 2018-05-06 14:06:12 |
| 11070 | 5580 | 3 | 2018-05-06 14:17:41 |
| 11071 | 5579 | 3 | 2018-05-06 14:34:23 |
| 11072 | 5578 | 3 | 2018-05-06 15:02:44 |
| 11073 | 5580 | 2 | 2018-05-06 15:41:34 |
| 11074 | 5579 | 2 | 2018-05-06 15:41:37 |
| 11075 | 5578 | 1 | 2018-05-06 16:32:31 |
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;