Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 6,876–6,900 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 6876 | 3262 | 3 | 2017-03-15 11:39:21 |
| 6877 | 3276 | 3 | 2017-03-15 11:39:36 |
| 6878 | 3254 | 3 | 2017-03-15 11:41:07 |
| 6879 | 3253 | 3 | 2017-03-15 11:41:23 |
| 6880 | 3274 | 3 | 2017-03-15 11:41:24 |
| 6881 | 3279 | 3 | 2017-03-15 11:41:31 |
| 6882 | 3267 | 3 | 2017-03-15 11:42:58 |
| 6883 | 3278 | 3 | 2017-03-15 11:43:00 |
| 6884 | 3266 | 3 | 2017-03-15 11:43:02 |
| 6885 | 3287 | 3 | 2017-03-15 11:43:08 |
| 6886 | 3273 | 3 | 2017-03-15 11:43:15 |
| 6887 | 3257 | 3 | 2017-03-15 11:43:49 |
| 6888 | 3284 | 3 | 2017-03-15 11:43:52 |
| 6889 | 3264 | 3 | 2017-03-15 11:44:29 |
| 6890 | 3271 | 3 | 2017-03-15 11:44:30 |
| 6891 | 3270 | 3 | 2017-03-15 11:45:04 |
| 6892 | 3261 | 3 | 2017-03-15 11:45:15 |
| 6893 | 3275 | 3 | 2017-03-15 11:45:25 |
| 6894 | 3300 | 3 | 2017-03-15 11:46:11 |
| 6895 | 3294 | 3 | 2017-03-15 11:46:18 |
| 6896 | 3293 | 3 | 2017-03-15 11:46:32 |
| 6897 | 3286 | 3 | 2017-03-15 11:46:52 |
| 6898 | 3289 | 3 | 2017-03-15 11:47:00 |
| 6899 | 3295 | 3 | 2017-03-15 11:47:20 |
| 6900 | 3260 | 3 | 2017-03-15 11:47:24 |
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;