Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 3,626–3,650 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 3626 | 1871 | 1 | 2016-03-10 15:13:47 |
| 3627 | 1869 | 1 | 2016-03-10 15:40:07 |
| 3628 | 1888 | 1 | 2016-03-12 16:54:36 |
| 3629 | 1891 | 1 | 2016-03-12 17:01:38 |
| 3630 | 1890 | 1 | 2016-03-12 17:03:39 |
| 3631 | 1889 | 3 | 2016-03-12 17:05:04 |
| 3632 | 1889 | 1 | 2016-03-12 17:49:48 |
| 3633 | 1857 | 3 | 2016-03-15 11:01:23 |
| 3634 | 1856 | 3 | 2016-03-15 11:12:07 |
| 3635 | 1858 | 3 | 2016-03-15 11:13:49 |
| 3636 | 1884 | 2 | 2016-03-16 11:43:36 |
| 3637 | 1882 | 2 | 2016-03-16 11:46:05 |
| 3638 | 1885 | 2 | 2016-03-16 11:48:37 |
| 3639 | 1883 | 2 | 2016-03-16 11:51:14 |
| 3640 | 1886 | 2 | 2016-03-16 12:03:56 |
| 3641 | 1876 | 3 | 2016-03-16 13:04:01 |
| 3642 | 1874 | 3 | 2016-03-16 13:06:35 |
| 3643 | 1884 | 1 | 2016-03-16 13:07:07 |
| 3644 | 1875 | 2 | 2016-03-16 13:09:02 |
| 3645 | 1873 | 3 | 2016-03-16 13:11:11 |
| 3646 | 1877 | 3 | 2016-03-16 13:16:20 |
| 3647 | 1886 | 3 | 2016-03-16 13:27:36 |
| 3648 | 1959 | 2 | 2016-03-16 13:54:37 |
| 3649 | 1886 | 1 | 2016-03-16 14:41:14 |
| 3650 | 1959 | 3 | 2016-03-16 15:25:25 |
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;