Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 7,676–7,700 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 7676 | 3951 | 2 | 2017-05-28 12:50:25 |
| 7677 | 3962 | 3 | 2017-05-28 12:50:50 |
| 7678 | 3964 | 3 | 2017-05-28 13:04:28 |
| 7679 | 3963 | 2 | 2017-05-28 13:08:49 |
| 7680 | 3975 | 2 | 2017-05-28 13:20:54 |
| 7681 | 3972 | 1 | 2017-05-28 13:28:32 |
| 7682 | 3963 | 3 | 2017-05-28 13:54:15 |
| 7683 | 3976 | 2 | 2017-05-29 11:02:09 |
| 7684 | 3977 | 1 | 2017-05-29 15:26:07 |
| 7685 | 3982 | 2 | 2017-06-01 11:01:13 |
| 7686 | 3981 | 2 | 2017-06-01 11:07:06 |
| 7687 | 3982 | 3 | 2017-06-01 11:50:04 |
| 7688 | 3980 | 1 | 2017-06-04 10:28:20 |
| 7689 | 3988 | 2 | 2017-06-04 11:42:03 |
| 7690 | 3990 | 2 | 2017-06-04 11:45:58 |
| 7691 | 3989 | 2 | 2017-06-04 11:46:38 |
| 7692 | 3988 | 1 | 2017-06-04 12:18:26 |
| 7693 | 3990 | 1 | 2017-06-04 13:11:51 |
| 7694 | 3989 | 1 | 2017-06-04 13:16:18 |
| 7695 | 3946 | 2 | 2017-06-05 10:31:53 |
| 7696 | 3945 | 1 | 2017-06-05 10:38:02 |
| 7697 | 3943 | 2 | 2017-06-05 10:42:37 |
| 7698 | 3947 | 2 | 2017-06-05 10:44:23 |
| 7699 | 3944 | 2 | 2017-06-05 10:44:24 |
| 7700 | 3993 | 2 | 2017-06-05 10:56:43 |
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;