Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 18,226–18,250 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 18226 | 9207 | 1 | 2019-11-09 12:48:01 |
| 18227 | 9198 | 1 | 2019-11-09 12:48:28 |
| 18228 | 9226 | 1 | 2019-11-09 12:51:29 |
| 18229 | 9216 | 1 | 2019-11-09 12:52:02 |
| 18230 | 9210 | 1 | 2019-11-09 12:53:01 |
| 18231 | 9188 | 1 | 2019-11-09 12:53:11 |
| 18232 | 9195 | 1 | 2019-11-09 12:53:22 |
| 18233 | 9219 | 1 | 2019-11-09 12:56:13 |
| 18234 | 9194 | 1 | 2019-11-09 12:56:28 |
| 18235 | 9211 | 1 | 2019-11-09 12:56:59 |
| 18236 | 9223 | 1 | 2019-11-09 12:59:28 |
| 18237 | 9184 | 1 | 2019-11-09 13:03:57 |
| 18238 | 9201 | 1 | 2019-11-09 13:05:29 |
| 18239 | 9199 | 1 | 2019-11-09 13:05:52 |
| 18240 | 9196 | 1 | 2019-11-09 13:06:36 |
| 18241 | 9205 | 1 | 2019-11-09 13:07:46 |
| 18242 | 9213 | 1 | 2019-11-09 13:09:58 |
| 18243 | 9193 | 1 | 2019-11-09 13:11:12 |
| 18244 | 9217 | 1 | 2019-11-09 13:15:17 |
| 18245 | 9218 | 1 | 2019-11-09 13:17:21 |
| 18246 | 9204 | 1 | 2019-11-09 13:18:32 |
| 18247 | 9203 | 1 | 2019-11-09 13:18:40 |
| 18248 | 9209 | 1 | 2019-11-09 13:18:43 |
| 18249 | 9192 | 1 | 2019-11-09 13:23:40 |
| 18250 | 9222 | 1 | 2019-11-09 13:24: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;