Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 13,876–13,900 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 13876 | 7180 | 2 | 2018-11-24 10:35:30 |
| 13877 | 7181 | 3 | 2018-11-24 10:59:32 |
| 13878 | 7180 | 3 | 2018-11-24 11:18:55 |
| 13879 | 7181 | 2 | 2018-11-24 12:09:31 |
| 13880 | 7180 | 2 | 2018-11-24 12:39:19 |
| 13881 | 7181 | 3 | 2018-11-24 13:18:22 |
| 13882 | 7180 | 3 | 2018-11-24 13:39:29 |
| 13883 | 7191 | 2 | 2018-11-26 10:55:20 |
| 13884 | 7190 | 2 | 2018-11-26 10:56:10 |
| 13885 | 7193 | 2 | 2018-11-26 12:25:53 |
| 13886 | 7192 | 2 | 2018-11-26 12:26:54 |
| 13887 | 7194 | 2 | 2018-11-26 12:32:31 |
| 13888 | 7195 | 2 | 2018-11-26 12:34:19 |
| 13889 | 7193 | 3 | 2018-11-26 13:12:25 |
| 13890 | 7195 | 3 | 2018-11-26 13:25:17 |
| 13891 | 7192 | 3 | 2018-11-26 13:34:46 |
| 13892 | 7194 | 3 | 2018-11-26 13:35:57 |
| 13893 | 7159 | 2 | 2018-11-27 14:11:45 |
| 13894 | 7160 | 1 | 2018-11-27 14:12:01 |
| 13895 | 7158 | 1 | 2018-11-27 14:15:44 |
| 13896 | 7161 | 2 | 2018-11-27 14:21:55 |
| 13897 | 7162 | 1 | 2018-11-27 14:25:57 |
| 13898 | 7160 | 3 | 2018-11-27 14:39:40 |
| 13899 | 7162 | 3 | 2018-11-27 15:06:23 |
| 13900 | 7161 | 3 | 2018-11-27 15:12:45 |
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;