Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 14,176–14,200 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 14176 | 6810 | 3 | 2018-12-09 14:05:01 |
| 14177 | 6791 | 3 | 2018-12-09 14:05:11 |
| 14178 | 6793 | 3 | 2018-12-09 14:06:53 |
| 14179 | 6815 | 3 | 2018-12-09 14:07:22 |
| 14180 | 6827 | 3 | 2018-12-09 14:08:38 |
| 14181 | 6820 | 3 | 2018-12-09 14:11:53 |
| 14182 | 6807 | 3 | 2018-12-09 14:12:15 |
| 14183 | 6809 | 3 | 2018-12-09 14:12:59 |
| 14184 | 6824 | 3 | 2018-12-09 14:13:01 |
| 14185 | 6819 | 3 | 2018-12-09 14:13:30 |
| 14186 | 6826 | 3 | 2018-12-09 14:13:38 |
| 14187 | 6821 | 3 | 2018-12-09 14:17:02 |
| 14188 | 6814 | 3 | 2018-12-09 14:18:23 |
| 14189 | 6813 | 3 | 2018-12-09 14:19:42 |
| 14190 | 6816 | 3 | 2018-12-09 14:24:06 |
| 14191 | 6823 | 3 | 2018-12-09 14:24:43 |
| 14192 | 6818 | 3 | 2018-12-09 14:27:27 |
| 14193 | 7224 | 1 | 2018-12-11 09:31:20 |
| 14194 | 7252 | 2 | 2018-12-11 09:48:42 |
| 14195 | 7252 | 3 | 2018-12-11 10:38:22 |
| 14196 | 7224 | 3 | 2018-12-11 10:43:28 |
| 14197 | 7224 | 2 | 2018-12-11 11:37:01 |
| 14198 | 7211 | 2 | 2018-12-11 13:51:03 |
| 14199 | 7210 | 2 | 2018-12-11 14:00:09 |
| 14200 | 7211 | 1 | 2018-12-11 14:24:39 |
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;