Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 226–250 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 226 | 251 | 2 | 2015-04-05 14:36:49 |
| 227 | 250 | 2 | 2015-04-05 14:43:54 |
| 228 | 248 | 2 | 2015-04-05 14:59:57 |
| 229 | 256 | 1 | 2015-04-06 11:15:15 |
| 230 | 257 | 1 | 2015-04-06 11:16:42 |
| 231 | 258 | 1 | 2015-04-06 11:33:52 |
| 232 | 259 | 1 | 2015-04-06 11:33:59 |
| 233 | 258 | 2 | 2015-04-06 12:09:33 |
| 234 | 257 | 3 | 2015-04-06 12:26:21 |
| 235 | 259 | 2 | 2015-04-06 12:29:22 |
| 236 | 256 | 3 | 2015-04-06 12:43:20 |
| 237 | 259 | 3 | 2015-04-06 13:12:34 |
| 238 | 258 | 3 | 2015-04-06 13:18:50 |
| 239 | 216 | 2 | 2015-04-07 10:53:07 |
| 240 | 216 | 3 | 2015-04-07 11:59:18 |
| 241 | 106 | 3 | 2015-04-08 14:18:53 |
| 242 | 106 | 2 | 2015-04-08 15:20:45 |
| 243 | 263 | 1 | 2015-04-09 10:34:36 |
| 244 | 262 | 2 | 2015-04-09 10:36:51 |
| 245 | 265 | 2 | 2015-04-09 10:38:36 |
| 246 | 264 | 2 | 2015-04-09 10:38:55 |
| 247 | 263 | 3 | 2015-04-09 11:54:18 |
| 248 | 267 | 1 | 2015-04-10 10:04:42 |
| 249 | 269 | 2 | 2015-04-10 10:36:30 |
| 250 | 268 | 3 | 2015-04-10 10:42:15 |
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;