Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 5,876–5,900 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 5876 | 2944 | 2 | 2016-11-06 16:44:44 |
| 5877 | 2945 | 2 | 2016-11-06 16:46:47 |
| 5878 | 2945 | 3 | 2016-11-06 17:15:18 |
| 5879 | 2944 | 3 | 2016-11-06 17:20:16 |
| 5880 | 3002 | 2 | 2016-11-07 09:26:11 |
| 5881 | 3001 | 2 | 2016-11-07 09:34:03 |
| 5882 | 3000 | 2 | 2016-11-07 09:35:53 |
| 5883 | 3001 | 3 | 2016-11-07 10:32:24 |
| 5884 | 3002 | 3 | 2016-11-07 10:44:01 |
| 5885 | 3000 | 3 | 2016-11-07 11:02:37 |
| 5886 | 2991 | 2 | 2016-11-08 11:45:21 |
| 5887 | 2992 | 2 | 2016-11-08 11:48:24 |
| 5888 | 3008 | 3 | 2016-11-08 11:55:57 |
| 5889 | 3005 | 1 | 2016-11-08 12:01:52 |
| 5890 | 3006 | 1 | 2016-11-08 12:02:02 |
| 5891 | 3007 | 1 | 2016-11-08 12:02:41 |
| 5892 | 3004 | 2 | 2016-11-09 12:02:59 |
| 5893 | 3003 | 2 | 2016-11-09 12:16:41 |
| 5894 | 3003 | 3 | 2016-11-09 12:45:16 |
| 5895 | 3004 | 3 | 2016-11-09 13:32:18 |
| 5896 | 3003 | 1 | 2016-11-09 14:03:27 |
| 5897 | 3004 | 1 | 2016-11-09 14:38:25 |
| 5898 | 3003 | 2 | 2016-11-09 15:31:56 |
| 5899 | 3004 | 2 | 2016-11-09 15:58:58 |
| 5900 | 2997 | 2 | 2016-11-10 12:01:42 |
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;