Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 301–325 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 301 | 284 | 2 | 2015-04-17 12:40:09 |
| 302 | 284 | 3 | 2015-04-17 13:53:10 |
| 303 | 253 | 3 | 2015-04-17 17:11:58 |
| 304 | 252 | 1 | 2015-04-17 17:19:53 |
| 305 | 290 | 2 | 2015-04-18 10:58:23 |
| 306 | 289 | 2 | 2015-04-18 11:03:44 |
| 307 | 293 | 2 | 2015-04-18 11:54:31 |
| 308 | 292 | 2 | 2015-04-18 12:05:01 |
| 309 | 293 | 3 | 2015-04-18 12:23:28 |
| 310 | 292 | 3 | 2015-04-18 13:26:15 |
| 311 | 293 | 1 | 2015-04-18 13:40:45 |
| 312 | 293 | 3 | 2015-04-18 14:27:44 |
| 313 | 292 | 1 | 2015-04-18 14:58:44 |
| 314 | 292 | 3 | 2015-04-18 16:24:44 |
| 315 | 287 | 2 | 2015-04-19 11:13:53 |
| 316 | 285 | 2 | 2015-04-19 11:13:58 |
| 317 | 288 | 2 | 2015-04-19 11:21:42 |
| 318 | 286 | 3 | 2015-04-19 11:23:21 |
| 319 | 287 | 1 | 2015-04-19 11:42:57 |
| 320 | 285 | 1 | 2015-04-19 12:03:44 |
| 321 | 288 | 1 | 2015-04-19 12:07:26 |
| 322 | 286 | 2 | 2015-04-19 12:27:39 |
| 323 | 287 | 2 | 2015-04-19 12:39:54 |
| 324 | 285 | 2 | 2015-04-19 13:24:27 |
| 325 | 288 | 2 | 2015-04-19 13:34:20 |
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;