Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 7,601–7,625 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 7601 | 3921 | 1 | 2017-05-18 13:26:02 |
| 7602 | 3920 | 1 | 2017-05-18 14:01:50 |
| 7603 | 3952 | 2 | 2017-05-19 11:25:30 |
| 7604 | 3952 | 3 | 2017-05-19 12:35:21 |
| 7605 | 3952 | 1 | 2017-05-19 13:05:00 |
| 7606 | 3953 | 1 | 2017-05-20 09:54:14 |
| 7607 | 3954 | 2 | 2017-05-20 10:09:08 |
| 7608 | 3954 | 1 | 2017-05-20 10:55:42 |
| 7609 | 3941 | 2 | 2017-05-20 12:26:16 |
| 7610 | 3869 | 2 | 2017-05-20 13:16:08 |
| 7611 | 3867 | 2 | 2017-05-20 13:23:06 |
| 7612 | 3868 | 2 | 2017-05-20 13:23:55 |
| 7613 | 3867 | 3 | 2017-05-20 13:53:57 |
| 7614 | 3941 | 3 | 2017-05-20 13:54:50 |
| 7615 | 3868 | 3 | 2017-05-20 14:19:03 |
| 7616 | 3869 | 3 | 2017-05-20 14:19:58 |
| 7617 | 3855 | 1 | 2017-05-20 16:09:30 |
| 7618 | 3956 | 2 | 2017-05-21 11:06:09 |
| 7619 | 3955 | 2 | 2017-05-21 11:07:22 |
| 7620 | 3895 | 2 | 2017-05-23 12:39:07 |
| 7621 | 3896 | 2 | 2017-05-23 12:48:43 |
| 7622 | 3896 | 1 | 2017-05-23 13:20:41 |
| 7623 | 3896 | 2 | 2017-05-23 14:11:37 |
| 7624 | 3895 | 3 | 2017-05-23 14:12:29 |
| 7625 | 3895 | 2 | 2017-05-23 14:53:25 |
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;