Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 15,426–15,450 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 15426 | 7314 | 1 | 2019-04-02 11:07:23 |
| 15427 | 7327 | 1 | 2019-04-02 11:07:33 |
| 15428 | 7328 | 1 | 2019-04-02 11:10:08 |
| 15429 | 7318 | 1 | 2019-04-02 11:12:08 |
| 15430 | 7305 | 1 | 2019-04-02 11:15:16 |
| 15431 | 7294 | 1 | 2019-04-02 11:16:01 |
| 15432 | 7319 | 1 | 2019-04-02 11:16:08 |
| 15433 | 7311 | 1 | 2019-04-02 11:20:29 |
| 15434 | 7919 | 3 | 2019-04-02 11:20:29 |
| 15435 | 7310 | 1 | 2019-04-02 11:21:28 |
| 15436 | 7315 | 1 | 2019-04-02 11:35:38 |
| 15437 | 7918 | 3 | 2019-04-02 11:36:06 |
| 15438 | 7297 | 1 | 2019-04-02 11:37:27 |
| 15439 | 7302 | 1 | 2019-04-02 11:38:25 |
| 15440 | 7324 | 1 | 2019-04-02 11:42:04 |
| 15441 | 7296 | 1 | 2019-04-02 11:42:56 |
| 15442 | 7322 | 1 | 2019-04-02 11:44:35 |
| 15443 | 7303 | 1 | 2019-04-02 11:53:25 |
| 15444 | 7919 | 2 | 2019-04-02 12:28:50 |
| 15445 | 7918 | 2 | 2019-04-02 12:49:09 |
| 15446 | 7882 | 2 | 2019-04-03 09:41:32 |
| 15447 | 7883 | 3 | 2019-04-03 09:45:05 |
| 15448 | 7883 | 2 | 2019-04-03 10:49:41 |
| 15449 | 7930 | 2 | 2019-04-03 12:17:49 |
| 15450 | 7931 | 2 | 2019-04-03 12:23:00 |
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;