Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 15,526–15,550 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 15526 | 7821 | 2 | 2019-04-11 13:31:31 |
| 15527 | 7823 | 2 | 2019-04-11 13:34:39 |
| 15528 | 7977 | 1 | 2019-04-11 13:35:57 |
| 15529 | 7824 | 3 | 2019-04-11 13:35:59 |
| 15530 | 8037 | 3 | 2019-04-11 13:54:09 |
| 15531 | 7824 | 1 | 2019-04-11 14:11:29 |
| 15532 | 7822 | 3 | 2019-04-11 14:18:16 |
| 15533 | 7821 | 3 | 2019-04-11 14:33:20 |
| 15534 | 7823 | 3 | 2019-04-11 15:05:29 |
| 15535 | 8037 | 2 | 2019-04-11 15:13:56 |
| 15536 | 7822 | 1 | 2019-04-11 15:20:57 |
| 15537 | 8037 | 1 | 2019-04-11 15:50:12 |
| 15538 | 7821 | 1 | 2019-04-11 16:02:12 |
| 15539 | 7823 | 1 | 2019-04-11 16:38:52 |
| 15540 | 7983 | 2 | 2019-04-11 16:45:56 |
| 15541 | 7984 | 3 | 2019-04-11 16:47:34 |
| 15542 | 7985 | 3 | 2019-04-11 16:58:20 |
| 15543 | 8048 | 3 | 2019-04-12 10:22:06 |
| 15544 | 8049 | 1 | 2019-04-12 10:24:34 |
| 15545 | 8049 | 2 | 2019-04-12 11:28:33 |
| 15546 | 8049 | 3 | 2019-04-12 12:55:22 |
| 15547 | 8050 | 2 | 2019-04-12 13:34:44 |
| 15548 | 8050 | 3 | 2019-04-12 14:21:43 |
| 15549 | 8050 | 1 | 2019-04-12 15:16:04 |
| 15550 | 7982 | 2 | 2019-04-13 10:33:59 |
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;