Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 10,176–10,200 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 10176 | 4960 | 3 | 2018-02-11 14:45:44 |
| 10177 | 4958 | 1 | 2018-02-11 15:44:15 |
| 10178 | 5267 | 3 | 2018-02-11 15:53:37 |
| 10179 | 4958 | 3 | 2018-02-11 16:44:13 |
| 10180 | 5267 | 2 | 2018-02-11 17:24:35 |
| 10181 | 5223 | 2 | 2018-02-13 10:23:43 |
| 10182 | 5225 | 3 | 2018-02-13 10:32:50 |
| 10183 | 5222 | 2 | 2018-02-13 10:36:13 |
| 10184 | 5224 | 2 | 2018-02-13 10:36:47 |
| 10185 | 5222 | 1 | 2018-02-13 11:44:36 |
| 10186 | 5224 | 3 | 2018-02-13 11:50:33 |
| 10187 | 5223 | 3 | 2018-02-13 11:58:20 |
| 10188 | 5225 | 2 | 2018-02-13 12:05:23 |
| 10189 | 5224 | 1 | 2018-02-13 12:27:03 |
| 10190 | 5223 | 1 | 2018-02-13 12:32:42 |
| 10191 | 5265 | 2 | 2018-02-13 12:58:20 |
| 10192 | 5262 | 3 | 2018-02-13 13:00:30 |
| 10193 | 5264 | 3 | 2018-02-13 13:02:43 |
| 10194 | 5263 | 3 | 2018-02-13 13:09:48 |
| 10195 | 5224 | 3 | 2018-02-13 13:13:55 |
| 10196 | 5223 | 3 | 2018-02-13 13:44:21 |
| 10197 | 5265 | 1 | 2018-02-13 13:54:05 |
| 10198 | 5280 | 2 | 2018-02-13 14:35:03 |
| 10199 | 5280 | 1 | 2018-02-13 15:18:38 |
| 10200 | 5280 | 3 | 2018-02-13 16:38:45 |
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;