Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 8,201–8,225 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 8201 | 4239 | 3 | 2017-07-14 13:12:42 |
| 8202 | 4251 | 1 | 2017-07-14 13:13:54 |
| 8203 | 4250 | 1 | 2017-07-14 13:44:49 |
| 8204 | 4240 | 2 | 2017-07-14 13:54:15 |
| 8205 | 4239 | 2 | 2017-07-14 14:15:54 |
| 8206 | 4240 | 3 | 2017-07-14 14:25:54 |
| 8207 | 4240 | 2 | 2017-07-14 15:44:06 |
| 8208 | 4252 | 2 | 2017-07-15 10:09:34 |
| 8209 | 4253 | 2 | 2017-07-15 10:12:15 |
| 8210 | 4254 | 2 | 2017-07-15 13:46:02 |
| 8211 | 4254 | 1 | 2017-07-15 14:18:03 |
| 8212 | 4254 | 2 | 2017-07-15 15:11:21 |
| 8213 | 4254 | 1 | 2017-07-15 16:01:37 |
| 8214 | 4254 | 3 | 2017-07-15 17:20:49 |
| 8215 | 4255 | 2 | 2017-07-16 11:02:04 |
| 8216 | 4258 | 2 | 2017-07-16 11:03:51 |
| 8217 | 4256 | 2 | 2017-07-16 11:04:18 |
| 8218 | 4257 | 2 | 2017-07-16 11:07:35 |
| 8219 | 4249 | 2 | 2017-07-16 11:23:57 |
| 8220 | 4261 | 2 | 2017-07-16 12:06:24 |
| 8221 | 4260 | 2 | 2017-07-16 12:08:40 |
| 8222 | 4262 | 2 | 2017-07-16 12:17:20 |
| 8223 | 4259 | 2 | 2017-07-16 12:17:44 |
| 8224 | 4263 | 2 | 2017-07-16 12:22:10 |
| 8225 | 4249 | 1 | 2017-07-16 12:46:53 |
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;