Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 17,426–17,450 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 17426 | 8727 | 2 | 2019-08-26 16:05:26 |
| 17427 | 8728 | 2 | 2019-08-26 16:06:50 |
| 17428 | 8728 | 1 | 2019-08-26 16:45:16 |
| 17429 | 8728 | 2 | 2019-08-26 17:22:38 |
| 17430 | 8727 | 1 | 2019-08-26 17:33:16 |
| 17431 | 8836 | 1 | 2019-08-27 10:22:35 |
| 17432 | 8838 | 1 | 2019-08-27 10:26:59 |
| 17433 | 8839 | 1 | 2019-08-27 10:28:44 |
| 17434 | 8835 | 1 | 2019-08-27 10:33:28 |
| 17435 | 8837 | 1 | 2019-08-27 10:35:22 |
| 17436 | 8711 | 2 | 2019-08-27 10:44:44 |
| 17437 | 8838 | 2 | 2019-08-27 10:58:58 |
| 17438 | 8835 | 2 | 2019-08-27 11:29:05 |
| 17439 | 8838 | 1 | 2019-08-27 11:41:46 |
| 17440 | 8836 | 2 | 2019-08-27 11:53:28 |
| 17441 | 8839 | 2 | 2019-08-27 11:58:00 |
| 17442 | 8837 | 2 | 2019-08-27 12:02:44 |
| 17443 | 8835 | 1 | 2019-08-27 12:36:54 |
| 17444 | 8837 | 1 | 2019-08-27 12:40:41 |
| 17445 | 8836 | 1 | 2019-08-27 12:41:03 |
| 17446 | 8839 | 1 | 2019-08-27 13:03:31 |
| 17447 | 8702 | 3 | 2019-08-27 16:19:07 |
| 17448 | 8703 | 3 | 2019-08-27 16:23:12 |
| 17449 | 8703 | 1 | 2019-08-27 16:57:35 |
| 17450 | 8702 | 1 | 2019-08-27 17:37:39 |
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;