Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 7,476–7,500 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 7476 | 3876 | 1 | 2017-05-05 12:27:36 |
| 7477 | 3873 | 3 | 2017-05-05 12:28:54 |
| 7478 | 3886 | 3 | 2017-05-05 12:32:19 |
| 7479 | 3884 | 3 | 2017-05-06 09:38:17 |
| 7480 | 3883 | 3 | 2017-05-06 09:44:40 |
| 7481 | 3881 | 3 | 2017-05-06 09:46:26 |
| 7482 | 3882 | 3 | 2017-05-06 09:49:04 |
| 7483 | 3880 | 1 | 2017-05-06 09:50:24 |
| 7484 | 3851 | 2 | 2017-05-06 10:09:36 |
| 7485 | 3884 | 2 | 2017-05-06 10:14:59 |
| 7486 | 3883 | 2 | 2017-05-06 10:31:26 |
| 7487 | 3884 | 3 | 2017-05-06 10:45:18 |
| 7488 | 3881 | 2 | 2017-05-06 10:47:01 |
| 7489 | 3882 | 2 | 2017-05-06 11:01:16 |
| 7490 | 3883 | 3 | 2017-05-06 11:01:51 |
| 7491 | 3851 | 3 | 2017-05-06 11:30:42 |
| 7492 | 3881 | 3 | 2017-05-06 12:04:11 |
| 7493 | 3851 | 2 | 2017-05-06 12:12:23 |
| 7494 | 3882 | 3 | 2017-05-06 12:22:33 |
| 7495 | 3851 | 1 | 2017-05-06 13:47:07 |
| 7496 | 3872 | 2 | 2017-05-06 15:17:02 |
| 7497 | 3891 | 2 | 2017-05-06 15:24:25 |
| 7498 | 3891 | 3 | 2017-05-06 16:52:16 |
| 7499 | 3858 | 2 | 2017-05-07 12:07:09 |
| 7500 | 3859 | 2 | 2017-05-07 12:13:47 |
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;