Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 13,476–13,500 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 13476 | 6838 | 3 | 2018-10-21 13:02:05 |
| 13477 | 6836 | 3 | 2018-10-21 14:27:27 |
| 13478 | 6836 | 2 | 2018-10-21 14:55:53 |
| 13479 | 6900 | 3 | 2018-10-21 15:20:59 |
| 13480 | 6900 | 2 | 2018-10-21 16:00:04 |
| 13481 | 6900 | 3 | 2018-10-21 17:09:03 |
| 13482 | 6899 | 1 | 2018-10-22 16:08:14 |
| 13483 | 6894 | 2 | 2018-10-23 12:32:53 |
| 13484 | 6895 | 2 | 2018-10-23 12:44:11 |
| 13485 | 6894 | 3 | 2018-10-23 13:07:24 |
| 13486 | 6895 | 3 | 2018-10-23 13:49:02 |
| 13487 | 6894 | 1 | 2018-10-23 14:17:28 |
| 13488 | 6895 | 1 | 2018-10-23 14:18:43 |
| 13489 | 6122 | 2 | 2018-10-25 10:10:11 |
| 13490 | 6124 | 2 | 2018-10-25 10:11:04 |
| 13491 | 6152 | 2 | 2018-10-25 10:12:06 |
| 13492 | 6130 | 2 | 2018-10-25 10:12:13 |
| 13493 | 6140 | 2 | 2018-10-25 10:12:50 |
| 13494 | 6133 | 2 | 2018-10-25 10:14:29 |
| 13495 | 6125 | 2 | 2018-10-25 10:15:23 |
| 13496 | 6143 | 2 | 2018-10-25 10:15:52 |
| 13497 | 6139 | 2 | 2018-10-25 10:16:08 |
| 13498 | 6149 | 2 | 2018-10-25 10:17:23 |
| 13499 | 6148 | 2 | 2018-10-25 10:17:25 |
| 13500 | 6127 | 2 | 2018-10-25 10:17:32 |
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;