Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 8,401–8,425 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 8401 | 4327 | 2 | 2017-08-06 14:41:23 |
| 8402 | 4351 | 3 | 2017-08-06 15:02:27 |
| 8403 | 4357 | 1 | 2017-08-07 10:44:50 |
| 8404 | 4356 | 1 | 2017-08-07 10:49:26 |
| 8405 | 4343 | 3 | 2017-08-07 12:31:39 |
| 8406 | 4284 | 2 | 2017-08-07 12:59:05 |
| 8407 | 4283 | 2 | 2017-08-07 13:08:21 |
| 8408 | 4285 | 2 | 2017-08-07 13:11:59 |
| 8409 | 4359 | 2 | 2017-08-07 13:23:49 |
| 8410 | 4358 | 2 | 2017-08-07 13:33:28 |
| 8411 | 4284 | 3 | 2017-08-07 14:13:47 |
| 8412 | 4359 | 3 | 2017-08-07 14:36:17 |
| 8413 | 4358 | 3 | 2017-08-07 14:44:26 |
| 8414 | 4284 | 1 | 2017-08-07 15:27:03 |
| 8415 | 4358 | 1 | 2017-08-07 15:31:20 |
| 8416 | 4359 | 1 | 2017-08-07 15:44:40 |
| 8417 | 4284 | 3 | 2017-08-07 16:06:05 |
| 8418 | 4359 | 3 | 2017-08-07 16:35:52 |
| 8419 | 4358 | 3 | 2017-08-07 16:44:01 |
| 8420 | 4347 | 2 | 2017-08-09 11:51:40 |
| 8421 | 4346 | 2 | 2017-08-09 11:53:03 |
| 8422 | 4353 | 2 | 2017-08-09 15:22:55 |
| 8423 | 4354 | 2 | 2017-08-09 15:33:35 |
| 8424 | 4354 | 1 | 2017-08-09 16:46:45 |
| 8425 | 4355 | 2 | 2017-08-10 12:48:49 |
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;