Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 12,651–12,675 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 12651 | 5708 | 3 | 2018-08-27 11:19:28 |
| 12652 | 5733 | 3 | 2018-08-27 11:23:18 |
| 12653 | 5927 | 1 | 2018-08-27 11:23:57 |
| 12654 | 5920 | 1 | 2018-08-27 11:25:33 |
| 12655 | 5720 | 3 | 2018-08-27 11:27:28 |
| 12656 | 5922 | 1 | 2018-08-27 11:28:12 |
| 12657 | 5915 | 1 | 2018-08-27 11:28:43 |
| 12658 | 5899 | 1 | 2018-08-27 11:29:01 |
| 12659 | 5714 | 3 | 2018-08-27 11:29:23 |
| 12660 | 5737 | 3 | 2018-08-27 11:29:24 |
| 12661 | 5919 | 1 | 2018-08-27 11:29:31 |
| 12662 | 5736 | 3 | 2018-08-27 11:29:57 |
| 12663 | 6566 | 3 | 2018-08-27 11:32:09 |
| 12664 | 5932 | 1 | 2018-08-27 11:32:26 |
| 12665 | 5711 | 3 | 2018-08-27 11:32:55 |
| 12666 | 5925 | 1 | 2018-08-27 11:33:01 |
| 12667 | 5912 | 1 | 2018-08-27 11:34:18 |
| 12668 | 5730 | 3 | 2018-08-27 11:35:57 |
| 12669 | 5921 | 2 | 2018-08-27 11:37:34 |
| 12670 | 5719 | 3 | 2018-08-27 11:38:23 |
| 12671 | 5917 | 1 | 2018-08-27 11:38:56 |
| 12672 | 5929 | 1 | 2018-08-27 11:39:10 |
| 12673 | 5902 | 1 | 2018-08-27 11:40:41 |
| 12674 | 5896 | 2 | 2018-08-27 11:40:42 |
| 12675 | 5707 | 3 | 2018-08-27 11:41:43 |
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;