Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 8,576–8,600 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 8576 | 4481 | 1 | 2017-08-22 16:11:18 |
| 8577 | 4480 | 3 | 2017-08-22 16:17:16 |
| 8578 | 4479 | 3 | 2017-08-22 16:18:15 |
| 8579 | 4490 | 2 | 2017-08-24 12:08:45 |
| 8580 | 4494 | 2 | 2017-08-24 12:12:42 |
| 8581 | 4491 | 2 | 2017-08-24 12:13:27 |
| 8582 | 4492 | 2 | 2017-08-24 12:16:09 |
| 8583 | 4493 | 2 | 2017-08-24 12:18:42 |
| 8584 | 4491 | 3 | 2017-08-24 12:38:48 |
| 8585 | 4492 | 3 | 2017-08-24 12:51:14 |
| 8586 | 4493 | 3 | 2017-08-24 12:51:31 |
| 8587 | 4494 | 3 | 2017-08-24 13:17:01 |
| 8588 | 4482 | 1 | 2017-08-24 13:25:18 |
| 8589 | 4491 | 1 | 2017-08-24 13:45:11 |
| 8590 | 4491 | 3 | 2017-08-24 14:45:21 |
| 8591 | 4360 | 3 | 2017-08-25 10:22:56 |
| 8592 | 4362 | 3 | 2017-08-25 10:26:42 |
| 8593 | 4361 | 3 | 2017-08-25 10:26:43 |
| 8594 | 4362 | 1 | 2017-08-25 11:01:53 |
| 8595 | 4360 | 1 | 2017-08-25 11:25:55 |
| 8596 | 4362 | 3 | 2017-08-25 11:31:31 |
| 8597 | 4361 | 1 | 2017-08-25 11:38:18 |
| 8598 | 4360 | 3 | 2017-08-25 12:30:59 |
| 8599 | 4361 | 3 | 2017-08-25 13:13:20 |
| 8600 | 4402 | 2 | 2017-08-26 11:51:48 |
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;