Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 15,876–15,900 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 15876 | 8114 | 2 | 2019-05-03 17:05:39 |
| 15877 | 8113 | 2 | 2019-05-03 17:05:50 |
| 15878 | 8111 | 2 | 2019-05-03 17:10:18 |
| 15879 | 8155 | 2 | 2019-05-03 17:17:41 |
| 15880 | 8105 | 3 | 2019-05-04 09:54:21 |
| 15881 | 8106 | 2 | 2019-05-04 10:00:12 |
| 15882 | 8170 | 1 | 2019-05-04 10:21:07 |
| 15883 | 8171 | 3 | 2019-05-04 10:27:12 |
| 15884 | 8172 | 3 | 2019-05-04 10:28:51 |
| 15885 | 8161 | 1 | 2019-05-04 10:31:25 |
| 15886 | 8169 | 3 | 2019-05-04 10:32:11 |
| 15887 | 8162 | 2 | 2019-05-04 10:33:14 |
| 15888 | 8168 | 1 | 2019-05-04 10:33:57 |
| 15889 | 8156 | 3 | 2019-05-04 10:47:43 |
| 15890 | 8172 | 2 | 2019-05-04 10:54:57 |
| 15891 | 8105 | 2 | 2019-05-04 11:04:12 |
| 15892 | 8175 | 2 | 2019-05-04 11:18:48 |
| 15893 | 8173 | 3 | 2019-05-04 11:21:01 |
| 15894 | 8174 | 3 | 2019-05-04 11:26:00 |
| 15895 | 8169 | 2 | 2019-05-04 11:32:25 |
| 15896 | 8171 | 2 | 2019-05-04 11:44:58 |
| 15897 | 8170 | 2 | 2019-05-04 11:55:08 |
| 15898 | 8156 | 1 | 2019-05-04 11:58:37 |
| 15899 | 8168 | 2 | 2019-05-04 12:02:37 |
| 15900 | 8105 | 3 | 2019-05-04 12:05:53 |
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;