Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 19,251–19,275 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 19251 | 9686 | 1 | 2020-01-19 14:18:47 |
| 19252 | 9686 | 2 | 2020-01-19 15:03:13 |
| 19253 | 9686 | 3 | 2020-01-19 16:24:58 |
| 19254 | 9702 | 1 | 2020-01-20 12:45:23 |
| 19255 | 9702 | 3 | 2020-01-20 13:21:12 |
| 19256 | 9702 | 1 | 2020-01-20 14:03:11 |
| 19257 | 9682 | 3 | 2020-01-20 14:51:55 |
| 19258 | 9683 | 2 | 2020-01-20 14:59:14 |
| 19259 | 9682 | 1 | 2020-01-20 16:09:03 |
| 19260 | 9683 | 1 | 2020-01-20 16:34:11 |
| 19261 | 9703 | 1 | 2020-01-21 13:04:42 |
| 19262 | 9705 | 1 | 2020-01-21 13:51:52 |
| 19263 | 9706 | 1 | 2020-01-21 13:53:31 |
| 19264 | 9704 | 1 | 2020-01-21 13:53:58 |
| 19265 | 9703 | 3 | 2020-01-21 14:18:19 |
| 19266 | 9703 | 2 | 2020-01-21 15:13:49 |
| 19267 | 9703 | 3 | 2020-01-21 16:39:01 |
| 19268 | 9711 | 3 | 2020-01-22 10:07:15 |
| 19269 | 9698 | 2 | 2020-01-22 10:54:03 |
| 19270 | 9711 | 2 | 2020-01-22 10:56:03 |
| 19271 | 9698 | 1 | 2020-01-22 11:56:58 |
| 19272 | 9711 | 3 | 2020-01-22 12:08:59 |
| 19273 | 9698 | 2 | 2020-01-22 12:22:16 |
| 19274 | 9645 | 2 | 2020-01-22 12:41:02 |
| 19275 | 9644 | 2 | 2020-01-22 12:47:27 |
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;