Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 14,476–14,500 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 14476 | 7383 | 2 | 2019-01-17 12:05:55 |
| 14477 | 7384 | 2 | 2019-01-17 12:07:23 |
| 14478 | 7384 | 3 | 2019-01-17 13:13:26 |
| 14479 | 7383 | 3 | 2019-01-17 13:40:14 |
| 14480 | 7456 | 2 | 2019-01-19 09:18:03 |
| 14481 | 7455 | 2 | 2019-01-19 09:27:17 |
| 14482 | 7454 | 2 | 2019-01-19 09:28:58 |
| 14483 | 7453 | 2 | 2019-01-19 09:33:08 |
| 14484 | 7456 | 1 | 2019-01-19 10:07:25 |
| 14485 | 7453 | 1 | 2019-01-19 10:48:53 |
| 14486 | 7454 | 1 | 2019-01-19 10:52:53 |
| 14487 | 7457 | 2 | 2019-01-19 11:06:07 |
| 14488 | 7458 | 1 | 2019-01-19 12:26:39 |
| 14489 | 7459 | 1 | 2019-01-19 12:28:19 |
| 14490 | 7459 | 2 | 2019-01-19 13:18:36 |
| 14491 | 7458 | 2 | 2019-01-19 13:39:01 |
| 14492 | 7459 | 3 | 2019-01-19 14:19:33 |
| 14493 | 7458 | 3 | 2019-01-19 14:33:11 |
| 14494 | 7205 | 2 | 2019-01-20 09:46:48 |
| 14495 | 7206 | 2 | 2019-01-20 09:47:39 |
| 14496 | 7207 | 2 | 2019-01-20 09:49:08 |
| 14497 | 7468 | 2 | 2019-01-23 10:12:04 |
| 14498 | 7469 | 2 | 2019-01-23 10:25:38 |
| 14499 | 7468 | 3 | 2019-01-23 10:53:50 |
| 14500 | 7469 | 3 | 2019-01-23 11:20:46 |
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;