Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 10,301–10,325 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 10301 | 5328 | 2 | 2018-02-26 12:22:59 |
| 10302 | 5327 | 2 | 2018-02-26 13:18:36 |
| 10303 | 5327 | 1 | 2018-02-26 14:27:28 |
| 10304 | 5304 | 1 | 2018-02-26 15:04:27 |
| 10305 | 5305 | 1 | 2018-02-26 15:07:17 |
| 10306 | 5303 | 1 | 2018-02-26 15:08:18 |
| 10307 | 5304 | 2 | 2018-02-26 16:11:56 |
| 10308 | 5303 | 2 | 2018-02-26 16:14:06 |
| 10309 | 5305 | 2 | 2018-02-26 16:32:02 |
| 10310 | 5333 | 2 | 2018-02-27 09:24:23 |
| 10311 | 5333 | 3 | 2018-02-27 10:26:23 |
| 10312 | 5333 | 2 | 2018-02-27 11:08:04 |
| 10313 | 5296 | 2 | 2018-02-27 16:24:50 |
| 10314 | 5295 | 2 | 2018-02-27 16:35:50 |
| 10315 | 5296 | 3 | 2018-02-27 17:01:48 |
| 10316 | 5295 | 3 | 2018-02-27 17:14:31 |
| 10317 | 5335 | 2 | 2018-03-01 10:35:33 |
| 10318 | 5336 | 2 | 2018-03-01 10:41:02 |
| 10319 | 5266 | 1 | 2018-03-01 11:09:49 |
| 10320 | 5335 | 3 | 2018-03-01 11:35:07 |
| 10321 | 5336 | 3 | 2018-03-01 12:07:00 |
| 10322 | 5336 | 2 | 2018-03-01 12:34:31 |
| 10323 | 5266 | 3 | 2018-03-01 12:42:23 |
| 10324 | 5335 | 2 | 2018-03-01 12:48:19 |
| 10325 | 5266 | 2 | 2018-03-01 13:29:59 |
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;