Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 351–375 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 351 | 27 | 1 | 2015-04-25 11:01:03 |
| 352 | 17 | 1 | 2015-04-25 11:01:11 |
| 353 | 18 | 1 | 2015-04-25 11:01:12 |
| 354 | 40 | 1 | 2015-04-25 11:01:20 |
| 355 | 48 | 1 | 2015-04-25 11:01:42 |
| 356 | 24 | 1 | 2015-04-25 11:02:14 |
| 357 | 62 | 1 | 2015-04-25 11:02:21 |
| 358 | 19 | 1 | 2015-04-25 11:02:26 |
| 359 | 42 | 1 | 2015-04-25 11:02:45 |
| 360 | 10 | 1 | 2015-04-25 11:02:58 |
| 361 | 41 | 1 | 2015-04-25 11:03:31 |
| 362 | 43 | 1 | 2015-04-25 11:03:31 |
| 363 | 13 | 1 | 2015-04-25 11:03:59 |
| 364 | 50 | 1 | 2015-04-25 11:04:28 |
| 365 | 299 | 1 | 2015-04-25 11:04:49 |
| 366 | 23 | 1 | 2015-04-25 11:05:04 |
| 367 | 39 | 1 | 2015-04-25 11:05:16 |
| 368 | 21 | 1 | 2015-04-25 11:05:22 |
| 369 | 11 | 1 | 2015-04-25 11:05:47 |
| 370 | 47 | 1 | 2015-04-25 11:05:58 |
| 371 | 64 | 1 | 2015-04-25 11:06:01 |
| 372 | 33 | 1 | 2015-04-25 11:06:40 |
| 373 | 12 | 1 | 2015-04-25 11:07:07 |
| 374 | 14 | 1 | 2015-04-25 11:07:21 |
| 375 | 51 | 1 | 2015-04-25 11:07:32 |
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;