Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 3,651–3,675 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 3651 | 1964 | 3 | 2016-03-18 11:28:18 |
| 3652 | 1964 | 2 | 2016-03-18 12:42:21 |
| 3653 | 1703 | 1 | 2016-03-18 12:52:13 |
| 3654 | 1706 | 1 | 2016-03-18 12:52:17 |
| 3655 | 1723 | 1 | 2016-03-18 12:52:53 |
| 3656 | 1726 | 1 | 2016-03-18 12:52:53 |
| 3657 | 1711 | 1 | 2016-03-18 12:53:13 |
| 3658 | 1690 | 1 | 2016-03-18 12:53:23 |
| 3659 | 1695 | 1 | 2016-03-18 12:53:55 |
| 3660 | 1702 | 1 | 2016-03-18 12:54:09 |
| 3661 | 1719 | 1 | 2016-03-18 12:54:09 |
| 3662 | 1699 | 1 | 2016-03-18 12:55:41 |
| 3663 | 1716 | 1 | 2016-03-18 12:56:37 |
| 3664 | 1686 | 1 | 2016-03-18 12:56:45 |
| 3665 | 1707 | 1 | 2016-03-18 12:56:50 |
| 3666 | 1704 | 1 | 2016-03-18 12:57:21 |
| 3667 | 1692 | 1 | 2016-03-18 12:57:31 |
| 3668 | 1712 | 1 | 2016-03-18 12:57:47 |
| 3669 | 1722 | 1 | 2016-03-18 12:58:12 |
| 3670 | 1727 | 1 | 2016-03-18 12:58:39 |
| 3671 | 1694 | 1 | 2016-03-18 12:58:44 |
| 3672 | 1730 | 1 | 2016-03-18 12:58:44 |
| 3673 | 1687 | 1 | 2016-03-18 12:59:47 |
| 3674 | 1697 | 1 | 2016-03-18 12:59:53 |
| 3675 | 1700 | 1 | 2016-03-18 13:00:00 |
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;