Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 18,101–18,125 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 18101 | 8923 | 2 | 2019-11-05 10:12:22 |
| 18102 | 8925 | 2 | 2019-11-05 10:12:32 |
| 18103 | 8907 | 2 | 2019-11-05 10:13:36 |
| 18104 | 8938 | 2 | 2019-11-05 10:13:56 |
| 18105 | 8902 | 2 | 2019-11-05 10:13:59 |
| 18106 | 8946 | 2 | 2019-11-05 10:14:27 |
| 18107 | 8914 | 2 | 2019-11-05 10:15:09 |
| 18108 | 8915 | 2 | 2019-11-05 10:15:24 |
| 18109 | 8929 | 2 | 2019-11-05 10:15:47 |
| 18110 | 8919 | 2 | 2019-11-05 10:15:52 |
| 18111 | 8930 | 2 | 2019-11-05 10:17:12 |
| 18112 | 8904 | 2 | 2019-11-05 10:17:15 |
| 18113 | 8927 | 2 | 2019-11-05 10:17:28 |
| 18114 | 8947 | 2 | 2019-11-05 10:17:52 |
| 18115 | 8942 | 2 | 2019-11-05 10:17:59 |
| 18116 | 8944 | 2 | 2019-11-05 10:19:31 |
| 18117 | 8917 | 2 | 2019-11-05 10:19:40 |
| 18118 | 8918 | 2 | 2019-11-05 10:20:02 |
| 18119 | 8931 | 2 | 2019-11-05 10:20:10 |
| 18120 | 8935 | 2 | 2019-11-05 10:20:49 |
| 18121 | 8922 | 2 | 2019-11-05 10:21:14 |
| 18122 | 8913 | 2 | 2019-11-05 10:21:17 |
| 18123 | 8924 | 2 | 2019-11-05 10:22:04 |
| 18124 | 8908 | 2 | 2019-11-05 10:22:20 |
| 18125 | 8926 | 2 | 2019-11-05 10:22: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;