Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 6,576–6,600 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 6576 | 3547 | 1 | 2017-02-22 16:08:26 |
| 6577 | 3548 | 2 | 2017-02-22 16:15:31 |
| 6578 | 3549 | 3 | 2017-02-22 16:57:07 |
| 6579 | 3550 | 3 | 2017-02-22 17:04:01 |
| 6580 | 3548 | 3 | 2017-02-22 17:04:27 |
| 6581 | 3551 | 2 | 2017-02-23 10:36:05 |
| 6582 | 3552 | 2 | 2017-02-23 10:38:09 |
| 6583 | 3082 | 2 | 2017-02-24 11:12:05 |
| 6584 | 3096 | 2 | 2017-02-24 11:12:16 |
| 6585 | 3135 | 2 | 2017-02-24 11:12:58 |
| 6586 | 3093 | 2 | 2017-02-24 11:13:23 |
| 6587 | 3128 | 2 | 2017-02-24 11:14:12 |
| 6588 | 3119 | 2 | 2017-02-24 11:14:29 |
| 6589 | 3131 | 2 | 2017-02-24 11:14:34 |
| 6590 | 3117 | 2 | 2017-02-24 11:15:23 |
| 6591 | 3088 | 2 | 2017-02-24 11:15:34 |
| 6592 | 3084 | 2 | 2017-02-24 11:15:59 |
| 6593 | 3105 | 2 | 2017-02-24 11:16:00 |
| 6594 | 3081 | 2 | 2017-02-24 11:16:51 |
| 6595 | 3110 | 2 | 2017-02-24 11:17:12 |
| 6596 | 3090 | 2 | 2017-02-24 11:17:13 |
| 6597 | 3103 | 2 | 2017-02-24 11:17:21 |
| 6598 | 3099 | 2 | 2017-02-24 11:17:33 |
| 6599 | 3092 | 2 | 2017-02-24 11:17:47 |
| 6600 | 3108 | 2 | 2017-02-24 11:18:16 |
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;