Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 6,401–6,425 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 6401 | 3422 | 3 | 2017-01-20 14:25:50 |
| 6402 | 3420 | 3 | 2017-01-20 14:37:29 |
| 6403 | 3421 | 1 | 2017-01-20 14:40:17 |
| 6404 | 3421 | 2 | 2017-01-20 15:08:44 |
| 6405 | 3420 | 2 | 2017-01-20 15:44:50 |
| 6406 | 3422 | 2 | 2017-01-20 16:00:40 |
| 6407 | 3421 | 3 | 2017-01-20 16:38:19 |
| 6408 | 3422 | 3 | 2017-01-20 16:48:47 |
| 6409 | 3420 | 3 | 2017-01-20 17:03:10 |
| 6410 | 3405 | 2 | 2017-01-21 10:12:36 |
| 6411 | 3404 | 3 | 2017-01-21 10:15:52 |
| 6412 | 3404 | 2 | 2017-01-21 11:28:20 |
| 6413 | 3405 | 1 | 2017-01-21 11:43:07 |
| 6414 | 3404 | 1 | 2017-01-21 12:13:09 |
| 6415 | 3405 | 2 | 2017-01-21 12:43:22 |
| 6416 | 3405 | 1 | 2017-01-21 13:37:53 |
| 6417 | 3412 | 3 | 2017-01-22 11:32:58 |
| 6418 | 3471 | 2 | 2017-01-23 12:13:44 |
| 6419 | 3472 | 2 | 2017-01-23 12:16:30 |
| 6420 | 3471 | 3 | 2017-01-23 13:00:25 |
| 6421 | 3471 | 2 | 2017-01-23 13:51:08 |
| 6422 | 3472 | 3 | 2017-01-23 13:51:18 |
| 6423 | 3472 | 2 | 2017-01-23 14:27:06 |
| 6424 | 3423 | 1 | 2017-01-24 10:16:45 |
| 6425 | 3413 | 2 | 2017-01-26 10:49: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;