Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 18,751–18,775 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 18751 | 8979 | 1 | 2019-12-15 14:23:14 |
| 18752 | 8987 | 1 | 2019-12-15 14:32:06 |
| 18753 | 8959 | 1 | 2019-12-15 14:33:37 |
| 18754 | 8975 | 1 | 2019-12-15 14:35:04 |
| 18755 | 9448 | 2 | 2019-12-15 15:16:39 |
| 18756 | 9547 | 2 | 2019-12-17 10:37:26 |
| 18757 | 9548 | 2 | 2019-12-17 10:37:51 |
| 18758 | 9547 | 1 | 2019-12-17 11:36:08 |
| 18759 | 9548 | 1 | 2019-12-17 11:59:26 |
| 18760 | 9506 | 3 | 2019-12-17 13:33:55 |
| 18761 | 9507 | 3 | 2019-12-17 13:39:24 |
| 18762 | 9506 | 1 | 2019-12-17 14:13:36 |
| 18763 | 9507 | 1 | 2019-12-17 14:32:06 |
| 18764 | 9506 | 3 | 2019-12-17 14:39:00 |
| 18765 | 9507 | 3 | 2019-12-17 15:41:08 |
| 18766 | 9565 | 2 | 2019-12-18 11:22:56 |
| 18767 | 9566 | 2 | 2019-12-18 11:32:49 |
| 18768 | 9536 | 2 | 2019-12-18 11:38:53 |
| 18769 | 9351 | 2 | 2019-12-18 11:39:22 |
| 18770 | 9352 | 3 | 2019-12-18 11:39:29 |
| 18771 | 9350 | 3 | 2019-12-18 11:40:50 |
| 18772 | 9350 | 2 | 2019-12-18 12:21:20 |
| 18773 | 9352 | 2 | 2019-12-18 12:24:13 |
| 18774 | 9351 | 3 | 2019-12-18 12:50:33 |
| 18775 | 9350 | 3 | 2019-12-18 13:11: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;