Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 18,851–18,875 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 18851 | 9268 | 1 | 2019-12-20 14:53:23 |
| 18852 | 9245 | 1 | 2019-12-20 14:55:04 |
| 18853 | 9271 | 1 | 2019-12-20 14:56:57 |
| 18854 | 9290 | 1 | 2019-12-20 14:57:06 |
| 18855 | 9251 | 1 | 2019-12-20 15:00:52 |
| 18856 | 9246 | 1 | 2019-12-20 15:01:02 |
| 18857 | 9283 | 1 | 2019-12-20 15:05:36 |
| 18858 | 9267 | 1 | 2019-12-20 15:05:55 |
| 18859 | 9284 | 1 | 2019-12-20 15:06:09 |
| 18860 | 9243 | 1 | 2019-12-20 15:08:57 |
| 18861 | 9263 | 1 | 2019-12-20 15:11:22 |
| 18862 | 9569 | 1 | 2019-12-20 15:12:57 |
| 18863 | 9258 | 2 | 2019-12-20 15:17:06 |
| 18864 | 9257 | 2 | 2019-12-20 15:17:38 |
| 18865 | 9241 | 1 | 2019-12-20 15:18:34 |
| 18866 | 9248 | 1 | 2019-12-20 15:18:39 |
| 18867 | 9570 | 1 | 2019-12-20 15:20:30 |
| 18868 | 9289 | 1 | 2019-12-20 15:22:06 |
| 18869 | 9276 | 1 | 2019-12-20 15:22:25 |
| 18870 | 9271 | 2 | 2019-12-20 15:23:18 |
| 18871 | 9280 | 1 | 2019-12-20 15:25:52 |
| 18872 | 9285 | 1 | 2019-12-20 15:26:18 |
| 18873 | 9262 | 1 | 2019-12-20 15:26:27 |
| 18874 | 9244 | 1 | 2019-12-20 15:26:44 |
| 18875 | 9273 | 1 | 2019-12-20 15:27:10 |
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;