Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 17,551–17,575 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 17551 | 8871 | 1 | 2019-09-01 12:17:57 |
| 17552 | 8872 | 1 | 2019-09-01 12:18:34 |
| 17553 | 8796 | 2 | 2019-09-01 12:20:56 |
| 17554 | 8795 | 1 | 2019-09-01 12:42:07 |
| 17555 | 8871 | 3 | 2019-09-01 12:54:32 |
| 17556 | 8872 | 3 | 2019-09-01 13:32:02 |
| 17557 | 8796 | 1 | 2019-09-01 13:52:01 |
| 17558 | 8868 | 2 | 2019-09-02 11:48:25 |
| 17559 | 8791 | 2 | 2019-09-03 09:44:37 |
| 17560 | 8790 | 2 | 2019-09-03 09:47:06 |
| 17561 | 8878 | 3 | 2019-09-04 12:42:32 |
| 17562 | 8877 | 3 | 2019-09-04 12:48:16 |
| 17563 | 8817 | 3 | 2019-09-04 13:21:44 |
| 17564 | 8809 | 3 | 2019-09-04 13:21:52 |
| 17565 | 8818 | 2 | 2019-09-04 13:23:35 |
| 17566 | 8819 | 2 | 2019-09-04 13:24:18 |
| 17567 | 8808 | 1 | 2019-09-04 13:37:10 |
| 17568 | 8809 | 1 | 2019-09-04 14:06:33 |
| 17569 | 8809 | 3 | 2019-09-04 14:57:04 |
| 17570 | 8808 | 2 | 2019-09-04 15:03:57 |
| 17571 | 8881 | 2 | 2019-09-04 15:55:19 |
| 17572 | 8880 | 2 | 2019-09-04 16:00:49 |
| 17573 | 8882 | 2 | 2019-09-04 16:01:45 |
| 17574 | 8879 | 2 | 2019-09-04 16:07:41 |
| 17575 | 8808 | 3 | 2019-09-04 16:08:24 |
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;