Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 17,326–17,350 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 17326 | 8690 | 2 | 2019-08-16 14:25:24 |
| 17327 | 8700 | 2 | 2019-08-16 14:29:49 |
| 17328 | 8687 | 2 | 2019-08-16 14:33:38 |
| 17329 | 8698 | 2 | 2019-08-16 15:04:11 |
| 17330 | 8690 | 3 | 2019-08-16 15:29:49 |
| 17331 | 8689 | 3 | 2019-08-16 15:30:33 |
| 17332 | 8688 | 3 | 2019-08-16 15:42:11 |
| 17333 | 8687 | 3 | 2019-08-16 15:55:13 |
| 17334 | 8688 | 2 | 2019-08-16 16:39:15 |
| 17335 | 8689 | 2 | 2019-08-16 16:51:19 |
| 17336 | 8690 | 2 | 2019-08-16 16:57:42 |
| 17337 | 8687 | 2 | 2019-08-16 17:13:57 |
| 17338 | 8732 | 2 | 2019-08-17 09:47:30 |
| 17339 | 8731 | 2 | 2019-08-17 10:01:53 |
| 17340 | 8732 | 3 | 2019-08-17 11:00:20 |
| 17341 | 8731 | 3 | 2019-08-17 11:25:29 |
| 17342 | 8732 | 2 | 2019-08-17 12:32:49 |
| 17343 | 8731 | 2 | 2019-08-17 12:54:08 |
| 17344 | 8732 | 3 | 2019-08-17 13:42:45 |
| 17345 | 8731 | 3 | 2019-08-17 14:07:20 |
| 17346 | 8772 | 2 | 2019-08-18 10:43:55 |
| 17347 | 8771 | 1 | 2019-08-18 10:53:00 |
| 17348 | 8770 | 1 | 2019-08-18 10:55:47 |
| 17349 | 8773 | 1 | 2019-08-18 10:57:42 |
| 17350 | 8772 | 3 | 2019-08-18 11:12:58 |
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;