Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 10,276–10,300 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 10276 | 5321 | 2 | 2018-02-25 11:21:17 |
| 10277 | 5237 | 3 | 2018-02-25 11:27:43 |
| 10278 | 5299 | 2 | 2018-02-25 11:35:05 |
| 10279 | 5322 | 3 | 2018-02-25 11:56:32 |
| 10280 | 5324 | 3 | 2018-02-25 12:01:03 |
| 10281 | 5323 | 3 | 2018-02-25 12:04:23 |
| 10282 | 5325 | 3 | 2018-02-25 12:05:18 |
| 10283 | 5237 | 2 | 2018-02-25 12:27:59 |
| 10284 | 5322 | 1 | 2018-02-25 12:43:14 |
| 10285 | 5299 | 1 | 2018-02-25 12:48:03 |
| 10286 | 5323 | 1 | 2018-02-25 12:48:24 |
| 10287 | 5325 | 1 | 2018-02-25 12:56:01 |
| 10288 | 5324 | 1 | 2018-02-25 13:00:14 |
| 10289 | 5322 | 2 | 2018-02-25 13:09:44 |
| 10290 | 5299 | 2 | 2018-02-25 13:24:01 |
| 10291 | 5324 | 2 | 2018-02-25 13:39:27 |
| 10292 | 5325 | 2 | 2018-02-25 14:12:13 |
| 10293 | 5323 | 2 | 2018-02-25 14:20:04 |
| 10294 | 5327 | 2 | 2018-02-26 10:31:04 |
| 10295 | 5326 | 2 | 2018-02-26 10:33:55 |
| 10296 | 5328 | 2 | 2018-02-26 10:34:53 |
| 10297 | 5328 | 1 | 2018-02-26 11:26:23 |
| 10298 | 5326 | 1 | 2018-02-26 11:31:49 |
| 10299 | 5326 | 2 | 2018-02-26 12:01:27 |
| 10300 | 5327 | 3 | 2018-02-26 12:05: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;