Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 12,326–12,350 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 12326 | 5614 | 2 | 2018-08-10 11:17:42 |
| 12327 | 5608 | 2 | 2018-08-10 11:18:55 |
| 12328 | 5607 | 2 | 2018-08-10 11:18:56 |
| 12329 | 5590 | 2 | 2018-08-10 11:21:23 |
| 12330 | 5603 | 2 | 2018-08-10 11:21:33 |
| 12331 | 5612 | 2 | 2018-08-10 11:22:59 |
| 12332 | 5595 | 2 | 2018-08-10 11:23:17 |
| 12333 | 5613 | 2 | 2018-08-10 11:23:19 |
| 12334 | 5622 | 2 | 2018-08-10 11:23:19 |
| 12335 | 5596 | 2 | 2018-08-10 11:23:36 |
| 12336 | 5631 | 2 | 2018-08-10 11:26:31 |
| 12337 | 5598 | 2 | 2018-08-10 11:26:32 |
| 12338 | 5593 | 2 | 2018-08-10 11:26:50 |
| 12339 | 5591 | 2 | 2018-08-10 11:27:10 |
| 12340 | 5606 | 2 | 2018-08-10 11:27:39 |
| 12341 | 5604 | 2 | 2018-08-10 11:27:49 |
| 12342 | 5600 | 2 | 2018-08-10 11:29:10 |
| 12343 | 5627 | 2 | 2018-08-10 11:31:46 |
| 12344 | 5626 | 2 | 2018-08-10 11:31:53 |
| 12345 | 5617 | 2 | 2018-08-10 11:33:08 |
| 12346 | 5628 | 2 | 2018-08-10 11:33:41 |
| 12347 | 6447 | 2 | 2018-08-10 13:22:50 |
| 12348 | 6356 | 2 | 2018-08-10 13:56:32 |
| 12349 | 6448 | 1 | 2018-08-10 14:31:45 |
| 12350 | 6447 | 1 | 2018-08-10 14:46:33 |
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;