Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 19,276–19,300 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 19276 | 9715 | 3 | 2020-01-22 13:23:12 |
| 19277 | 9711 | 2 | 2020-01-22 13:23:51 |
| 19278 | 9714 | 3 | 2020-01-22 13:32:45 |
| 19279 | 9644 | 3 | 2020-01-22 13:58:06 |
| 19280 | 9712 | 2 | 2020-01-22 14:34:36 |
| 19281 | 9713 | 1 | 2020-01-22 14:37:50 |
| 19282 | 9712 | 3 | 2020-01-22 15:32:25 |
| 19283 | 9712 | 2 | 2020-01-22 16:12:46 |
| 19284 | 9720 | 1 | 2020-01-23 13:02:40 |
| 19285 | 9719 | 1 | 2020-01-23 13:04:12 |
| 19286 | 9717 | 1 | 2020-01-23 13:04:54 |
| 19287 | 9665 | 3 | 2020-01-23 13:41:41 |
| 19288 | 9664 | 3 | 2020-01-23 13:42:39 |
| 19289 | 9719 | 2 | 2020-01-23 13:46:10 |
| 19290 | 9664 | 1 | 2020-01-23 14:10:02 |
| 19291 | 9720 | 2 | 2020-01-23 14:17:01 |
| 19292 | 9717 | 2 | 2020-01-23 14:34:13 |
| 19293 | 9722 | 2 | 2020-01-23 14:45:31 |
| 19294 | 9721 | 2 | 2020-01-23 14:45:51 |
| 19295 | 9719 | 3 | 2020-01-23 14:54:29 |
| 19296 | 9665 | 1 | 2020-01-23 15:02:18 |
| 19297 | 9722 | 3 | 2020-01-23 15:18:20 |
| 19298 | 9717 | 3 | 2020-01-23 15:32:10 |
| 19299 | 9720 | 3 | 2020-01-23 15:44:49 |
| 19300 | 9722 | 1 | 2020-01-23 16:13:17 |
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;