Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 19,026–19,050 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 19026 | 9377 | 2 | 2019-12-27 15:01:42 |
| 19027 | 9377 | 3 | 2019-12-27 15:49:55 |
| 19028 | 9377 | 1 | 2019-12-27 16:32:46 |
| 19029 | 9564 | 2 | 2019-12-28 11:27:06 |
| 19030 | 9558 | 1 | 2019-12-28 12:05:34 |
| 19031 | 9617 | 2 | 2019-12-28 12:19:57 |
| 19032 | 9572 | 3 | 2019-12-28 12:46:56 |
| 19033 | 9564 | 1 | 2019-12-28 12:48:36 |
| 19034 | 9617 | 1 | 2019-12-28 12:51:38 |
| 19035 | 9573 | 3 | 2019-12-28 12:53:05 |
| 19036 | 9558 | 3 | 2019-12-28 13:03:13 |
| 19037 | 9572 | 2 | 2019-12-28 13:52:53 |
| 19038 | 9558 | 1 | 2019-12-28 14:03:56 |
| 19039 | 9573 | 2 | 2019-12-28 14:18:51 |
| 19040 | 9572 | 1 | 2019-12-28 14:40:54 |
| 19041 | 9573 | 1 | 2019-12-28 15:02:18 |
| 19042 | 9572 | 2 | 2019-12-28 15:15:51 |
| 19043 | 9573 | 2 | 2019-12-28 15:40:56 |
| 19044 | 9572 | 1 | 2019-12-28 16:26:38 |
| 19045 | 9567 | 2 | 2019-12-28 16:39:10 |
| 19046 | 9571 | 2 | 2019-12-28 16:39:50 |
| 19047 | 9573 | 1 | 2019-12-28 17:05:03 |
| 19048 | 9567 | 1 | 2019-12-28 17:12:34 |
| 19049 | 9620 | 2 | 2019-12-29 10:03:03 |
| 19050 | 9621 | 2 | 2019-12-29 11:15:57 |
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;