Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 9,601–9,625 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 9601 | 4899 | 1 | 2017-11-28 12:37:13 |
| 9602 | 4900 | 3 | 2017-11-28 14:30:40 |
| 9603 | 4900 | 1 | 2017-11-28 15:15:05 |
| 9604 | 4901 | 2 | 2017-11-29 13:33:03 |
| 9605 | 4901 | 3 | 2017-11-29 14:28:42 |
| 9606 | 4901 | 2 | 2017-11-29 15:44:56 |
| 9607 | 4901 | 3 | 2017-11-29 16:18:00 |
| 9608 | 4903 | 2 | 2017-12-01 11:57:18 |
| 9609 | 4905 | 2 | 2017-12-01 12:01:56 |
| 9610 | 4902 | 2 | 2017-12-01 12:04:35 |
| 9611 | 4904 | 1 | 2017-12-01 12:10:28 |
| 9612 | 4910 | 1 | 2017-12-01 12:17:38 |
| 9613 | 4908 | 1 | 2017-12-01 12:18:32 |
| 9614 | 4909 | 1 | 2017-12-01 12:22:58 |
| 9615 | 4907 | 2 | 2017-12-01 12:26:39 |
| 9616 | 4904 | 3 | 2017-12-01 12:37:46 |
| 9617 | 4907 | 3 | 2017-12-01 13:17:25 |
| 9618 | 4904 | 1 | 2017-12-01 13:31:54 |
| 9619 | 4909 | 2 | 2017-12-01 13:36:55 |
| 9620 | 4907 | 1 | 2017-12-01 13:43:35 |
| 9621 | 4837 | 2 | 2017-12-04 11:07:37 |
| 9622 | 4838 | 2 | 2017-12-04 11:12:16 |
| 9623 | 4912 | 2 | 2017-12-06 11:39:49 |
| 9624 | 4913 | 2 | 2017-12-06 11:41:06 |
| 9625 | 4912 | 3 | 2017-12-06 12:33:55 |
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;