Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 15,576–15,600 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 15576 | 8062 | 1 | 2019-04-14 15:15:10 |
| 15577 | 8070 | 3 | 2019-04-14 15:54:30 |
| 15578 | 8069 | 3 | 2019-04-14 15:54:38 |
| 15579 | 8067 | 3 | 2019-04-14 16:03:17 |
| 15580 | 8068 | 1 | 2019-04-14 16:04:27 |
| 15581 | 8068 | 3 | 2019-04-14 17:23:33 |
| 15582 | 8043 | 2 | 2019-04-15 09:20:57 |
| 15583 | 8044 | 2 | 2019-04-15 09:32:11 |
| 15584 | 8043 | 3 | 2019-04-15 09:59:35 |
| 15585 | 8077 | 2 | 2019-04-15 10:16:45 |
| 15586 | 8044 | 3 | 2019-04-15 10:56:09 |
| 15587 | 8077 | 3 | 2019-04-15 11:03:33 |
| 15588 | 8055 | 3 | 2019-04-15 11:05:35 |
| 15589 | 8054 | 3 | 2019-04-15 11:10:28 |
| 15590 | 8051 | 3 | 2019-04-15 11:11:12 |
| 15591 | 8052 | 3 | 2019-04-15 11:15:47 |
| 15592 | 8053 | 3 | 2019-04-15 11:17:28 |
| 15593 | 7827 | 1 | 2019-04-15 12:15:06 |
| 15594 | 7849 | 1 | 2019-04-15 12:15:49 |
| 15595 | 7841 | 1 | 2019-04-15 12:16:44 |
| 15596 | 7860 | 1 | 2019-04-15 12:17:41 |
| 15597 | 7858 | 1 | 2019-04-15 12:18:24 |
| 15598 | 7826 | 1 | 2019-04-15 12:18:31 |
| 15599 | 7844 | 1 | 2019-04-15 12:18:34 |
| 15600 | 7853 | 1 | 2019-04-15 12:18:34 |
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;