Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 16,326–16,350 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 16326 | 8000 | 3 | 2019-05-31 16:25:43 |
| 16327 | 8008 | 3 | 2019-05-31 16:27:55 |
| 16328 | 8194 | 2 | 2019-06-01 10:54:53 |
| 16329 | 8193 | 2 | 2019-06-01 10:55:44 |
| 16330 | 8195 | 2 | 2019-06-01 10:56:31 |
| 16331 | 8305 | 2 | 2019-06-02 10:24:25 |
| 16332 | 8304 | 2 | 2019-06-02 10:25:48 |
| 16333 | 8304 | 1 | 2019-06-02 10:52:39 |
| 16334 | 8305 | 1 | 2019-06-02 10:57:42 |
| 16335 | 8198 | 2 | 2019-06-02 11:24:36 |
| 16336 | 8275 | 2 | 2019-06-02 14:05:55 |
| 16337 | 8300 | 3 | 2019-06-02 14:31:37 |
| 16338 | 8300 | 1 | 2019-06-02 14:58:23 |
| 16339 | 8302 | 2 | 2019-06-02 15:16:18 |
| 16340 | 8303 | 2 | 2019-06-02 15:20:14 |
| 16341 | 8300 | 3 | 2019-06-02 15:43:47 |
| 16342 | 8303 | 1 | 2019-06-02 16:49:04 |
| 16343 | 8300 | 2 | 2019-06-02 17:17:33 |
| 16344 | 8277 | 2 | 2019-06-02 17:18:32 |
| 16345 | 8296 | 2 | 2019-06-03 11:04:35 |
| 16346 | 8295 | 1 | 2019-06-03 11:14:46 |
| 16347 | 8285 | 2 | 2019-06-03 11:35:47 |
| 16348 | 8284 | 1 | 2019-06-03 11:42:36 |
| 16349 | 8295 | 3 | 2019-06-03 11:49:44 |
| 16350 | 8296 | 1 | 2019-06-03 11:55:08 |
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;