Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 18,526–18,550 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 18526 | 9510 | 2 | 2019-12-05 15:58:18 |
| 18527 | 9511 | 2 | 2019-12-05 17:02:49 |
| 18528 | 9510 | 1 | 2019-12-05 17:07:18 |
| 18529 | 9519 | 1 | 2019-12-07 11:33:03 |
| 18530 | 9520 | 1 | 2019-12-07 11:34:21 |
| 18531 | 9514 | 1 | 2019-12-07 12:03:02 |
| 18532 | 9512 | 1 | 2019-12-07 12:04:54 |
| 18533 | 9513 | 1 | 2019-12-07 12:13:55 |
| 18534 | 9520 | 2 | 2019-12-07 12:32:36 |
| 18535 | 9519 | 2 | 2019-12-07 12:42:09 |
| 18536 | 9514 | 2 | 2019-12-07 12:47:41 |
| 18537 | 9513 | 2 | 2019-12-07 13:04:57 |
| 18538 | 9512 | 2 | 2019-12-07 13:23:32 |
| 18539 | 9519 | 1 | 2019-12-07 13:45:31 |
| 18540 | 9520 | 1 | 2019-12-07 14:02:56 |
| 18541 | 9522 | 2 | 2019-12-08 09:34:57 |
| 18542 | 9523 | 3 | 2019-12-08 09:35:41 |
| 18543 | 9521 | 3 | 2019-12-08 09:42:43 |
| 18544 | 9399 | 3 | 2019-12-08 09:50:59 |
| 18545 | 9400 | 3 | 2019-12-08 09:58:04 |
| 18546 | 9522 | 3 | 2019-12-08 10:02:42 |
| 18547 | 9523 | 2 | 2019-12-08 10:25:05 |
| 18548 | 9400 | 2 | 2019-12-08 10:27:30 |
| 18549 | 9521 | 2 | 2019-12-08 10:30:08 |
| 18550 | 9522 | 2 | 2019-12-08 10:30: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;