Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 4,201–4,225 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 4201 | 2095 | 3 | 2016-05-17 14:25:10 |
| 4202 | 2094 | 3 | 2016-05-17 14:40:41 |
| 4203 | 2093 | 3 | 2016-05-17 14:54:50 |
| 4204 | 2093 | 1 | 2016-05-17 15:40:51 |
| 4205 | 2052 | 2 | 2016-05-18 10:27:54 |
| 4206 | 2051 | 2 | 2016-05-18 10:30:23 |
| 4207 | 2052 | 1 | 2016-05-18 11:10:25 |
| 4208 | 2278 | 2 | 2016-05-18 11:38:32 |
| 4209 | 2279 | 2 | 2016-05-18 11:45:06 |
| 4210 | 2051 | 1 | 2016-05-18 12:01:24 |
| 4211 | 2198 | 1 | 2016-05-18 12:02:08 |
| 4212 | 2199 | 1 | 2016-05-18 12:05:23 |
| 4213 | 2052 | 2 | 2016-05-18 12:39:35 |
| 4214 | 2278 | 1 | 2016-05-18 12:53:57 |
| 4215 | 2279 | 1 | 2016-05-18 12:57:12 |
| 4216 | 2199 | 2 | 2016-05-18 13:02:25 |
| 4217 | 2198 | 2 | 2016-05-18 13:07:26 |
| 4218 | 2051 | 2 | 2016-05-18 13:18:56 |
| 4219 | 2278 | 3 | 2016-05-18 13:26:37 |
| 4220 | 2198 | 3 | 2016-05-18 13:59:42 |
| 4221 | 2199 | 3 | 2016-05-18 14:09:59 |
| 4222 | 2279 | 3 | 2016-05-18 14:22:38 |
| 4223 | 2280 | 2 | 2016-05-18 14:43:58 |
| 4224 | 2281 | 2 | 2016-05-18 14:56:33 |
| 4225 | 2263 | 2 | 2016-05-20 10:44:07 |
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;