Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 15,301–15,325 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 15301 | 7880 | 2 | 2019-03-21 13:05:34 |
| 15302 | 7879 | 2 | 2019-03-21 13:09:37 |
| 15303 | 7879 | 3 | 2019-03-21 13:44:30 |
| 15304 | 7880 | 3 | 2019-03-21 13:44:37 |
| 15305 | 7881 | 1 | 2019-03-21 14:14:05 |
| 15306 | 7880 | 1 | 2019-03-21 14:27:41 |
| 15307 | 7878 | 3 | 2019-03-21 14:32:39 |
| 15308 | 7888 | 2 | 2019-03-21 14:34:57 |
| 15309 | 7889 | 2 | 2019-03-21 14:37:18 |
| 15310 | 7889 | 3 | 2019-03-21 15:42:33 |
| 15311 | 7888 | 3 | 2019-03-21 16:07:50 |
| 15312 | 7802 | 1 | 2019-03-22 15:18:07 |
| 15313 | 7801 | 1 | 2019-03-22 15:27:17 |
| 15314 | 7801 | 2 | 2019-03-22 15:53:45 |
| 15315 | 7801 | 3 | 2019-03-22 17:17:18 |
| 15316 | 7890 | 2 | 2019-03-24 09:19:15 |
| 15317 | 7891 | 2 | 2019-03-24 09:39:29 |
| 15318 | 7893 | 2 | 2019-03-24 09:51:38 |
| 15319 | 7892 | 2 | 2019-03-24 09:55:23 |
| 15320 | 7890 | 1 | 2019-03-24 09:58:53 |
| 15321 | 7891 | 1 | 2019-03-24 10:31:48 |
| 15322 | 7892 | 1 | 2019-03-24 10:43:02 |
| 15323 | 7893 | 1 | 2019-03-24 10:52:58 |
| 15324 | 7814 | 2 | 2019-03-25 10:32:13 |
| 15325 | 7814 | 3 | 2019-03-25 11:59:12 |
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;