Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 14,276–14,300 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 14276 | 7335 | 1 | 2018-12-22 10:35:09 |
| 14277 | 7338 | 1 | 2018-12-22 10:35:57 |
| 14278 | 7239 | 2 | 2018-12-22 11:18:53 |
| 14279 | 7237 | 2 | 2018-12-22 11:21:09 |
| 14280 | 7336 | 2 | 2018-12-22 11:21:45 |
| 14281 | 7238 | 2 | 2018-12-22 11:23:49 |
| 14282 | 7240 | 2 | 2018-12-22 11:29:49 |
| 14283 | 7339 | 2 | 2018-12-22 11:46:41 |
| 14284 | 7335 | 2 | 2018-12-22 11:51:39 |
| 14285 | 7337 | 2 | 2018-12-22 11:56:18 |
| 14286 | 7338 | 2 | 2018-12-22 12:04:40 |
| 14287 | 7239 | 1 | 2018-12-22 12:19:58 |
| 14288 | 7240 | 1 | 2018-12-22 12:22:43 |
| 14289 | 7238 | 1 | 2018-12-22 12:25:08 |
| 14290 | 7237 | 1 | 2018-12-22 12:49:13 |
| 14291 | 7342 | 2 | 2018-12-23 13:39:01 |
| 14292 | 7341 | 2 | 2018-12-23 13:43:38 |
| 14293 | 7340 | 2 | 2018-12-23 13:54:35 |
| 14294 | 7284 | 3 | 2018-12-23 13:55:14 |
| 14295 | 7202 | 3 | 2018-12-23 13:55:36 |
| 14296 | 7343 | 2 | 2018-12-23 14:19:19 |
| 14297 | 7202 | 2 | 2018-12-23 14:34:56 |
| 14298 | 7284 | 2 | 2018-12-23 14:51:37 |
| 14299 | 7343 | 3 | 2018-12-23 15:18:15 |
| 14300 | 7284 | 3 | 2018-12-23 15:51:06 |
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;