Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 16,076–16,100 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 16076 | 8244 | 1 | 2019-05-21 12:20:05 |
| 16077 | 8159 | 1 | 2019-05-21 12:21:54 |
| 16078 | 8229 | 1 | 2019-05-21 12:27:24 |
| 16079 | 8160 | 2 | 2019-05-21 12:34:57 |
| 16080 | 8244 | 2 | 2019-05-21 13:06:16 |
| 16081 | 8160 | 3 | 2019-05-21 14:05:33 |
| 16082 | 8160 | 1 | 2019-05-21 15:32:14 |
| 16083 | 8222 | 3 | 2019-05-21 16:23:20 |
| 16084 | 8221 | 3 | 2019-05-21 16:29:35 |
| 16085 | 8221 | 1 | 2019-05-21 17:33:06 |
| 16086 | 8264 | 1 | 2019-05-22 09:36:34 |
| 16087 | 8265 | 2 | 2019-05-22 09:38:50 |
| 16088 | 8263 | 1 | 2019-05-22 09:46:26 |
| 16089 | 8265 | 3 | 2019-05-22 10:13:52 |
| 16090 | 8264 | 3 | 2019-05-22 10:19:30 |
| 16091 | 8263 | 3 | 2019-05-22 10:50:53 |
| 16092 | 8270 | 2 | 2019-05-24 12:51:07 |
| 16093 | 8269 | 3 | 2019-05-24 12:55:35 |
| 16094 | 8268 | 3 | 2019-05-24 12:59:01 |
| 16095 | 8267 | 2 | 2019-05-24 13:00:43 |
| 16096 | 8046 | 2 | 2019-05-24 13:24:16 |
| 16097 | 8268 | 2 | 2019-05-24 13:27:02 |
| 16098 | 8047 | 2 | 2019-05-24 13:35:23 |
| 16099 | 8267 | 3 | 2019-05-24 13:50:24 |
| 16100 | 8270 | 1 | 2019-05-24 14:01: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;