Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 15,401–15,425 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 15401 | 7321 | 3 | 2019-04-02 10:18:16 |
| 15402 | 7320 | 3 | 2019-04-02 10:18:18 |
| 15403 | 7319 | 3 | 2019-04-02 10:18:23 |
| 15404 | 7325 | 3 | 2019-04-02 10:19:38 |
| 15405 | 7327 | 3 | 2019-04-02 10:20:35 |
| 15406 | 7322 | 3 | 2019-04-02 10:21:57 |
| 15407 | 7298 | 3 | 2019-04-02 10:22:20 |
| 15408 | 7918 | 2 | 2019-04-02 10:23:38 |
| 15409 | 7328 | 3 | 2019-04-02 10:23:47 |
| 15410 | 7302 | 3 | 2019-04-02 10:25:55 |
| 15411 | 7309 | 3 | 2019-04-02 10:26:28 |
| 15412 | 7297 | 3 | 2019-04-02 10:26:44 |
| 15413 | 7310 | 3 | 2019-04-02 10:27:09 |
| 15414 | 7303 | 3 | 2019-04-02 10:27:28 |
| 15415 | 7312 | 3 | 2019-04-02 10:27:52 |
| 15416 | 7305 | 3 | 2019-04-02 10:28:14 |
| 15417 | 7314 | 3 | 2019-04-02 10:28:24 |
| 15418 | 7320 | 1 | 2019-04-02 10:44:17 |
| 15419 | 7321 | 1 | 2019-04-02 10:52:18 |
| 15420 | 7298 | 1 | 2019-04-02 10:55:58 |
| 15421 | 7325 | 1 | 2019-04-02 10:57:53 |
| 15422 | 7309 | 1 | 2019-04-02 11:00:12 |
| 15423 | 7312 | 1 | 2019-04-02 11:00:24 |
| 15424 | 7308 | 1 | 2019-04-02 11:03:12 |
| 15425 | 7301 | 1 | 2019-04-02 11:04:54 |
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;