Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 18,176–18,200 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 18176 | 9207 | 3 | 2019-11-09 11:50:24 |
| 18177 | 9201 | 3 | 2019-11-09 11:50:26 |
| 18178 | 9221 | 3 | 2019-11-09 11:50:32 |
| 18179 | 9197 | 3 | 2019-11-09 11:50:42 |
| 18180 | 9205 | 3 | 2019-11-09 11:50:50 |
| 18181 | 9219 | 3 | 2019-11-09 11:50:55 |
| 18182 | 9188 | 3 | 2019-11-09 11:51:00 |
| 18183 | 9212 | 3 | 2019-11-09 11:51:12 |
| 18184 | 9224 | 3 | 2019-11-09 11:51:46 |
| 18185 | 9200 | 3 | 2019-11-09 11:51:55 |
| 18186 | 9206 | 3 | 2019-11-09 11:52:15 |
| 18187 | 9324 | 1 | 2019-11-09 11:52:22 |
| 18188 | 9184 | 3 | 2019-11-09 11:52:25 |
| 18189 | 9213 | 3 | 2019-11-09 11:52:30 |
| 18190 | 9185 | 3 | 2019-11-09 11:52:45 |
| 18191 | 9215 | 3 | 2019-11-09 11:53:02 |
| 18192 | 9217 | 3 | 2019-11-09 11:53:41 |
| 18193 | 9323 | 1 | 2019-11-09 11:53:53 |
| 18194 | 9226 | 3 | 2019-11-09 11:54:37 |
| 18195 | 9214 | 3 | 2019-11-09 11:55:03 |
| 18196 | 9216 | 3 | 2019-11-09 11:55:21 |
| 18197 | 9194 | 3 | 2019-11-09 11:55:29 |
| 18198 | 9196 | 3 | 2019-11-09 11:57:47 |
| 18199 | 9203 | 3 | 2019-11-09 11:59:03 |
| 18200 | 9199 | 3 | 2019-11-09 11:59:07 |
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;