Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 7,501–7,525 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 7501 | 3856 | 2 | 2017-05-07 12:17:34 |
| 7502 | 3860 | 2 | 2017-05-07 12:17:50 |
| 7503 | 3857 | 2 | 2017-05-07 12:21:00 |
| 7504 | 3894 | 1 | 2017-05-07 16:40:56 |
| 7505 | 3893 | 1 | 2017-05-07 16:45:53 |
| 7506 | 3892 | 1 | 2017-05-07 16:53:04 |
| 7507 | 3892 | 2 | 2017-05-07 17:26:48 |
| 7508 | 3894 | 2 | 2017-05-07 17:42:15 |
| 7509 | 3902 | 3 | 2017-05-08 11:03:43 |
| 7510 | 3904 | 3 | 2017-05-08 11:12:06 |
| 7511 | 3903 | 3 | 2017-05-08 11:13:28 |
| 7512 | 3905 | 3 | 2017-05-08 11:17:54 |
| 7513 | 3902 | 2 | 2017-05-08 11:50:41 |
| 7514 | 3903 | 2 | 2017-05-08 12:07:51 |
| 7515 | 3905 | 2 | 2017-05-08 12:07:59 |
| 7516 | 3904 | 2 | 2017-05-08 12:36:04 |
| 7517 | 3907 | 2 | 2017-05-08 13:59:23 |
| 7518 | 3906 | 2 | 2017-05-08 14:09:01 |
| 7519 | 3914 | 1 | 2017-05-09 11:44:59 |
| 7520 | 3914 | 2 | 2017-05-09 12:57:03 |
| 7521 | 3913 | 2 | 2017-05-10 14:20:27 |
| 7522 | 3912 | 2 | 2017-05-10 14:20:49 |
| 7523 | 3912 | 1 | 2017-05-10 15:05:31 |
| 7524 | 3913 | 1 | 2017-05-10 15:45:23 |
| 7525 | 3919 | 2 | 2017-05-11 10:54:19 |
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;