Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 12,226–12,250 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 12226 | 6397 | 1 | 2018-08-05 13:44:25 |
| 12227 | 6398 | 2 | 2018-08-05 14:12:19 |
| 12228 | 6400 | 1 | 2018-08-05 14:44:24 |
| 12229 | 6399 | 3 | 2018-08-05 14:49:59 |
| 12230 | 6397 | 3 | 2018-08-05 14:55:29 |
| 12231 | 6398 | 1 | 2018-08-05 15:12:40 |
| 12232 | 6397 | 1 | 2018-08-05 15:22:14 |
| 12233 | 6400 | 3 | 2018-08-05 15:49:46 |
| 12234 | 6400 | 1 | 2018-08-05 17:25:22 |
| 12235 | 6402 | 2 | 2018-08-06 10:10:20 |
| 12236 | 6402 | 1 | 2018-08-06 11:10:32 |
| 12237 | 6403 | 2 | 2018-08-06 11:43:57 |
| 12238 | 6404 | 2 | 2018-08-06 11:47:00 |
| 12239 | 6352 | 2 | 2018-08-06 12:06:54 |
| 12240 | 6350 | 2 | 2018-08-06 12:09:45 |
| 12241 | 6353 | 2 | 2018-08-06 12:10:42 |
| 12242 | 6351 | 3 | 2018-08-06 12:11:29 |
| 12243 | 6403 | 1 | 2018-08-06 12:14:38 |
| 12244 | 6404 | 1 | 2018-08-06 12:24:43 |
| 12245 | 6353 | 1 | 2018-08-06 12:42:52 |
| 12246 | 6403 | 2 | 2018-08-06 12:42:57 |
| 12247 | 6404 | 2 | 2018-08-06 12:53:36 |
| 12248 | 6405 | 2 | 2018-08-06 13:10:58 |
| 12249 | 6406 | 2 | 2018-08-06 13:12:10 |
| 12250 | 6352 | 1 | 2018-08-06 13:28:56 |
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;