Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 8,876–8,900 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 8876 | 4222 | 1 | 2017-09-20 12:56:33 |
| 8877 | 4219 | 1 | 2017-09-20 12:56:51 |
| 8878 | 4197 | 1 | 2017-09-20 12:57:04 |
| 8879 | 4200 | 1 | 2017-09-20 12:57:29 |
| 8880 | 4236 | 1 | 2017-09-20 12:58:04 |
| 8881 | 4233 | 1 | 2017-09-20 12:58:24 |
| 8882 | 4204 | 1 | 2017-09-20 12:58:29 |
| 8883 | 4203 | 1 | 2017-09-20 12:59:13 |
| 8884 | 4237 | 1 | 2017-09-20 12:59:21 |
| 8885 | 4212 | 1 | 2017-09-20 12:59:26 |
| 8886 | 4227 | 1 | 2017-09-20 12:59:29 |
| 8887 | 4199 | 1 | 2017-09-20 12:59:37 |
| 8888 | 4206 | 1 | 2017-09-20 13:00:30 |
| 8889 | 4217 | 1 | 2017-09-20 13:00:32 |
| 8890 | 4215 | 1 | 2017-09-20 13:01:05 |
| 8891 | 4230 | 1 | 2017-09-20 13:03:16 |
| 8892 | 4226 | 1 | 2017-09-20 13:03:41 |
| 8893 | 4232 | 1 | 2017-09-20 13:04:10 |
| 8894 | 4231 | 1 | 2017-09-20 13:04:18 |
| 8895 | 4224 | 1 | 2017-09-20 13:05:19 |
| 8896 | 4238 | 1 | 2017-09-20 13:07:30 |
| 8897 | 4234 | 1 | 2017-09-20 13:08:18 |
| 8898 | 4218 | 2 | 2017-09-20 13:19:42 |
| 8899 | 4223 | 2 | 2017-09-20 13:22:18 |
| 8900 | 4233 | 2 | 2017-09-20 13:26:01 |
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;