Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 6,551–6,575 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 6551 | 3541 | 2 | 2017-02-19 12:30:11 |
| 6552 | 3539 | 1 | 2017-02-19 12:32:50 |
| 6553 | 3542 | 2 | 2017-02-19 12:40:12 |
| 6554 | 3540 | 2 | 2017-02-19 12:42:04 |
| 6555 | 3533 | 1 | 2017-02-19 14:28:29 |
| 6556 | 3534 | 1 | 2017-02-19 14:36:05 |
| 6557 | 3545 | 2 | 2017-02-20 10:08:26 |
| 6558 | 3546 | 2 | 2017-02-20 10:18:46 |
| 6559 | 3545 | 1 | 2017-02-20 10:48:09 |
| 6560 | 3546 | 1 | 2017-02-20 11:37:48 |
| 6561 | 3545 | 3 | 2017-02-20 11:45:06 |
| 6562 | 3536 | 1 | 2017-02-20 11:49:50 |
| 6563 | 3546 | 3 | 2017-02-20 12:13:10 |
| 6564 | 3546 | 2 | 2017-02-20 12:50:52 |
| 6565 | 3545 | 2 | 2017-02-20 13:04:48 |
| 6566 | 3543 | 2 | 2017-02-20 13:48:50 |
| 6567 | 3544 | 2 | 2017-02-20 13:52:25 |
| 6568 | 3543 | 1 | 2017-02-20 14:55:14 |
| 6569 | 3544 | 1 | 2017-02-20 15:09:47 |
| 6570 | 3547 | 3 | 2017-02-22 14:56:01 |
| 6571 | 3548 | 1 | 2017-02-22 14:59:45 |
| 6572 | 3550 | 1 | 2017-02-22 15:00:49 |
| 6573 | 3549 | 1 | 2017-02-22 15:04:14 |
| 6574 | 3549 | 2 | 2017-02-22 15:40:53 |
| 6575 | 3550 | 2 | 2017-02-22 15:56:45 |
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;