Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 7,176–7,200 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 7176 | 3744 | 2 | 2017-04-12 12:14:50 |
| 7177 | 3746 | 2 | 2017-04-12 12:22:17 |
| 7178 | 3745 | 2 | 2017-04-12 12:23:34 |
| 7179 | 3742 | 2 | 2017-04-12 12:24:22 |
| 7180 | 3743 | 1 | 2017-04-12 12:42:50 |
| 7181 | 3744 | 1 | 2017-04-12 13:04:39 |
| 7182 | 3746 | 1 | 2017-04-12 13:31:38 |
| 7183 | 3745 | 1 | 2017-04-12 13:48:58 |
| 7184 | 3742 | 1 | 2017-04-12 13:52:23 |
| 7185 | 3758 | 2 | 2017-04-12 15:05:46 |
| 7186 | 3758 | 1 | 2017-04-12 15:54:13 |
| 7187 | 3758 | 3 | 2017-04-12 17:18:01 |
| 7188 | 3723 | 2 | 2017-04-13 13:11:45 |
| 7189 | 3724 | 2 | 2017-04-13 13:18:09 |
| 7190 | 3723 | 3 | 2017-04-13 14:21:24 |
| 7191 | 3724 | 3 | 2017-04-13 14:21:40 |
| 7192 | 3764 | 2 | 2017-04-14 11:23:29 |
| 7193 | 3765 | 2 | 2017-04-14 11:28:09 |
| 7194 | 3750 | 2 | 2017-04-14 11:29:26 |
| 7195 | 3763 | 2 | 2017-04-14 11:31:19 |
| 7196 | 3762 | 2 | 2017-04-14 11:35:50 |
| 7197 | 3748 | 2 | 2017-04-14 11:37:25 |
| 7198 | 3751 | 2 | 2017-04-14 11:37:36 |
| 7199 | 3749 | 2 | 2017-04-14 11:39:08 |
| 7200 | 3752 | 2 | 2017-04-14 11:42:51 |
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;