Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 6,926–6,950 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 6926 | 3290 | 2 | 2017-03-15 12:24:21 |
| 6927 | 3278 | 2 | 2017-03-15 12:26:28 |
| 6928 | 3288 | 2 | 2017-03-15 12:27:56 |
| 6929 | 3260 | 2 | 2017-03-15 12:29:50 |
| 6930 | 3287 | 2 | 2017-03-15 12:30:31 |
| 6931 | 3269 | 2 | 2017-03-15 12:31:28 |
| 6932 | 3296 | 2 | 2017-03-15 12:32:12 |
| 6933 | 3300 | 2 | 2017-03-15 12:34:05 |
| 6934 | 3255 | 2 | 2017-03-15 12:36:23 |
| 6935 | 3283 | 2 | 2017-03-15 12:38:09 |
| 6936 | 3273 | 2 | 2017-03-15 12:40:46 |
| 6937 | 3281 | 2 | 2017-03-15 12:41:02 |
| 6938 | 3277 | 2 | 2017-03-15 12:41:45 |
| 6939 | 3275 | 2 | 2017-03-15 12:44:20 |
| 6940 | 3264 | 2 | 2017-03-15 12:44:49 |
| 6941 | 3291 | 2 | 2017-03-15 12:46:51 |
| 6942 | 3266 | 2 | 2017-03-15 12:46:56 |
| 6943 | 3262 | 2 | 2017-03-15 12:47:39 |
| 6944 | 3297 | 2 | 2017-03-15 12:48:02 |
| 6945 | 3289 | 2 | 2017-03-15 12:50:49 |
| 6946 | 3280 | 2 | 2017-03-15 12:52:03 |
| 6947 | 3257 | 2 | 2017-03-15 12:57:10 |
| 6948 | 3259 | 2 | 2017-03-15 12:58:22 |
| 6949 | 3253 | 2 | 2017-03-15 13:00:39 |
| 6950 | 3279 | 2 | 2017-03-15 13:05:28 |
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;