Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 1,451–1,475 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 1451 | 846 | 3 | 2015-07-24 09:17:37 |
| 1452 | 845 | 3 | 2015-07-24 09:18:27 |
| 1453 | 847 | 2 | 2015-07-24 09:48:56 |
| 1454 | 845 | 2 | 2015-07-24 09:51:31 |
| 1455 | 846 | 2 | 2015-07-24 09:59:52 |
| 1456 | 847 | 3 | 2015-07-24 10:21:39 |
| 1457 | 848 | 2 | 2015-07-24 10:51:49 |
| 1458 | 849 | 2 | 2015-07-24 10:51:59 |
| 1459 | 843 | 2 | 2015-07-24 11:34:13 |
| 1460 | 844 | 2 | 2015-07-24 11:34:21 |
| 1461 | 840 | 3 | 2015-07-24 11:34:39 |
| 1462 | 842 | 3 | 2015-07-24 11:37:23 |
| 1463 | 841 | 3 | 2015-07-24 11:37:54 |
| 1464 | 849 | 1 | 2015-07-24 11:47:28 |
| 1465 | 843 | 1 | 2015-07-24 12:36:36 |
| 1466 | 849 | 3 | 2015-07-24 12:46:57 |
| 1467 | 852 | 2 | 2015-07-25 10:29:13 |
| 1468 | 855 | 2 | 2015-07-25 10:32:45 |
| 1469 | 856 | 2 | 2015-07-25 10:33:44 |
| 1470 | 853 | 2 | 2015-07-25 10:37:29 |
| 1471 | 854 | 2 | 2015-07-25 10:38:13 |
| 1472 | 854 | 1 | 2015-07-25 11:05:26 |
| 1473 | 852 | 3 | 2015-07-25 11:09:02 |
| 1474 | 856 | 1 | 2015-07-25 11:19:00 |
| 1475 | 855 | 1 | 2015-07-25 11:22:36 |
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;