Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 17,876–17,900 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 17876 | 9172 | 2 | 2019-10-15 16:46:58 |
| 17877 | 9138 | 1 | 2019-10-16 11:06:29 |
| 17878 | 9139 | 1 | 2019-10-16 11:13:17 |
| 17879 | 9138 | 3 | 2019-10-16 11:54:33 |
| 17880 | 9139 | 3 | 2019-10-16 12:02:09 |
| 17881 | 9168 | 2 | 2019-10-16 14:14:09 |
| 17882 | 9169 | 2 | 2019-10-16 14:14:19 |
| 17883 | 9169 | 3 | 2019-10-16 15:42:08 |
| 17884 | 9168 | 3 | 2019-10-16 15:47:17 |
| 17885 | 9177 | 1 | 2019-10-17 09:11:12 |
| 17886 | 9178 | 1 | 2019-10-17 09:17:50 |
| 17887 | 9177 | 3 | 2019-10-17 09:46:55 |
| 17888 | 9087 | 1 | 2019-10-17 09:57:45 |
| 17889 | 9178 | 3 | 2019-10-17 10:48:27 |
| 17890 | 9128 | 2 | 2019-10-17 11:06:44 |
| 17891 | 9130 | 2 | 2019-10-17 11:08:49 |
| 17892 | 9129 | 3 | 2019-10-17 11:13:45 |
| 17893 | 9228 | 2 | 2019-10-17 15:32:14 |
| 17894 | 9229 | 2 | 2019-10-17 15:37:59 |
| 17895 | 9228 | 3 | 2019-10-17 16:04:07 |
| 17896 | 9228 | 1 | 2019-10-17 16:43:45 |
| 17897 | 9229 | 3 | 2019-10-17 16:57:56 |
| 17898 | 9229 | 1 | 2019-10-17 17:34:58 |
| 17899 | 9179 | 2 | 2019-10-18 09:35:35 |
| 17900 | 9235 | 2 | 2019-10-18 10:30:37 |
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;