Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 10,151–10,175 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 10151 | 5255 | 1 | 2018-02-08 09:34:54 |
| 10152 | 5216 | 2 | 2018-02-08 11:23:07 |
| 10153 | 5216 | 3 | 2018-02-08 12:13:15 |
| 10154 | 5212 | 2 | 2018-02-08 12:50:57 |
| 10155 | 5213 | 2 | 2018-02-08 12:55:40 |
| 10156 | 5213 | 3 | 2018-02-08 13:44:43 |
| 10157 | 5257 | 2 | 2018-02-08 13:45:11 |
| 10158 | 5216 | 1 | 2018-02-08 13:46:28 |
| 10159 | 5258 | 2 | 2018-02-08 13:52:34 |
| 10160 | 5257 | 3 | 2018-02-08 14:54:05 |
| 10161 | 5213 | 1 | 2018-02-08 15:12:16 |
| 10162 | 5258 | 3 | 2018-02-08 15:23:52 |
| 10163 | 5257 | 2 | 2018-02-08 15:32:06 |
| 10164 | 5258 | 2 | 2018-02-08 16:38:51 |
| 10165 | 5257 | 1 | 2018-02-08 16:55:10 |
| 10166 | 5253 | 2 | 2018-02-09 12:14:12 |
| 10167 | 5254 | 2 | 2018-02-09 12:14:41 |
| 10168 | 5252 | 2 | 2018-02-09 13:22:19 |
| 10169 | 5267 | 3 | 2018-02-11 13:08:20 |
| 10170 | 5267 | 2 | 2018-02-11 14:06:37 |
| 10171 | 5267 | 1 | 2018-02-11 14:33:47 |
| 10172 | 4956 | 3 | 2018-02-11 14:37:09 |
| 10173 | 4959 | 3 | 2018-02-11 14:38:14 |
| 10174 | 4958 | 3 | 2018-02-11 14:40:52 |
| 10175 | 4957 | 1 | 2018-02-11 14:42:49 |
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;