Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 5,601–5,625 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 5601 | 2854 | 3 | 2016-10-05 14:37:38 |
| 5602 | 2868 | 1 | 2016-10-05 14:46:10 |
| 5603 | 2873 | 2 | 2016-10-06 12:36:06 |
| 5604 | 2874 | 2 | 2016-10-06 12:41:25 |
| 5605 | 2876 | 2 | 2016-10-06 12:50:29 |
| 5606 | 2875 | 2 | 2016-10-06 12:50:47 |
| 5607 | 2875 | 3 | 2016-10-06 13:17:42 |
| 5608 | 2876 | 3 | 2016-10-06 13:31:58 |
| 5609 | 2873 | 3 | 2016-10-06 13:58:20 |
| 5610 | 2874 | 3 | 2016-10-06 14:13:21 |
| 5611 | 2875 | 1 | 2016-10-06 14:18:03 |
| 5612 | 2876 | 1 | 2016-10-06 14:31:47 |
| 5613 | 2873 | 1 | 2016-10-06 15:13:03 |
| 5614 | 2874 | 1 | 2016-10-06 15:41:14 |
| 5615 | 2878 | 1 | 2016-10-07 15:07:13 |
| 5616 | 2877 | 1 | 2016-10-07 15:07:45 |
| 5617 | 2883 | 2 | 2016-10-08 09:17:45 |
| 5618 | 2882 | 2 | 2016-10-08 09:24:47 |
| 5619 | 2882 | 1 | 2016-10-08 10:32:51 |
| 5620 | 2883 | 1 | 2016-10-08 10:48:20 |
| 5621 | 2885 | 3 | 2016-10-08 14:06:56 |
| 5622 | 2886 | 2 | 2016-10-08 14:09:43 |
| 5623 | 2884 | 2 | 2016-10-08 14:17:20 |
| 5624 | 2885 | 1 | 2016-10-08 15:22:08 |
| 5625 | 2885 | 3 | 2016-10-08 16:06:43 |
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;