Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 16,726–16,750 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 16726 | 8544 | 1 | 2019-07-12 13:40:27 |
| 16727 | 8542 | 1 | 2019-07-12 13:41:19 |
| 16728 | 8543 | 1 | 2019-07-12 13:43:09 |
| 16729 | 8544 | 3 | 2019-07-12 14:07:55 |
| 16730 | 8545 | 3 | 2019-07-12 14:11:08 |
| 16731 | 8543 | 3 | 2019-07-12 14:17:49 |
| 16732 | 8542 | 3 | 2019-07-12 14:20:58 |
| 16733 | 8544 | 1 | 2019-07-12 14:49:58 |
| 16734 | 8543 | 1 | 2019-07-12 15:01:11 |
| 16735 | 8545 | 1 | 2019-07-12 15:18:56 |
| 16736 | 8542 | 1 | 2019-07-12 15:21:10 |
| 16737 | 8532 | 3 | 2019-07-13 09:49:26 |
| 16738 | 8533 | 3 | 2019-07-13 09:58:06 |
| 16739 | 8434 | 2 | 2019-07-13 10:18:34 |
| 16740 | 8533 | 1 | 2019-07-13 10:39:14 |
| 16741 | 8532 | 1 | 2019-07-13 10:43:40 |
| 16742 | 8511 | 1 | 2019-07-13 12:16:07 |
| 16743 | 8510 | 1 | 2019-07-13 12:17:32 |
| 16744 | 8510 | 2 | 2019-07-13 13:16:52 |
| 16745 | 8511 | 2 | 2019-07-13 13:23:02 |
| 16746 | 8429 | 1 | 2019-07-13 13:31:00 |
| 16747 | 8455 | 1 | 2019-07-13 13:37:37 |
| 16748 | 8454 | 1 | 2019-07-13 13:49:40 |
| 16749 | 8539 | 3 | 2019-07-13 14:09:22 |
| 16750 | 8540 | 3 | 2019-07-13 14:23:49 |
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;