Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 7,101–7,125 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 7101 | 3189 | 2 | 2017-04-06 13:34:55 |
| 7102 | 3208 | 2 | 2017-04-06 13:36:05 |
| 7103 | 3203 | 2 | 2017-04-06 13:36:25 |
| 7104 | 3188 | 2 | 2017-04-06 13:37:08 |
| 7105 | 3201 | 2 | 2017-04-06 13:37:14 |
| 7106 | 3199 | 2 | 2017-04-06 13:37:16 |
| 7107 | 3187 | 2 | 2017-04-06 13:37:20 |
| 7108 | 3228 | 2 | 2017-04-06 13:37:46 |
| 7109 | 3220 | 2 | 2017-04-06 13:38:15 |
| 7110 | 3202 | 2 | 2017-04-06 13:38:21 |
| 7111 | 3216 | 2 | 2017-04-06 13:38:53 |
| 7112 | 3225 | 2 | 2017-04-06 13:39:45 |
| 7113 | 3214 | 2 | 2017-04-06 13:40:35 |
| 7114 | 3192 | 2 | 2017-04-06 13:41:52 |
| 7115 | 3190 | 2 | 2017-04-06 13:42:04 |
| 7116 | 3226 | 2 | 2017-04-06 13:42:26 |
| 7117 | 3238 | 2 | 2017-04-06 13:42:35 |
| 7118 | 3207 | 2 | 2017-04-06 13:44:41 |
| 7119 | 3227 | 2 | 2017-04-06 13:46:51 |
| 7120 | 3231 | 2 | 2017-04-06 13:50:04 |
| 7121 | 3212 | 3 | 2017-04-06 13:58:29 |
| 7122 | 3191 | 3 | 2017-04-06 14:04:14 |
| 7123 | 3189 | 3 | 2017-04-06 14:08:00 |
| 7124 | 3230 | 3 | 2017-04-06 14:09:43 |
| 7125 | 3202 | 3 | 2017-04-06 14:15:41 |
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;