Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 5,076–5,100 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 5076 | 2577 | 2 | 2016-07-31 11:11:44 |
| 5077 | 2575 | 2 | 2016-07-31 11:14:09 |
| 5078 | 2578 | 2 | 2016-07-31 11:18:45 |
| 5079 | 2576 | 2 | 2016-07-31 11:21:03 |
| 5080 | 2580 | 2 | 2016-07-31 11:34:43 |
| 5081 | 2579 | 2 | 2016-07-31 11:37:21 |
| 5082 | 2578 | 3 | 2016-07-31 11:45:32 |
| 5083 | 2453 | 3 | 2016-07-31 11:47:28 |
| 5084 | 2577 | 3 | 2016-07-31 12:14:55 |
| 5085 | 2445 | 3 | 2016-07-31 12:18:47 |
| 5086 | 2580 | 1 | 2016-07-31 12:20:05 |
| 5087 | 2575 | 3 | 2016-07-31 12:23:33 |
| 5088 | 2579 | 3 | 2016-07-31 12:37:50 |
| 5089 | 2576 | 3 | 2016-07-31 12:52:21 |
| 5090 | 2550 | 2 | 2016-07-31 13:16:48 |
| 5091 | 2445 | 1 | 2016-07-31 13:18:14 |
| 5092 | 2554 | 2 | 2016-07-31 13:19:58 |
| 5093 | 2552 | 2 | 2016-07-31 13:24:41 |
| 5094 | 2551 | 2 | 2016-07-31 13:26:51 |
| 5095 | 2553 | 2 | 2016-07-31 13:28:36 |
| 5096 | 2580 | 2 | 2016-07-31 13:31:11 |
| 5097 | 2553 | 1 | 2016-07-31 14:00:06 |
| 5098 | 2550 | 1 | 2016-07-31 14:03:52 |
| 5099 | 2580 | 1 | 2016-07-31 14:21:21 |
| 5100 | 2554 | 1 | 2016-07-31 14:33:09 |
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;