Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 12,876–12,900 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 12876 | 6376 | 1 | 2018-08-31 10:38:15 |
| 12877 | 6362 | 1 | 2018-08-31 10:39:39 |
| 12878 | 6369 | 1 | 2018-08-31 10:41:18 |
| 12879 | 6378 | 1 | 2018-08-31 10:42:42 |
| 12880 | 6375 | 1 | 2018-08-31 10:44:51 |
| 12881 | 6597 | 3 | 2018-08-31 10:49:29 |
| 12882 | 6379 | 1 | 2018-08-31 10:51:27 |
| 12883 | 6377 | 1 | 2018-08-31 10:53:19 |
| 12884 | 6382 | 1 | 2018-08-31 10:54:18 |
| 12885 | 6366 | 1 | 2018-08-31 10:56:36 |
| 12886 | 6595 | 2 | 2018-08-31 10:58:58 |
| 12887 | 6357 | 1 | 2018-08-31 11:00:26 |
| 12888 | 6372 | 1 | 2018-08-31 11:00:53 |
| 12889 | 6386 | 1 | 2018-08-31 11:01:20 |
| 12890 | 6389 | 1 | 2018-08-31 11:01:30 |
| 12891 | 6593 | 3 | 2018-08-31 11:02:23 |
| 12892 | 6381 | 1 | 2018-08-31 11:05:14 |
| 12893 | 6384 | 1 | 2018-08-31 11:05:45 |
| 12894 | 6385 | 1 | 2018-08-31 11:08:40 |
| 12895 | 6358 | 1 | 2018-08-31 11:08:44 |
| 12896 | 6374 | 1 | 2018-08-31 11:11:03 |
| 12897 | 6373 | 1 | 2018-08-31 11:11:25 |
| 12898 | 6596 | 3 | 2018-08-31 11:12:04 |
| 12899 | 6363 | 1 | 2018-08-31 11:13:29 |
| 12900 | 6364 | 1 | 2018-08-31 11:15:07 |
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;