Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 7,576–7,600 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 7576 | 3938 | 3 | 2017-05-13 16:25:26 |
| 7577 | 3939 | 2 | 2017-05-13 17:02:50 |
| 7578 | 3938 | 2 | 2017-05-13 17:23:51 |
| 7579 | 3937 | 3 | 2017-05-13 17:29:59 |
| 7580 | 3915 | 2 | 2017-05-14 14:11:16 |
| 7581 | 3916 | 2 | 2017-05-14 14:20:07 |
| 7582 | 3915 | 1 | 2017-05-14 14:42:21 |
| 7583 | 3916 | 1 | 2017-05-14 15:43:17 |
| 7584 | 3901 | 2 | 2017-05-16 13:01:00 |
| 7585 | 3901 | 3 | 2017-05-16 13:44:27 |
| 7586 | 3949 | 1 | 2017-05-18 09:40:15 |
| 7587 | 3948 | 1 | 2017-05-18 09:49:20 |
| 7588 | 3942 | 1 | 2017-05-18 10:24:31 |
| 7589 | 3888 | 2 | 2017-05-18 11:36:13 |
| 7590 | 3942 | 2 | 2017-05-18 11:37:50 |
| 7591 | 3889 | 2 | 2017-05-18 11:41:13 |
| 7592 | 3890 | 3 | 2017-05-18 11:43:30 |
| 7593 | 3887 | 3 | 2017-05-18 11:46:13 |
| 7594 | 3920 | 2 | 2017-05-18 12:04:49 |
| 7595 | 3921 | 2 | 2017-05-18 12:05:42 |
| 7596 | 3890 | 1 | 2017-05-18 12:10:24 |
| 7597 | 3887 | 1 | 2017-05-18 12:48:20 |
| 7598 | 3921 | 3 | 2017-05-18 12:53:00 |
| 7599 | 3889 | 3 | 2017-05-18 12:57:42 |
| 7600 | 3920 | 3 | 2017-05-18 13:02:28 |
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;