Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 15,376–15,400 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 15376 | 7897 | 1 | 2019-03-30 14:14:59 |
| 15377 | 7896 | 1 | 2019-03-30 14:21:31 |
| 15378 | 7895 | 1 | 2019-03-30 14:25:54 |
| 15379 | 7895 | 3 | 2019-03-30 15:22:11 |
| 15380 | 7922 | 1 | 2019-03-30 15:26:08 |
| 15381 | 7921 | 2 | 2019-03-30 15:28:53 |
| 15382 | 7920 | 1 | 2019-03-30 15:32:15 |
| 15383 | 7923 | 1 | 2019-03-30 15:37:52 |
| 15384 | 7924 | 2 | 2019-03-31 09:50:33 |
| 15385 | 7925 | 2 | 2019-03-31 10:03:50 |
| 15386 | 7907 | 3 | 2019-04-01 16:36:04 |
| 15387 | 7910 | 2 | 2019-04-01 16:39:44 |
| 15388 | 7908 | 3 | 2019-04-01 16:44:21 |
| 15389 | 7909 | 3 | 2019-04-01 16:45:28 |
| 15390 | 7908 | 1 | 2019-04-01 17:18:54 |
| 15391 | 7907 | 1 | 2019-04-01 17:20:35 |
| 15392 | 7294 | 3 | 2019-04-02 10:12:19 |
| 15393 | 7919 | 2 | 2019-04-02 10:12:35 |
| 15394 | 7318 | 3 | 2019-04-02 10:12:36 |
| 15395 | 7311 | 3 | 2019-04-02 10:12:56 |
| 15396 | 7308 | 3 | 2019-04-02 10:12:59 |
| 15397 | 7315 | 3 | 2019-04-02 10:13:29 |
| 15398 | 7324 | 3 | 2019-04-02 10:13:49 |
| 15399 | 7296 | 3 | 2019-04-02 10:17:10 |
| 15400 | 7301 | 3 | 2019-04-02 10:17:53 |
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;