Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 18,151–18,175 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 18151 | 9373 | 1 | 2019-11-08 10:28:26 |
| 18152 | 9378 | 1 | 2019-11-08 12:51:09 |
| 18153 | 9291 | 1 | 2019-11-08 13:07:48 |
| 18154 | 9372 | 3 | 2019-11-08 13:52:59 |
| 18155 | 9371 | 2 | 2019-11-08 13:58:41 |
| 18156 | 9378 | 3 | 2019-11-08 14:00:47 |
| 18157 | 9372 | 1 | 2019-11-08 14:39:41 |
| 18158 | 9371 | 3 | 2019-11-08 15:04:31 |
| 18159 | 9372 | 2 | 2019-11-08 15:20:26 |
| 18160 | 9348 | 2 | 2019-11-08 15:54:12 |
| 18161 | 9349 | 3 | 2019-11-08 15:56:13 |
| 18162 | 9371 | 2 | 2019-11-08 16:38:15 |
| 18163 | 9186 | 3 | 2019-11-09 11:40:48 |
| 18164 | 9191 | 3 | 2019-11-09 11:42:29 |
| 18165 | 9208 | 3 | 2019-11-09 11:42:34 |
| 18166 | 9195 | 3 | 2019-11-09 11:43:10 |
| 18167 | 9198 | 3 | 2019-11-09 11:43:32 |
| 18168 | 9220 | 3 | 2019-11-09 11:43:45 |
| 18169 | 9189 | 3 | 2019-11-09 11:44:24 |
| 18170 | 9210 | 3 | 2019-11-09 11:44:56 |
| 18171 | 9193 | 3 | 2019-11-09 11:46:08 |
| 18172 | 9190 | 3 | 2019-11-09 11:46:49 |
| 18173 | 9187 | 3 | 2019-11-09 11:48:18 |
| 18174 | 9211 | 3 | 2019-11-09 11:48:40 |
| 18175 | 9192 | 3 | 2019-11-09 11:49:11 |
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;