Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 13,801–13,825 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 13801 | 7044 | 3 | 2018-11-16 17:10:11 |
| 13802 | 7043 | 3 | 2018-11-16 17:18:51 |
| 13803 | 7046 | 1 | 2018-11-16 17:41:52 |
| 13804 | 7072 | 1 | 2018-11-17 11:13:22 |
| 13805 | 7067 | 3 | 2018-11-18 09:43:07 |
| 13806 | 7067 | 2 | 2018-11-18 10:12:58 |
| 13807 | 7067 | 3 | 2018-11-18 10:46:15 |
| 13808 | 7049 | 2 | 2018-11-18 11:11:40 |
| 13809 | 7051 | 3 | 2018-11-18 11:20:39 |
| 13810 | 7050 | 3 | 2018-11-18 11:26:37 |
| 13811 | 7048 | 3 | 2018-11-18 11:27:31 |
| 13812 | 7049 | 1 | 2018-11-18 11:47:17 |
| 13813 | 7074 | 2 | 2018-11-19 10:23:50 |
| 13814 | 7073 | 1 | 2018-11-19 10:26:12 |
| 13815 | 7075 | 2 | 2018-11-19 10:26:32 |
| 13816 | 7073 | 3 | 2018-11-19 11:41:55 |
| 13817 | 6904 | 3 | 2018-11-19 12:33:27 |
| 13818 | 6902 | 3 | 2018-11-19 12:35:01 |
| 13819 | 6905 | 3 | 2018-11-19 12:36:14 |
| 13820 | 6903 | 1 | 2018-11-19 12:39:39 |
| 13821 | 6904 | 1 | 2018-11-19 13:07:57 |
| 13822 | 6902 | 1 | 2018-11-19 13:24:36 |
| 13823 | 7071 | 2 | 2018-11-19 14:01:56 |
| 13824 | 6905 | 1 | 2018-11-19 14:08:04 |
| 13825 | 6904 | 2 | 2018-11-19 14:14:59 |
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;