Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 16,501–16,525 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 16501 | 8346 | 1 | 2019-06-18 12:37:00 |
| 16502 | 8342 | 1 | 2019-06-18 12:37:51 |
| 16503 | 8397 | 1 | 2019-06-18 12:39:31 |
| 16504 | 8345 | 2 | 2019-06-18 12:40:32 |
| 16505 | 8363 | 1 | 2019-06-18 12:51:32 |
| 16506 | 8364 | 2 | 2019-06-18 13:02:20 |
| 16507 | 8346 | 3 | 2019-06-18 13:22:24 |
| 16508 | 8362 | 1 | 2019-06-18 13:23:48 |
| 16509 | 8343 | 3 | 2019-06-18 13:27:15 |
| 16510 | 8342 | 3 | 2019-06-18 13:30:49 |
| 16511 | 8385 | 1 | 2019-06-18 13:31:55 |
| 16512 | 8386 | 1 | 2019-06-18 13:42:30 |
| 16513 | 8344 | 1 | 2019-06-18 13:43:40 |
| 16514 | 8397 | 3 | 2019-06-18 13:46:58 |
| 16515 | 8342 | 1 | 2019-06-18 14:05:00 |
| 16516 | 8346 | 1 | 2019-06-18 14:13:21 |
| 16517 | 8386 | 2 | 2019-06-18 14:16:59 |
| 16518 | 8342 | 2 | 2019-06-18 14:43:15 |
| 16519 | 8385 | 2 | 2019-06-18 14:43:50 |
| 16520 | 8344 | 2 | 2019-06-18 14:52:00 |
| 16521 | 8343 | 1 | 2019-06-18 14:55:35 |
| 16522 | 8385 | 1 | 2019-06-18 15:17:50 |
| 16523 | 8343 | 2 | 2019-06-18 15:33:01 |
| 16524 | 8346 | 2 | 2019-06-18 15:42:52 |
| 16525 | 8386 | 1 | 2019-06-18 15:51:05 |
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;