Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 3,976–4,000 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 3976 | 2065 | 2 | 2016-04-16 17:12:30 |
| 3977 | 2068 | 2 | 2016-04-17 10:21:40 |
| 3978 | 2069 | 2 | 2016-04-17 10:30:53 |
| 3979 | 2069 | 1 | 2016-04-17 11:47:13 |
| 3980 | 2068 | 1 | 2016-04-17 11:48:10 |
| 3981 | 2071 | 2 | 2016-04-19 09:13:20 |
| 3982 | 2071 | 1 | 2016-04-19 09:48:22 |
| 3983 | 2070 | 2 | 2016-04-19 10:38:01 |
| 3984 | 2077 | 2 | 2016-04-19 10:43:15 |
| 3985 | 2078 | 2 | 2016-04-19 10:45:54 |
| 3986 | 2076 | 2 | 2016-04-19 10:51:51 |
| 3987 | 2071 | 2 | 2016-04-19 11:07:02 |
| 3988 | 2077 | 3 | 2016-04-19 11:14:30 |
| 3989 | 2070 | 1 | 2016-04-19 11:43:39 |
| 3990 | 2071 | 3 | 2016-04-19 12:08:26 |
| 3991 | 2070 | 2 | 2016-04-19 12:18:23 |
| 3992 | 2070 | 1 | 2016-04-19 13:32:52 |
| 3993 | 2050 | 2 | 2016-04-19 15:21:58 |
| 3994 | 2050 | 3 | 2016-04-19 16:06:31 |
| 3995 | 2074 | 2 | 2016-04-22 11:10:55 |
| 3996 | 2072 | 3 | 2016-04-22 11:11:40 |
| 3997 | 2075 | 3 | 2016-04-22 11:18:35 |
| 3998 | 2073 | 3 | 2016-04-22 11:19:09 |
| 3999 | 2072 | 1 | 2016-04-22 11:37:22 |
| 4000 | 2073 | 1 | 2016-04-22 12:07:48 |
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;