Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 17,376–17,400 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 17376 | 8793 | 2 | 2019-08-22 15:01:23 |
| 17377 | 8793 | 3 | 2019-08-22 16:22:49 |
| 17378 | 8778 | 3 | 2019-08-22 16:55:11 |
| 17379 | 8778 | 2 | 2019-08-22 17:40:30 |
| 17380 | 8793 | 2 | 2019-08-22 17:47:56 |
| 17381 | 8798 | 2 | 2019-08-23 10:23:56 |
| 17382 | 8798 | 3 | 2019-08-23 11:47:21 |
| 17383 | 8797 | 2 | 2019-08-23 13:47:10 |
| 17384 | 8797 | 1 | 2019-08-23 14:48:58 |
| 17385 | 8797 | 2 | 2019-08-23 15:48:09 |
| 17386 | 8807 | 2 | 2019-08-24 10:00:13 |
| 17387 | 8806 | 2 | 2019-08-24 10:01:40 |
| 17388 | 8805 | 2 | 2019-08-24 10:04:54 |
| 17389 | 8806 | 3 | 2019-08-24 10:41:45 |
| 17390 | 8805 | 3 | 2019-08-24 11:27:08 |
| 17391 | 8807 | 3 | 2019-08-24 11:32:36 |
| 17392 | 8792 | 2 | 2019-08-24 14:54:58 |
| 17393 | 8782 | 1 | 2019-08-24 15:24:37 |
| 17394 | 8781 | 2 | 2019-08-24 15:32:40 |
| 17395 | 8781 | 1 | 2019-08-24 15:58:35 |
| 17396 | 8782 | 3 | 2019-08-24 16:05:51 |
| 17397 | 8792 | 3 | 2019-08-24 16:10:42 |
| 17398 | 8782 | 1 | 2019-08-24 17:29:18 |
| 17399 | 8764 | 2 | 2019-08-25 10:47:33 |
| 17400 | 8763 | 2 | 2019-08-25 10:48:21 |
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;