Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 14,876–14,900 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 14876 | 7105 | 2 | 2019-02-27 13:05:27 |
| 14877 | 7117 | 2 | 2019-02-27 13:05:56 |
| 14878 | 7115 | 2 | 2019-02-27 13:06:01 |
| 14879 | 7092 | 2 | 2019-02-27 13:06:02 |
| 14880 | 7130 | 2 | 2019-02-27 13:06:44 |
| 14881 | 7143 | 2 | 2019-02-27 13:07:04 |
| 14882 | 7128 | 2 | 2019-02-27 13:07:45 |
| 14883 | 7114 | 2 | 2019-02-27 13:08:22 |
| 14884 | 7110 | 2 | 2019-02-27 13:08:38 |
| 14885 | 7086 | 2 | 2019-02-27 13:08:40 |
| 14886 | 7089 | 2 | 2019-02-27 13:09:18 |
| 14887 | 7120 | 2 | 2019-02-27 13:09:28 |
| 14888 | 7122 | 2 | 2019-02-27 13:09:39 |
| 14889 | 7119 | 2 | 2019-02-27 13:10:01 |
| 14890 | 7095 | 2 | 2019-02-27 13:10:10 |
| 14891 | 7118 | 2 | 2019-02-27 13:10:19 |
| 14892 | 7113 | 2 | 2019-02-27 13:10:31 |
| 14893 | 7144 | 2 | 2019-02-27 13:11:04 |
| 14894 | 7123 | 2 | 2019-02-27 13:11:05 |
| 14895 | 7112 | 2 | 2019-02-27 13:11:10 |
| 14896 | 7121 | 2 | 2019-02-27 13:11:14 |
| 14897 | 7107 | 2 | 2019-02-27 13:11:16 |
| 14898 | 7111 | 2 | 2019-02-27 13:11:20 |
| 14899 | 7088 | 2 | 2019-02-27 13:11:26 |
| 14900 | 7139 | 2 | 2019-02-27 13:11:44 |
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;