Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 18,951–18,975 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 18951 | 9557 | 3 | 2019-12-21 11:49:38 |
| 18952 | 9579 | 3 | 2019-12-21 12:15:37 |
| 18953 | 9556 | 2 | 2019-12-21 12:33:41 |
| 18954 | 9557 | 2 | 2019-12-21 12:44:54 |
| 18955 | 9559 | 2 | 2019-12-21 15:47:56 |
| 18956 | 9489 | 2 | 2019-12-22 11:10:57 |
| 18957 | 9488 | 2 | 2019-12-22 11:11:07 |
| 18958 | 9490 | 2 | 2019-12-22 11:20:33 |
| 18959 | 9489 | 1 | 2019-12-22 11:48:38 |
| 18960 | 9582 | 2 | 2019-12-23 13:07:18 |
| 18961 | 9582 | 1 | 2019-12-23 14:21:30 |
| 18962 | 9580 | 2 | 2019-12-24 09:33:55 |
| 18963 | 9594 | 3 | 2019-12-24 10:59:12 |
| 18964 | 9593 | 2 | 2019-12-24 10:59:25 |
| 18965 | 9593 | 1 | 2019-12-24 11:45:03 |
| 18966 | 9596 | 1 | 2019-12-24 13:56:49 |
| 18967 | 9595 | 1 | 2019-12-24 14:03:37 |
| 18968 | 9597 | 1 | 2019-12-24 14:06:38 |
| 18969 | 9595 | 2 | 2019-12-24 14:29:29 |
| 18970 | 9598 | 1 | 2019-12-24 14:43:46 |
| 18971 | 9597 | 2 | 2019-12-24 15:00:19 |
| 18972 | 9598 | 2 | 2019-12-24 15:20:29 |
| 18973 | 9596 | 2 | 2019-12-24 15:23:05 |
| 18974 | 9577 | 2 | 2019-12-24 15:23:50 |
| 18975 | 9576 | 2 | 2019-12-24 15:34:55 |
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;