Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 10,576–10,600 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 10576 | 5470 | 2 | 2018-03-28 13:30:25 |
| 10577 | 5470 | 1 | 2018-03-28 14:54:59 |
| 10578 | 5477 | 2 | 2018-03-29 09:58:49 |
| 10579 | 5431 | 2 | 2018-03-29 10:01:57 |
| 10580 | 5478 | 2 | 2018-03-29 10:10:22 |
| 10581 | 5479 | 2 | 2018-03-29 10:17:33 |
| 10582 | 5480 | 3 | 2018-03-29 10:20:20 |
| 10583 | 5481 | 2 | 2018-03-29 10:26:27 |
| 10584 | 5478 | 1 | 2018-03-29 11:19:43 |
| 10585 | 5479 | 1 | 2018-03-29 11:28:19 |
| 10586 | 5480 | 1 | 2018-03-29 11:41:01 |
| 10587 | 5471 | 3 | 2018-03-29 11:46:28 |
| 10588 | 5478 | 2 | 2018-03-29 11:53:12 |
| 10589 | 5481 | 3 | 2018-03-29 11:59:21 |
| 10590 | 5478 | 3 | 2018-03-29 12:28:03 |
| 10591 | 5471 | 1 | 2018-03-29 12:46:24 |
| 10592 | 5483 | 2 | 2018-03-30 11:51:32 |
| 10593 | 5482 | 2 | 2018-03-30 11:53:47 |
| 10594 | 5442 | 2 | 2018-03-30 14:21:18 |
| 10595 | 5442 | 3 | 2018-03-30 15:35:24 |
| 10596 | 5442 | 1 | 2018-03-30 16:48:36 |
| 10597 | 5491 | 2 | 2018-03-31 09:16:55 |
| 10598 | 5492 | 2 | 2018-03-31 09:22:26 |
| 10599 | 5493 | 2 | 2018-03-31 09:28:12 |
| 10600 | 5492 | 1 | 2018-03-31 09:52:33 |
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;