Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 9,676–9,700 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 9676 | 4939 | 3 | 2017-12-12 15:35:04 |
| 9677 | 4888 | 2 | 2017-12-13 10:35:16 |
| 9678 | 4889 | 2 | 2017-12-13 10:38:49 |
| 9679 | 4888 | 3 | 2017-12-13 11:32:18 |
| 9680 | 4889 | 3 | 2017-12-13 12:02:44 |
| 9681 | 4892 | 1 | 2017-12-14 10:36:48 |
| 9682 | 4946 | 2 | 2017-12-15 12:04:10 |
| 9683 | 4944 | 2 | 2017-12-15 12:11:16 |
| 9684 | 4945 | 2 | 2017-12-15 12:12:39 |
| 9685 | 4946 | 1 | 2017-12-15 12:56:00 |
| 9686 | 4933 | 2 | 2017-12-16 09:25:43 |
| 9687 | 4934 | 2 | 2017-12-16 09:32:53 |
| 9688 | 4933 | 3 | 2017-12-16 09:56:32 |
| 9689 | 4934 | 3 | 2017-12-16 10:07:42 |
| 9690 | 4934 | 1 | 2017-12-16 10:36:50 |
| 9691 | 4933 | 1 | 2017-12-16 10:55:29 |
| 9692 | 4928 | 2 | 2017-12-16 12:31:57 |
| 9693 | 4928 | 3 | 2017-12-16 13:00:10 |
| 9694 | 4928 | 2 | 2017-12-16 13:41:24 |
| 9695 | 4928 | 1 | 2017-12-16 14:36:37 |
| 9696 | 4948 | 3 | 2017-12-17 09:18:10 |
| 9697 | 4948 | 1 | 2017-12-17 09:47:04 |
| 9698 | 4948 | 3 | 2017-12-17 10:28:46 |
| 9699 | 4914 | 2 | 2017-12-17 11:32:29 |
| 9700 | 4940 | 3 | 2017-12-17 11:34:27 |
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;