Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 10,976–11,000 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 10976 | 5106 | 2 | 2018-05-04 12:50:47 |
| 10977 | 5110 | 2 | 2018-05-04 12:52:54 |
| 10978 | 5069 | 3 | 2018-05-04 13:06:13 |
| 10979 | 5086 | 3 | 2018-05-04 13:09:57 |
| 10980 | 5117 | 3 | 2018-05-04 13:14:33 |
| 10981 | 5085 | 3 | 2018-05-04 13:14:42 |
| 10982 | 5099 | 3 | 2018-05-04 13:17:49 |
| 10983 | 5121 | 3 | 2018-05-04 13:18:48 |
| 10984 | 5083 | 3 | 2018-05-04 13:22:48 |
| 10985 | 5104 | 3 | 2018-05-04 13:22:58 |
| 10986 | 5102 | 3 | 2018-05-04 13:23:42 |
| 10987 | 5098 | 3 | 2018-05-04 13:24:49 |
| 10988 | 5092 | 3 | 2018-05-04 13:26:52 |
| 10989 | 5080 | 3 | 2018-05-04 13:28:06 |
| 10990 | 5110 | 3 | 2018-05-04 13:28:30 |
| 10991 | 5114 | 3 | 2018-05-04 13:29:51 |
| 10992 | 5075 | 3 | 2018-05-04 13:31:15 |
| 10993 | 5089 | 3 | 2018-05-04 13:31:35 |
| 10994 | 5067 | 3 | 2018-05-04 13:32:33 |
| 10995 | 5091 | 3 | 2018-05-04 13:33:03 |
| 10996 | 5077 | 3 | 2018-05-04 13:33:48 |
| 10997 | 5106 | 3 | 2018-05-04 13:34:27 |
| 10998 | 5068 | 3 | 2018-05-04 13:35:15 |
| 10999 | 5082 | 3 | 2018-05-04 13:40:25 |
| 11000 | 5122 | 3 | 2018-05-04 13:44:28 |
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;