Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 6,951–6,975 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 6951 | 3293 | 2 | 2017-03-15 13:06:44 |
| 6952 | 3295 | 2 | 2017-03-15 13:08:06 |
| 6953 | 3267 | 2 | 2017-03-15 13:10:43 |
| 6954 | 3286 | 2 | 2017-03-15 13:10:49 |
| 6955 | 3294 | 2 | 2017-03-15 13:13:41 |
| 6956 | 3270 | 2 | 2017-03-15 13:15:49 |
| 6957 | 3261 | 2 | 2017-03-15 13:19:23 |
| 6958 | 3298 | 2 | 2017-03-15 13:25:53 |
| 6959 | 3579 | 1 | 2017-03-15 14:49:09 |
| 6960 | 3580 | 1 | 2017-03-15 14:49:15 |
| 6961 | 3577 | 1 | 2017-03-15 14:49:52 |
| 6962 | 3576 | 2 | 2017-03-15 14:53:33 |
| 6963 | 3578 | 3 | 2017-03-15 14:59:22 |
| 6964 | 3578 | 1 | 2017-03-15 15:46:47 |
| 6965 | 3577 | 2 | 2017-03-15 15:50:29 |
| 6966 | 3580 | 2 | 2017-03-15 16:07:42 |
| 6967 | 3579 | 3 | 2017-03-15 16:16:44 |
| 6968 | 3578 | 2 | 2017-03-15 16:30:00 |
| 6969 | 3424 | 3 | 2017-03-16 14:01:02 |
| 6970 | 3616 | 2 | 2017-03-16 14:39:48 |
| 6971 | 3615 | 2 | 2017-03-16 14:41:41 |
| 6972 | 3617 | 2 | 2017-03-16 14:50:22 |
| 6973 | 3615 | 3 | 2017-03-16 15:06:59 |
| 6974 | 3616 | 3 | 2017-03-16 15:07:12 |
| 6975 | 3617 | 3 | 2017-03-16 15:35:46 |
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;