Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 18,501–18,525 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 18501 | 9491 | 1 | 2019-12-01 17:10:40 |
| 18502 | 9494 | 2 | 2019-12-02 16:49:14 |
| 18503 | 9494 | 3 | 2019-12-02 17:41:49 |
| 18504 | 9496 | 1 | 2019-12-03 09:19:22 |
| 18505 | 9495 | 2 | 2019-12-03 09:21:23 |
| 18506 | 9496 | 3 | 2019-12-03 10:43:21 |
| 18507 | 9495 | 1 | 2019-12-03 10:46:25 |
| 18508 | 9501 | 2 | 2019-12-04 10:47:22 |
| 18509 | 9501 | 1 | 2019-12-04 12:16:40 |
| 18510 | 9501 | 2 | 2019-12-04 13:45:30 |
| 18511 | 9501 | 1 | 2019-12-04 15:18:29 |
| 18512 | 9497 | 3 | 2019-12-05 09:47:13 |
| 18513 | 9499 | 3 | 2019-12-05 09:49:17 |
| 18514 | 9498 | 3 | 2019-12-05 09:56:16 |
| 18515 | 9500 | 3 | 2019-12-05 10:02:20 |
| 18516 | 9499 | 2 | 2019-12-05 10:28:21 |
| 18517 | 9500 | 2 | 2019-12-05 10:28:59 |
| 18518 | 9498 | 2 | 2019-12-05 10:40:10 |
| 18519 | 9497 | 2 | 2019-12-05 11:10:50 |
| 18520 | 9500 | 3 | 2019-12-05 11:42:50 |
| 18521 | 9499 | 3 | 2019-12-05 11:49:47 |
| 18522 | 9498 | 3 | 2019-12-05 11:57:32 |
| 18523 | 9497 | 3 | 2019-12-05 12:09:21 |
| 18524 | 9510 | 3 | 2019-12-05 15:32:26 |
| 18525 | 9511 | 3 | 2019-12-05 15:41:20 |
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;