Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 18,876–18,900 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 18876 | 9260 | 1 | 2019-12-20 15:28:16 |
| 18877 | 9252 | 2 | 2019-12-20 15:28:52 |
| 18878 | 9272 | 1 | 2019-12-20 15:29:11 |
| 18879 | 9247 | 1 | 2019-12-20 15:31:59 |
| 18880 | 9279 | 1 | 2019-12-20 15:35:55 |
| 18881 | 9287 | 1 | 2019-12-20 15:38:10 |
| 18882 | 9264 | 1 | 2019-12-20 15:38:47 |
| 18883 | 9277 | 2 | 2019-12-20 15:39:33 |
| 18884 | 9278 | 1 | 2019-12-20 15:40:23 |
| 18885 | 9242 | 2 | 2019-12-20 15:40:30 |
| 18886 | 9246 | 2 | 2019-12-20 15:41:29 |
| 18887 | 9261 | 1 | 2019-12-20 15:41:40 |
| 18888 | 9250 | 1 | 2019-12-20 15:41:59 |
| 18889 | 9274 | 1 | 2019-12-20 15:42:14 |
| 18890 | 9266 | 1 | 2019-12-20 15:43:06 |
| 18891 | 9251 | 2 | 2019-12-20 15:44:21 |
| 18892 | 9256 | 1 | 2019-12-20 15:44:41 |
| 18893 | 9255 | 1 | 2019-12-20 15:45:17 |
| 18894 | 9286 | 1 | 2019-12-20 15:45:26 |
| 18895 | 9249 | 1 | 2019-12-20 15:46:27 |
| 18896 | 9265 | 1 | 2019-12-20 15:46:36 |
| 18897 | 9275 | 1 | 2019-12-20 15:47:19 |
| 18898 | 9270 | 1 | 2019-12-20 15:48:37 |
| 18899 | 9288 | 1 | 2019-12-20 15:50:23 |
| 18900 | 9253 | 2 | 2019-12-20 15:50:51 |
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;