Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 5,851–5,875 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 5851 | 2943 | 1 | 2016-10-30 17:05:02 |
| 5852 | 2865 | 3 | 2016-10-30 17:08:43 |
| 5853 | 2943 | 3 | 2016-10-30 17:44:20 |
| 5854 | 2951 | 2 | 2016-11-02 09:20:45 |
| 5855 | 2950 | 2 | 2016-11-02 09:23:55 |
| 5856 | 2951 | 3 | 2016-11-02 10:00:41 |
| 5857 | 2950 | 3 | 2016-11-02 10:40:24 |
| 5858 | 2937 | 3 | 2016-11-04 16:56:04 |
| 5859 | 2938 | 3 | 2016-11-04 16:57:33 |
| 5860 | 2939 | 3 | 2016-11-04 17:10:57 |
| 5861 | 2996 | 2 | 2016-11-05 11:05:36 |
| 5862 | 2995 | 2 | 2016-11-05 11:17:17 |
| 5863 | 2996 | 1 | 2016-11-05 11:58:05 |
| 5864 | 2995 | 1 | 2016-11-05 12:11:23 |
| 5865 | 2995 | 2 | 2016-11-05 12:56:51 |
| 5866 | 2996 | 2 | 2016-11-05 13:11:36 |
| 5867 | 2995 | 1 | 2016-11-05 14:00:45 |
| 5868 | 2996 | 1 | 2016-11-05 14:44:27 |
| 5869 | 2940 | 2 | 2016-11-06 11:20:06 |
| 5870 | 2940 | 1 | 2016-11-06 12:09:57 |
| 5871 | 2940 | 2 | 2016-11-06 12:40:12 |
| 5872 | 2944 | 2 | 2016-11-06 14:48:26 |
| 5873 | 2945 | 2 | 2016-11-06 14:52:54 |
| 5874 | 2945 | 3 | 2016-11-06 15:26:03 |
| 5875 | 2944 | 3 | 2016-11-06 16:01:32 |
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;