Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 3,676–3,700 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 3676 | 1715 | 1 | 2016-03-18 13:00:52 |
| 3677 | 1717 | 1 | 2016-03-18 13:02:13 |
| 3678 | 1710 | 1 | 2016-03-18 13:02:29 |
| 3679 | 1720 | 1 | 2016-03-18 13:02:43 |
| 3680 | 1713 | 1 | 2016-03-18 13:02:57 |
| 3681 | 1731 | 1 | 2016-03-18 13:03:46 |
| 3682 | 1721 | 1 | 2016-03-18 13:03:51 |
| 3683 | 1688 | 1 | 2016-03-18 13:04:25 |
| 3684 | 1724 | 1 | 2016-03-18 13:04:48 |
| 3685 | 1714 | 1 | 2016-03-18 13:04:54 |
| 3686 | 1729 | 1 | 2016-03-18 13:07:34 |
| 3687 | 1709 | 1 | 2016-03-18 13:07:44 |
| 3688 | 1718 | 1 | 2016-03-18 13:10:15 |
| 3689 | 1728 | 1 | 2016-03-18 13:12:03 |
| 3690 | 1719 | 2 | 2016-03-18 13:33:08 |
| 3691 | 1687 | 2 | 2016-03-18 13:33:41 |
| 3692 | 1711 | 2 | 2016-03-18 13:33:59 |
| 3693 | 1721 | 2 | 2016-03-18 13:36:16 |
| 3694 | 1688 | 2 | 2016-03-18 13:36:24 |
| 3695 | 1699 | 2 | 2016-03-18 13:37:50 |
| 3696 | 1706 | 2 | 2016-03-18 13:40:29 |
| 3697 | 1731 | 2 | 2016-03-18 13:41:21 |
| 3698 | 1690 | 2 | 2016-03-18 13:43:30 |
| 3699 | 1686 | 2 | 2016-03-18 13:44:12 |
| 3700 | 1703 | 2 | 2016-03-18 13:48:09 |
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;