Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 12,976–13,000 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 12976 | 6603 | 2 | 2018-09-02 10:19:24 |
| 12977 | 6604 | 1 | 2018-09-02 10:35:40 |
| 12978 | 6607 | 2 | 2018-09-02 10:42:00 |
| 12979 | 6608 | 2 | 2018-09-02 10:42:07 |
| 12980 | 6605 | 2 | 2018-09-02 10:44:19 |
| 12981 | 6606 | 2 | 2018-09-02 10:48:02 |
| 12982 | 6602 | 3 | 2018-09-02 11:10:46 |
| 12983 | 6606 | 3 | 2018-09-02 11:28:29 |
| 12984 | 6588 | 3 | 2018-09-02 11:29:07 |
| 12985 | 6605 | 3 | 2018-09-02 11:30:05 |
| 12986 | 6592 | 3 | 2018-09-02 11:30:55 |
| 12987 | 6607 | 3 | 2018-09-02 11:33:40 |
| 12988 | 6589 | 3 | 2018-09-02 11:34:23 |
| 12989 | 6591 | 2 | 2018-09-02 11:39:19 |
| 12990 | 6590 | 3 | 2018-09-02 11:40:08 |
| 12991 | 6608 | 3 | 2018-09-02 11:42:33 |
| 12992 | 6604 | 2 | 2018-09-02 12:06:53 |
| 12993 | 6602 | 1 | 2018-09-02 12:16:00 |
| 12994 | 6605 | 2 | 2018-09-02 12:36:08 |
| 12995 | 6606 | 2 | 2018-09-02 12:39:30 |
| 12996 | 6607 | 2 | 2018-09-02 12:40:17 |
| 12997 | 6591 | 1 | 2018-09-02 12:49:23 |
| 12998 | 6608 | 2 | 2018-09-02 12:50:47 |
| 12999 | 6602 | 2 | 2018-09-02 12:53:26 |
| 13000 | 6591 | 2 | 2018-09-02 14:06:12 |
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;