Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 3,826–3,850 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 3826 | 1982 | 2 | 2016-03-28 10:56:42 |
| 3827 | 1984 | 3 | 2016-03-28 11:11:11 |
| 3828 | 1987 | 1 | 2016-03-28 11:11:17 |
| 3829 | 1985 | 1 | 2016-03-28 11:11:43 |
| 3830 | 1988 | 1 | 2016-03-28 11:12:32 |
| 3831 | 1986 | 1 | 2016-03-28 11:14:35 |
| 3832 | 1982 | 3 | 2016-03-28 11:25:11 |
| 3833 | 1957 | 2 | 2016-03-28 11:56:16 |
| 3834 | 1958 | 2 | 2016-03-28 12:03:44 |
| 3835 | 1982 | 1 | 2016-03-28 12:07:37 |
| 3836 | 1985 | 2 | 2016-03-28 12:14:31 |
| 3837 | 2006 | 2 | 2016-03-28 12:15:36 |
| 3838 | 1986 | 2 | 2016-03-28 12:27:02 |
| 3839 | 1988 | 2 | 2016-03-28 12:29:51 |
| 3840 | 1987 | 2 | 2016-03-28 12:39:26 |
| 3841 | 1984 | 2 | 2016-03-28 12:45:26 |
| 3842 | 1958 | 3 | 2016-03-28 12:55:07 |
| 3843 | 1957 | 3 | 2016-03-28 13:09:20 |
| 3844 | 2006 | 3 | 2016-03-28 13:12:48 |
| 3845 | 1982 | 3 | 2016-03-28 13:25:10 |
| 3846 | 2006 | 1 | 2016-03-28 14:04:53 |
| 3847 | 2006 | 2 | 2016-03-28 15:09:49 |
| 3848 | 2007 | 2 | 2016-03-28 15:22:40 |
| 3849 | 2006 | 1 | 2016-03-28 16:33:12 |
| 3850 | 2007 | 1 | 2016-03-28 16:55:52 |
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;