Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 18,201–18,225 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 18201 | 9204 | 3 | 2019-11-09 11:59:13 |
| 18202 | 9202 | 3 | 2019-11-09 12:00:18 |
| 18203 | 9209 | 3 | 2019-11-09 12:01:03 |
| 18204 | 9222 | 3 | 2019-11-09 12:01:41 |
| 18205 | 9225 | 3 | 2019-11-09 12:02:17 |
| 18206 | 9218 | 3 | 2019-11-09 12:03:10 |
| 18207 | 9223 | 3 | 2019-11-09 12:06:07 |
| 18208 | 9191 | 1 | 2019-11-09 12:09:39 |
| 18209 | 9208 | 1 | 2019-11-09 12:13:24 |
| 18210 | 9190 | 1 | 2019-11-09 12:18:18 |
| 18211 | 9197 | 1 | 2019-11-09 12:18:28 |
| 18212 | 9214 | 1 | 2019-11-09 12:22:16 |
| 18213 | 9221 | 1 | 2019-11-09 12:22:45 |
| 18214 | 9212 | 1 | 2019-11-09 12:23:25 |
| 18215 | 9189 | 1 | 2019-11-09 12:26:01 |
| 18216 | 9225 | 1 | 2019-11-09 12:29:42 |
| 18217 | 9215 | 1 | 2019-11-09 12:31:58 |
| 18218 | 9202 | 1 | 2019-11-09 12:32:03 |
| 18219 | 9187 | 1 | 2019-11-09 12:32:25 |
| 18220 | 9200 | 1 | 2019-11-09 12:35:47 |
| 18221 | 9185 | 1 | 2019-11-09 12:38:08 |
| 18222 | 9186 | 1 | 2019-11-09 12:39:09 |
| 18223 | 9220 | 1 | 2019-11-09 12:42:29 |
| 18224 | 9206 | 1 | 2019-11-09 12:42:51 |
| 18225 | 9224 | 1 | 2019-11-09 12:46:57 |
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;