Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 12,051–12,075 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 12051 | 6263 | 3 | 2018-07-21 16:59:37 |
| 12052 | 6277 | 2 | 2018-07-21 17:08:18 |
| 12053 | 6265 | 3 | 2018-07-21 17:13:01 |
| 12054 | 6264 | 3 | 2018-07-21 17:20:56 |
| 12055 | 6263 | 1 | 2018-07-21 17:43:59 |
| 12056 | 6234 | 3 | 2018-07-22 10:22:15 |
| 12057 | 6231 | 3 | 2018-07-22 10:22:43 |
| 12058 | 6232 | 3 | 2018-07-22 10:25:10 |
| 12059 | 6233 | 3 | 2018-07-22 10:30:12 |
| 12060 | 6235 | 3 | 2018-07-22 10:32:36 |
| 12061 | 6234 | 2 | 2018-07-22 10:55:47 |
| 12062 | 6232 | 2 | 2018-07-22 11:19:18 |
| 12063 | 6233 | 2 | 2018-07-22 11:23:35 |
| 12064 | 6231 | 2 | 2018-07-22 11:37:34 |
| 12065 | 6235 | 2 | 2018-07-22 11:40:39 |
| 12066 | 6217 | 1 | 2018-07-22 11:50:20 |
| 12067 | 6218 | 2 | 2018-07-22 11:52:45 |
| 12068 | 6216 | 1 | 2018-07-22 11:54:32 |
| 12069 | 6217 | 2 | 2018-07-22 12:21:45 |
| 12070 | 6216 | 2 | 2018-07-22 13:07:21 |
| 12071 | 6205 | 2 | 2018-07-22 14:50:01 |
| 12072 | 6204 | 3 | 2018-07-22 14:50:27 |
| 12073 | 6203 | 2 | 2018-07-22 14:56:38 |
| 12074 | 6206 | 2 | 2018-07-22 14:56:55 |
| 12075 | 6206 | 3 | 2018-07-22 15:43:47 |
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;