Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 8,276–8,300 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 8276 | 4267 | 1 | 2017-07-22 12:36:53 |
| 8277 | 4266 | 1 | 2017-07-22 12:37:45 |
| 8278 | 4264 | 1 | 2017-07-22 12:40:56 |
| 8279 | 4267 | 3 | 2017-07-22 13:30:04 |
| 8280 | 4266 | 3 | 2017-07-22 13:30:48 |
| 8281 | 4265 | 3 | 2017-07-22 13:54:11 |
| 8282 | 4264 | 3 | 2017-07-22 14:07:22 |
| 8283 | 4266 | 2 | 2017-07-22 14:15:20 |
| 8284 | 4265 | 2 | 2017-07-22 14:44:53 |
| 8285 | 4264 | 2 | 2017-07-22 14:46:13 |
| 8286 | 4267 | 2 | 2017-07-22 15:00:28 |
| 8287 | 4299 | 2 | 2017-07-23 10:27:26 |
| 8288 | 4298 | 2 | 2017-07-23 11:12:13 |
| 8289 | 4297 | 2 | 2017-07-23 11:18:25 |
| 8290 | 4296 | 2 | 2017-07-23 11:19:15 |
| 8291 | 4298 | 3 | 2017-07-23 12:08:36 |
| 8292 | 4296 | 3 | 2017-07-23 12:14:41 |
| 8293 | 4297 | 3 | 2017-07-23 12:44:47 |
| 8294 | 4288 | 2 | 2017-07-24 11:31:42 |
| 8295 | 4287 | 2 | 2017-07-24 11:33:19 |
| 8296 | 4286 | 2 | 2017-07-24 11:46:28 |
| 8297 | 4288 | 1 | 2017-07-24 12:01:53 |
| 8298 | 4286 | 1 | 2017-07-24 12:13:28 |
| 8299 | 4287 | 1 | 2017-07-24 12:54:14 |
| 8300 | 4303 | 3 | 2017-07-25 10:30:13 |
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;