Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 11,551–11,575 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 11551 | 6066 | 2 | 2018-06-21 09:35:25 |
| 11552 | 6067 | 3 | 2018-06-21 10:26:27 |
| 11553 | 6067 | 2 | 2018-06-21 10:58:48 |
| 11554 | 6066 | 3 | 2018-06-21 11:10:28 |
| 11555 | 6071 | 2 | 2018-06-21 12:04:09 |
| 11556 | 6066 | 2 | 2018-06-21 12:39:03 |
| 11557 | 6071 | 3 | 2018-06-21 13:20:09 |
| 11558 | 6072 | 2 | 2018-06-22 14:35:52 |
| 11559 | 6054 | 3 | 2018-06-22 14:49:15 |
| 11560 | 6055 | 3 | 2018-06-22 14:52:03 |
| 11561 | 6054 | 2 | 2018-06-22 15:49:10 |
| 11562 | 6072 | 3 | 2018-06-22 15:55:11 |
| 11563 | 6055 | 2 | 2018-06-22 16:06:26 |
| 11564 | 6070 | 1 | 2018-06-23 09:27:04 |
| 11565 | 6019 | 2 | 2018-06-23 14:10:21 |
| 11566 | 6018 | 2 | 2018-06-23 14:12:51 |
| 11567 | 6020 | 2 | 2018-06-23 14:21:26 |
| 11568 | 6018 | 1 | 2018-06-23 14:39:55 |
| 11569 | 6020 | 1 | 2018-06-23 14:50:54 |
| 11570 | 6018 | 2 | 2018-06-23 15:35:38 |
| 11571 | 6019 | 1 | 2018-06-23 15:39:13 |
| 11572 | 6020 | 2 | 2018-06-23 15:41:11 |
| 11573 | 6019 | 2 | 2018-06-23 16:20:48 |
| 11574 | 5890 | 2 | 2018-06-24 09:52:09 |
| 11575 | 5888 | 2 | 2018-06-24 09:54:40 |
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;