Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 6,851–6,875 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 6851 | 3357 | 2 | 2017-03-14 11:30:52 |
| 6852 | 3346 | 2 | 2017-03-14 11:30:57 |
| 6853 | 3372 | 2 | 2017-03-14 11:31:14 |
| 6854 | 3368 | 2 | 2017-03-14 11:32:23 |
| 6855 | 3377 | 2 | 2017-03-14 11:33:22 |
| 6856 | 3619 | 2 | 2017-03-15 11:07:58 |
| 6857 | 3621 | 2 | 2017-03-15 11:08:20 |
| 6858 | 3623 | 2 | 2017-03-15 11:10:04 |
| 6859 | 3620 | 2 | 2017-03-15 11:10:47 |
| 6860 | 3622 | 2 | 2017-03-15 11:15:04 |
| 6861 | 3265 | 3 | 2017-03-15 11:32:10 |
| 6862 | 3256 | 3 | 2017-03-15 11:34:28 |
| 6863 | 3259 | 3 | 2017-03-15 11:34:48 |
| 6864 | 3269 | 3 | 2017-03-15 11:35:36 |
| 6865 | 3288 | 3 | 2017-03-15 11:36:48 |
| 6866 | 3280 | 3 | 2017-03-15 11:37:00 |
| 6867 | 3296 | 3 | 2017-03-15 11:37:15 |
| 6868 | 3258 | 3 | 2017-03-15 11:37:27 |
| 6869 | 3290 | 3 | 2017-03-15 11:37:33 |
| 6870 | 3263 | 3 | 2017-03-15 11:37:42 |
| 6871 | 3285 | 3 | 2017-03-15 11:37:52 |
| 6872 | 3299 | 3 | 2017-03-15 11:38:14 |
| 6873 | 3281 | 3 | 2017-03-15 11:38:31 |
| 6874 | 3268 | 3 | 2017-03-15 11:38:33 |
| 6875 | 3255 | 3 | 2017-03-15 11:38: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;