Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 251–275 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 251 | 267 | 2 | 2015-04-10 11:21:30 |
| 252 | 269 | 3 | 2015-04-10 11:31:13 |
| 253 | 268 | 1 | 2015-04-10 11:54:47 |
| 254 | 269 | 1 | 2015-04-10 12:25:39 |
| 255 | 268 | 2 | 2015-04-10 13:03:21 |
| 256 | 269 | 2 | 2015-04-10 13:18:21 |
| 257 | 268 | 3 | 2015-04-10 13:44:06 |
| 258 | 270 | 1 | 2015-04-10 14:18:06 |
| 259 | 270 | 3 | 2015-04-10 15:37:44 |
| 260 | 270 | 2 | 2015-04-10 17:11:52 |
| 261 | 233 | 1 | 2015-04-11 10:09:45 |
| 262 | 233 | 3 | 2015-04-11 11:16:16 |
| 263 | 233 | 1 | 2015-04-11 12:28:36 |
| 264 | 274 | 2 | 2015-04-11 16:31:39 |
| 265 | 273 | 1 | 2015-04-11 16:33:24 |
| 266 | 271 | 1 | 2015-04-11 16:34:39 |
| 267 | 272 | 1 | 2015-04-11 16:34:50 |
| 268 | 272 | 2 | 2015-04-11 17:13:10 |
| 269 | 274 | 3 | 2015-04-11 17:26:51 |
| 270 | 273 | 2 | 2015-04-11 17:39:43 |
| 271 | 240 | 2 | 2015-04-12 14:38:43 |
| 272 | 240 | 1 | 2015-04-12 16:06:37 |
| 273 | 275 | 2 | 2015-04-12 16:10:15 |
| 274 | 277 | 2 | 2015-04-12 16:14:34 |
| 275 | 276 | 1 | 2015-04-12 16:15:46 |
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;