Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 501–525 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 501 | 63 | 1 | 2015-04-25 13:23:04 |
| 502 | 44 | 1 | 2015-04-25 13:23:10 |
| 503 | 35 | 1 | 2015-04-25 13:24:02 |
| 504 | 51 | 1 | 2015-04-25 13:26:29 |
| 505 | 41 | 1 | 2015-04-25 13:26:57 |
| 506 | 299 | 3 | 2015-04-25 13:27:07 |
| 507 | 40 | 1 | 2015-04-25 13:28:30 |
| 508 | 22 | 1 | 2015-04-25 13:32:38 |
| 509 | 64 | 1 | 2015-04-25 13:33:10 |
| 510 | 14 | 1 | 2015-04-25 13:33:27 |
| 511 | 20 | 1 | 2015-04-25 13:37:46 |
| 512 | 17 | 1 | 2015-04-25 13:38:55 |
| 513 | 25 | 1 | 2015-04-25 13:39:43 |
| 514 | 13 | 1 | 2015-04-25 13:39:52 |
| 515 | 53 | 1 | 2015-04-25 13:42:16 |
| 516 | 43 | 1 | 2015-04-25 13:43:50 |
| 517 | 61 | 1 | 2015-04-25 13:45:12 |
| 518 | 12 | 1 | 2015-04-25 13:46:43 |
| 519 | 33 | 1 | 2015-04-25 13:52:14 |
| 520 | 55 | 1 | 2015-04-25 13:57:25 |
| 521 | 52 | 1 | 2015-04-25 14:17:41 |
| 522 | 54 | 1 | 2015-04-25 14:19:16 |
| 523 | 314 | 2 | 2015-04-26 09:16:03 |
| 524 | 261 | 3 | 2015-04-26 09:20:35 |
| 525 | 260 | 3 | 2015-04-26 09:21:06 |
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;