Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 14,001–14,025 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 14001 | 6961 | 2 | 2018-12-04 14:15:16 |
| 14002 | 6970 | 2 | 2018-12-04 14:15:55 |
| 14003 | 6953 | 2 | 2018-12-04 14:16:11 |
| 14004 | 6951 | 2 | 2018-12-04 14:16:20 |
| 14005 | 6958 | 2 | 2018-12-04 14:16:42 |
| 14006 | 6949 | 2 | 2018-12-04 14:16:54 |
| 14007 | 6999 | 2 | 2018-12-04 14:17:17 |
| 14008 | 6979 | 2 | 2018-12-04 14:17:18 |
| 14009 | 6967 | 2 | 2018-12-04 14:17:26 |
| 14010 | 6981 | 2 | 2018-12-04 14:17:33 |
| 14011 | 6963 | 2 | 2018-12-04 14:18:24 |
| 14012 | 6983 | 2 | 2018-12-04 14:18:29 |
| 14013 | 6989 | 2 | 2018-12-04 14:18:34 |
| 14014 | 6987 | 2 | 2018-12-04 14:18:46 |
| 14015 | 6977 | 2 | 2018-12-04 14:19:32 |
| 14016 | 7000 | 2 | 2018-12-04 14:19:44 |
| 14017 | 6992 | 2 | 2018-12-04 14:19:48 |
| 14018 | 6974 | 2 | 2018-12-04 14:20:22 |
| 14019 | 6952 | 2 | 2018-12-04 14:20:51 |
| 14020 | 6995 | 2 | 2018-12-04 14:21:39 |
| 14021 | 6975 | 2 | 2018-12-04 14:22:15 |
| 14022 | 6968 | 2 | 2018-12-04 14:22:32 |
| 14023 | 6997 | 2 | 2018-12-04 14:22:42 |
| 14024 | 6986 | 2 | 2018-12-04 14:23:49 |
| 14025 | 6973 | 2 | 2018-12-04 14:24:02 |
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;