Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 14,151–14,175 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 14151 | 6827 | 2 | 2018-12-09 13:00:47 |
| 14152 | 6806 | 2 | 2018-12-09 13:01:18 |
| 14153 | 6808 | 2 | 2018-12-09 13:01:33 |
| 14154 | 6809 | 2 | 2018-12-09 13:02:31 |
| 14155 | 6790 | 2 | 2018-12-09 13:02:38 |
| 14156 | 6811 | 2 | 2018-12-09 13:02:39 |
| 14157 | 6819 | 2 | 2018-12-09 13:05:05 |
| 14158 | 6821 | 2 | 2018-12-09 13:07:17 |
| 14159 | 6798 | 3 | 2018-12-09 13:19:14 |
| 14160 | 6795 | 3 | 2018-12-09 13:34:05 |
| 14161 | 6811 | 3 | 2018-12-09 13:38:53 |
| 14162 | 6794 | 3 | 2018-12-09 13:39:05 |
| 14163 | 6812 | 3 | 2018-12-09 13:40:51 |
| 14164 | 6808 | 3 | 2018-12-09 13:41:45 |
| 14165 | 6804 | 3 | 2018-12-09 13:42:16 |
| 14166 | 6790 | 3 | 2018-12-09 13:44:36 |
| 14167 | 6801 | 3 | 2018-12-09 13:46:51 |
| 14168 | 6825 | 3 | 2018-12-09 13:47:40 |
| 14169 | 6797 | 3 | 2018-12-09 13:48:13 |
| 14170 | 6828 | 3 | 2018-12-09 13:48:29 |
| 14171 | 6800 | 3 | 2018-12-09 13:49:28 |
| 14172 | 6806 | 3 | 2018-12-09 13:53:40 |
| 14173 | 6817 | 3 | 2018-12-09 13:57:28 |
| 14174 | 6802 | 3 | 2018-12-09 13:57:44 |
| 14175 | 6803 | 3 | 2018-12-09 14:01:34 |
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;