Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 10,126–10,150 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 10126 | 5236 | 3 | 2018-01-29 14:21:27 |
| 10127 | 5236 | 1 | 2018-01-29 15:25:38 |
| 10128 | 5235 | 1 | 2018-01-29 15:41:13 |
| 10129 | 5204 | 2 | 2018-02-01 14:22:41 |
| 10130 | 5204 | 3 | 2018-02-01 15:47:44 |
| 10131 | 5204 | 1 | 2018-02-01 16:36:30 |
| 10132 | 5148 | 2 | 2018-02-02 11:53:50 |
| 10133 | 5149 | 1 | 2018-02-02 12:06:06 |
| 10134 | 5148 | 1 | 2018-02-02 12:58:48 |
| 10135 | 5244 | 2 | 2018-02-04 10:47:17 |
| 10136 | 5245 | 2 | 2018-02-04 11:04:55 |
| 10137 | 5246 | 2 | 2018-02-04 11:13:32 |
| 10138 | 5244 | 3 | 2018-02-04 11:46:31 |
| 10139 | 5244 | 2 | 2018-02-04 12:53:14 |
| 10140 | 5244 | 1 | 2018-02-04 14:26:07 |
| 10141 | 5241 | 3 | 2018-02-05 10:55:18 |
| 10142 | 5241 | 1 | 2018-02-05 11:52:08 |
| 10143 | 5248 | 1 | 2018-02-06 09:57:45 |
| 10144 | 5249 | 2 | 2018-02-06 09:57:55 |
| 10145 | 5249 | 1 | 2018-02-06 11:02:28 |
| 10146 | 5248 | 3 | 2018-02-06 11:20:11 |
| 10147 | 5249 | 3 | 2018-02-06 11:50:46 |
| 10148 | 5247 | 1 | 2018-02-07 11:18:07 |
| 10149 | 5247 | 3 | 2018-02-07 12:16:32 |
| 10150 | 5256 | 2 | 2018-02-08 09:32:05 |
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;