Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 19,301–19,325 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 19301 | 9721 | 3 | 2020-01-23 16:20:21 |
| 19302 | 9721 | 1 | 2020-01-23 17:02:15 |
| 19303 | 9732 | 2 | 2020-01-25 09:10:06 |
| 19304 | 9733 | 3 | 2020-01-25 09:17:02 |
| 19305 | 9733 | 1 | 2020-01-25 09:57:07 |
| 19306 | 9732 | 3 | 2020-01-25 10:44:06 |
| 19307 | 9732 | 1 | 2020-01-25 11:40:38 |
| 19308 | 9732 | 3 | 2020-01-25 12:27:47 |
| 19309 | 9728 | 2 | 2020-01-25 14:28:55 |
| 19310 | 9730 | 2 | 2020-01-25 14:29:43 |
| 19311 | 9726 | 2 | 2020-01-25 14:40:15 |
| 19312 | 9729 | 2 | 2020-01-25 14:43:49 |
| 19313 | 9727 | 1 | 2020-01-25 14:44:43 |
| 19314 | 9728 | 1 | 2020-01-25 15:05:48 |
| 19315 | 9729 | 3 | 2020-01-25 15:10:57 |
| 19316 | 9730 | 1 | 2020-01-25 15:11:03 |
| 19317 | 9729 | 1 | 2020-01-25 15:52:41 |
| 19318 | 9726 | 1 | 2020-01-25 16:02:49 |
| 19319 | 9736 | 2 | 2020-01-26 12:32:21 |
| 19320 | 9740 | 3 | 2020-01-27 09:16:34 |
| 19321 | 9740 | 1 | 2020-01-27 10:14:49 |
| 19322 | 9740 | 3 | 2020-01-27 10:40:14 |
| 19323 | 9745 | 3 | 2020-01-29 11:16:49 |
| 19324 | 9724 | 1 | 2020-01-29 11:17:36 |
| 19325 | 9725 | 1 | 2020-01-29 11:29:10 |
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;