Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 1,201–1,225 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 1201 | 190 | 1 | 2015-06-30 13:59:34 |
| 1202 | 193 | 1 | 2015-06-30 14:00:31 |
| 1203 | 195 | 1 | 2015-06-30 14:00:34 |
| 1204 | 176 | 1 | 2015-06-30 14:00:41 |
| 1205 | 187 | 1 | 2015-06-30 14:01:03 |
| 1206 | 173 | 1 | 2015-06-30 14:02:11 |
| 1207 | 200 | 1 | 2015-06-30 14:04:32 |
| 1208 | 184 | 1 | 2015-06-30 14:04:59 |
| 1209 | 174 | 1 | 2015-06-30 14:05:42 |
| 1210 | 189 | 1 | 2015-06-30 14:06:07 |
| 1211 | 196 | 1 | 2015-06-30 14:06:17 |
| 1212 | 175 | 1 | 2015-06-30 14:08:26 |
| 1213 | 197 | 1 | 2015-06-30 14:08:31 |
| 1214 | 181 | 1 | 2015-06-30 14:09:10 |
| 1215 | 177 | 1 | 2015-06-30 14:10:17 |
| 1216 | 194 | 1 | 2015-06-30 14:11:12 |
| 1217 | 180 | 1 | 2015-06-30 14:11:50 |
| 1218 | 199 | 1 | 2015-06-30 14:12:50 |
| 1219 | 192 | 1 | 2015-06-30 14:13:29 |
| 1220 | 185 | 1 | 2015-06-30 14:13:37 |
| 1221 | 188 | 1 | 2015-06-30 14:14:50 |
| 1222 | 198 | 1 | 2015-06-30 14:15:12 |
| 1223 | 729 | 2 | 2015-07-01 09:20:46 |
| 1224 | 728 | 2 | 2015-07-01 09:33:38 |
| 1225 | 728 | 3 | 2015-07-01 10:05:22 |
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;