Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 10,851–10,875 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 10851 | 5647 | 3 | 2018-04-25 16:19:54 |
| 10852 | 5651 | 1 | 2018-04-25 16:33:41 |
| 10853 | 5645 | 2 | 2018-04-25 16:37:03 |
| 10854 | 5646 | 2 | 2018-04-25 17:22:10 |
| 10855 | 5653 | 1 | 2018-04-26 09:54:56 |
| 10856 | 5654 | 2 | 2018-04-26 09:54:57 |
| 10857 | 5653 | 3 | 2018-04-26 10:36:14 |
| 10858 | 5654 | 3 | 2018-04-26 10:40:37 |
| 10859 | 5654 | 1 | 2018-04-26 11:19:15 |
| 10860 | 5499 | 1 | 2018-04-26 14:12:25 |
| 10861 | 5499 | 2 | 2018-04-26 14:40:18 |
| 10862 | 5641 | 2 | 2018-04-26 15:17:01 |
| 10863 | 5640 | 2 | 2018-04-26 15:17:09 |
| 10864 | 5499 | 3 | 2018-04-26 15:51:41 |
| 10865 | 5641 | 1 | 2018-04-26 16:11:05 |
| 10866 | 5499 | 2 | 2018-04-26 16:26:55 |
| 10867 | 5640 | 3 | 2018-04-26 16:33:19 |
| 10868 | 5641 | 2 | 2018-04-26 17:38:19 |
| 10869 | 5661 | 3 | 2018-04-27 10:54:14 |
| 10870 | 5662 | 3 | 2018-04-27 10:54:22 |
| 10871 | 5586 | 2 | 2018-04-27 11:09:39 |
| 10872 | 5585 | 2 | 2018-04-27 11:09:53 |
| 10873 | 5662 | 2 | 2018-04-27 11:23:53 |
| 10874 | 5585 | 1 | 2018-04-27 12:08:57 |
| 10875 | 5586 | 1 | 2018-04-27 12:22:18 |
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;