Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 15,476–15,500 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 15476 | 7989 | 2 | 2019-04-06 10:04:40 |
| 15477 | 7986 | 2 | 2019-04-06 10:21:57 |
| 15478 | 7989 | 3 | 2019-04-06 10:43:23 |
| 15479 | 7988 | 2 | 2019-04-06 10:52:22 |
| 15480 | 7988 | 1 | 2019-04-06 11:49:05 |
| 15481 | 7991 | 2 | 2019-04-07 10:09:04 |
| 15482 | 7990 | 2 | 2019-04-07 10:13:08 |
| 15483 | 7990 | 1 | 2019-04-07 11:00:36 |
| 15484 | 7978 | 3 | 2019-04-07 11:23:07 |
| 15485 | 7991 | 1 | 2019-04-07 11:33:09 |
| 15486 | 7990 | 2 | 2019-04-07 11:34:22 |
| 15487 | 7991 | 2 | 2019-04-07 12:06:05 |
| 15488 | 7978 | 2 | 2019-04-07 12:07:11 |
| 15489 | 7978 | 3 | 2019-04-07 13:04:14 |
| 15490 | 7978 | 1 | 2019-04-07 14:32:20 |
| 15491 | 7994 | 2 | 2019-04-08 09:50:02 |
| 15492 | 7994 | 1 | 2019-04-08 10:53:20 |
| 15493 | 7994 | 2 | 2019-04-08 11:53:35 |
| 15494 | 8035 | 2 | 2019-04-08 12:09:42 |
| 15495 | 7995 | 2 | 2019-04-08 12:13:24 |
| 15496 | 7996 | 2 | 2019-04-08 12:14:04 |
| 15497 | 8036 | 2 | 2019-04-08 12:14:51 |
| 15498 | 8035 | 3 | 2019-04-08 12:51:24 |
| 15499 | 7996 | 1 | 2019-04-08 13:01:11 |
| 15500 | 7994 | 1 | 2019-04-08 13:06: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;