Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 17,451–17,475 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 17451 | 8822 | 1 | 2019-08-28 09:35:06 |
| 17452 | 8823 | 1 | 2019-08-28 09:35:32 |
| 17453 | 8823 | 3 | 2019-08-28 10:32:04 |
| 17454 | 8822 | 3 | 2019-08-28 10:32:31 |
| 17455 | 8840 | 2 | 2019-08-28 10:34:44 |
| 17456 | 8842 | 2 | 2019-08-28 10:35:26 |
| 17457 | 8843 | 2 | 2019-08-28 10:39:49 |
| 17458 | 8841 | 2 | 2019-08-28 10:42:15 |
| 17459 | 8844 | 3 | 2019-08-28 11:12:30 |
| 17460 | 8768 | 2 | 2019-08-28 11:13:54 |
| 17461 | 8767 | 2 | 2019-08-28 11:16:27 |
| 17462 | 8841 | 3 | 2019-08-28 11:19:18 |
| 17463 | 8842 | 3 | 2019-08-28 11:26:09 |
| 17464 | 8801 | 2 | 2019-08-28 11:33:33 |
| 17465 | 8803 | 2 | 2019-08-28 11:35:03 |
| 17466 | 8802 | 2 | 2019-08-28 11:39:13 |
| 17467 | 8840 | 3 | 2019-08-28 11:45:07 |
| 17468 | 8804 | 2 | 2019-08-28 11:45:36 |
| 17469 | 8843 | 3 | 2019-08-28 11:57:50 |
| 17470 | 8844 | 1 | 2019-08-28 11:59:35 |
| 17471 | 8844 | 2 | 2019-08-28 12:43:06 |
| 17472 | 8831 | 1 | 2019-08-28 13:42:17 |
| 17473 | 8832 | 1 | 2019-08-28 13:52:45 |
| 17474 | 8831 | 3 | 2019-08-28 14:23:34 |
| 17475 | 8831 | 2 | 2019-08-28 15:03:00 |
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;