Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 8,501–8,525 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 8501 | 4364 | 2 | 2017-08-19 09:46:30 |
| 8502 | 4392 | 3 | 2017-08-19 10:01:11 |
| 8503 | 4391 | 3 | 2017-08-19 10:02:53 |
| 8504 | 4364 | 3 | 2017-08-19 10:45:17 |
| 8505 | 4363 | 3 | 2017-08-19 11:06:36 |
| 8506 | 4391 | 1 | 2017-08-19 11:08:47 |
| 8507 | 4379 | 2 | 2017-08-19 12:18:35 |
| 8508 | 4380 | 2 | 2017-08-19 12:25:46 |
| 8509 | 4380 | 3 | 2017-08-19 13:14:01 |
| 8510 | 4379 | 3 | 2017-08-19 13:23:29 |
| 8511 | 4379 | 1 | 2017-08-19 14:15:27 |
| 8512 | 4415 | 3 | 2017-08-19 14:17:36 |
| 8513 | 4416 | 3 | 2017-08-19 14:18:53 |
| 8514 | 4373 | 2 | 2017-08-20 12:27:07 |
| 8515 | 4371 | 2 | 2017-08-20 12:31:16 |
| 8516 | 4369 | 2 | 2017-08-20 12:34:04 |
| 8517 | 4370 | 2 | 2017-08-20 12:35:05 |
| 8518 | 4372 | 2 | 2017-08-20 12:40:29 |
| 8519 | 4371 | 3 | 2017-08-20 13:00:18 |
| 8520 | 4421 | 2 | 2017-08-20 13:02:46 |
| 8521 | 4372 | 1 | 2017-08-20 13:09:22 |
| 8522 | 4373 | 1 | 2017-08-20 13:26:28 |
| 8523 | 4369 | 1 | 2017-08-20 13:44:50 |
| 8524 | 4370 | 1 | 2017-08-20 13:53:54 |
| 8525 | 4372 | 3 | 2017-08-20 13:57:20 |
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;