Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 11,176–11,200 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 11176 | 5669 | 3 | 2018-05-07 15:31:04 |
| 11177 | 5704 | 2 | 2018-05-08 11:24:52 |
| 11178 | 5704 | 3 | 2018-05-08 11:52:53 |
| 11179 | 5704 | 2 | 2018-05-08 12:24:30 |
| 11180 | 5706 | 2 | 2018-05-09 14:05:34 |
| 11181 | 5706 | 1 | 2018-05-09 14:33:08 |
| 11182 | 5706 | 2 | 2018-05-09 15:23:55 |
| 11183 | 5582 | 2 | 2018-05-10 09:08:47 |
| 11184 | 5582 | 1 | 2018-05-10 10:03:47 |
| 11185 | 5582 | 3 | 2018-05-10 11:08:19 |
| 11186 | 5683 | 3 | 2018-05-11 10:14:34 |
| 11187 | 5684 | 3 | 2018-05-11 10:15:14 |
| 11188 | 5675 | 2 | 2018-05-11 13:57:51 |
| 11189 | 5674 | 2 | 2018-05-11 14:00:49 |
| 11190 | 5675 | 3 | 2018-05-11 14:30:32 |
| 11191 | 5674 | 3 | 2018-05-11 15:05:35 |
| 11192 | 5675 | 1 | 2018-05-11 15:46:07 |
| 11193 | 5701 | 1 | 2018-05-11 16:02:19 |
| 11194 | 5674 | 1 | 2018-05-11 16:10:05 |
| 11195 | 5675 | 2 | 2018-05-11 16:32:27 |
| 11196 | 5701 | 3 | 2018-05-11 17:37:32 |
| 11197 | 5674 | 2 | 2018-05-11 17:40:17 |
| 11198 | 5749 | 2 | 2018-05-12 12:03:44 |
| 11199 | 5748 | 2 | 2018-05-12 12:06:03 |
| 11200 | 5748 | 3 | 2018-05-12 12:52:39 |
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;