Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 7,626–7,650 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 7626 | 3896 | 3 | 2017-05-23 15:35:13 |
| 7627 | 3895 | 1 | 2017-05-23 16:16:07 |
| 7628 | 3918 | 2 | 2017-05-24 10:39:24 |
| 7629 | 3917 | 2 | 2017-05-24 10:39:33 |
| 7630 | 3940 | 1 | 2017-05-24 10:54:28 |
| 7631 | 3918 | 3 | 2017-05-24 11:18:18 |
| 7632 | 3917 | 3 | 2017-05-24 11:23:18 |
| 7633 | 3918 | 2 | 2017-05-24 12:39:35 |
| 7634 | 3917 | 2 | 2017-05-24 12:53:23 |
| 7635 | 3917 | 3 | 2017-05-24 13:36:31 |
| 7636 | 3918 | 3 | 2017-05-24 14:02:16 |
| 7637 | 3965 | 3 | 2017-05-25 14:27:28 |
| 7638 | 3967 | 3 | 2017-05-25 14:28:20 |
| 7639 | 3968 | 3 | 2017-05-25 14:28:57 |
| 7640 | 3966 | 1 | 2017-05-25 14:32:10 |
| 7641 | 3965 | 1 | 2017-05-25 15:08:20 |
| 7642 | 3967 | 1 | 2017-05-25 15:16:49 |
| 7643 | 3968 | 1 | 2017-05-25 15:44:40 |
| 7644 | 3871 | 1 | 2017-05-27 14:45:49 |
| 7645 | 3870 | 1 | 2017-05-27 14:50:37 |
| 7646 | 3958 | 2 | 2017-05-27 15:07:44 |
| 7647 | 3957 | 2 | 2017-05-27 15:14:43 |
| 7648 | 3959 | 2 | 2017-05-27 15:17:42 |
| 7649 | 3871 | 3 | 2017-05-27 15:50:17 |
| 7650 | 3870 | 3 | 2017-05-27 16:24:41 |
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;