Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 6,351–6,375 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 6351 | 3386 | 3 | 2017-01-07 12:13:22 |
| 6352 | 3340 | 3 | 2017-01-07 12:19:18 |
| 6353 | 3387 | 1 | 2017-01-07 13:27:16 |
| 6354 | 3388 | 2 | 2017-01-07 15:24:48 |
| 6355 | 3388 | 1 | 2017-01-07 16:38:09 |
| 6356 | 3389 | 2 | 2017-01-08 12:20:23 |
| 6357 | 3390 | 2 | 2017-01-08 12:21:51 |
| 6358 | 3338 | 2 | 2017-01-10 12:07:42 |
| 6359 | 3337 | 3 | 2017-01-10 12:08:15 |
| 6360 | 3338 | 3 | 2017-01-10 12:50:21 |
| 6361 | 3392 | 1 | 2017-01-10 16:46:37 |
| 6362 | 3391 | 3 | 2017-01-10 16:47:42 |
| 6363 | 3392 | 2 | 2017-01-10 17:17:21 |
| 6364 | 3336 | 1 | 2017-01-11 13:29:33 |
| 6365 | 3336 | 3 | 2017-01-11 14:13:12 |
| 6366 | 3336 | 1 | 2017-01-11 14:47:57 |
| 6367 | 3336 | 3 | 2017-01-11 15:28:32 |
| 6368 | 3336 | 2 | 2017-01-11 16:24:20 |
| 6369 | 3333 | 2 | 2017-01-12 12:04:56 |
| 6370 | 3334 | 3 | 2017-01-12 12:10:14 |
| 6371 | 3333 | 3 | 2017-01-12 13:09:23 |
| 6372 | 3395 | 2 | 2017-01-12 15:06:10 |
| 6373 | 3397 | 2 | 2017-01-12 15:09:51 |
| 6374 | 3396 | 2 | 2017-01-12 15:10:09 |
| 6375 | 3396 | 3 | 2017-01-12 15:35:45 |
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;