Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 11,576–11,600 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 11576 | 5889 | 2 | 2018-06-24 09:59:33 |
| 11577 | 5887 | 1 | 2018-06-24 10:01:30 |
| 11578 | 5886 | 2 | 2018-06-24 10:01:56 |
| 11579 | 6079 | 2 | 2018-06-24 10:36:27 |
| 11580 | 6080 | 1 | 2018-06-24 10:38:34 |
| 11581 | 5889 | 1 | 2018-06-24 10:42:11 |
| 11582 | 6078 | 1 | 2018-06-24 10:43:27 |
| 11583 | 5890 | 1 | 2018-06-24 11:17:26 |
| 11584 | 5888 | 1 | 2018-06-24 11:18:44 |
| 11585 | 5886 | 1 | 2018-06-24 11:20:15 |
| 11586 | 6079 | 3 | 2018-06-24 12:09:00 |
| 11587 | 6079 | 2 | 2018-06-24 12:36:01 |
| 11588 | 6045 | 2 | 2018-06-26 10:52:50 |
| 11589 | 5828 | 2 | 2018-06-27 10:01:34 |
| 11590 | 5825 | 2 | 2018-06-27 10:02:15 |
| 11591 | 5826 | 2 | 2018-06-27 10:03:36 |
| 11592 | 5827 | 2 | 2018-06-27 10:04:21 |
| 11593 | 5826 | 1 | 2018-06-27 10:33:31 |
| 11594 | 5825 | 1 | 2018-06-27 10:52:25 |
| 11595 | 5828 | 1 | 2018-06-27 10:52:41 |
| 11596 | 5827 | 1 | 2018-06-27 11:03:41 |
| 11597 | 6081 | 1 | 2018-06-28 12:54:24 |
| 11598 | 6101 | 2 | 2018-06-29 09:09:32 |
| 11599 | 6103 | 2 | 2018-06-29 09:11:35 |
| 11600 | 6102 | 2 | 2018-06-29 09:14:11 |
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;