Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 7,126–7,150 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 7126 | 3223 | 3 | 2017-04-06 14:15:43 |
| 7127 | 3227 | 3 | 2017-04-06 14:16:00 |
| 7128 | 3219 | 3 | 2017-04-06 14:16:30 |
| 7129 | 3187 | 3 | 2017-04-06 14:17:43 |
| 7130 | 3225 | 3 | 2017-04-06 14:21:59 |
| 7131 | 3209 | 3 | 2017-04-06 14:22:40 |
| 7132 | 3226 | 3 | 2017-04-06 14:26:47 |
| 7133 | 3224 | 3 | 2017-04-06 14:29:01 |
| 7134 | 3238 | 3 | 2017-04-06 14:29:07 |
| 7135 | 3231 | 3 | 2017-04-06 14:30:03 |
| 7136 | 3186 | 3 | 2017-04-06 14:31:22 |
| 7137 | 3190 | 3 | 2017-04-06 14:31:57 |
| 7138 | 3228 | 3 | 2017-04-06 14:33:19 |
| 7139 | 3216 | 3 | 2017-04-06 14:34:01 |
| 7140 | 3214 | 3 | 2017-04-06 14:35:17 |
| 7141 | 3218 | 3 | 2017-04-06 14:36:05 |
| 7142 | 3208 | 3 | 2017-04-06 14:36:19 |
| 7143 | 3198 | 3 | 2017-04-06 14:41:50 |
| 7144 | 3207 | 3 | 2017-04-06 14:42:59 |
| 7145 | 3201 | 3 | 2017-04-06 14:45:31 |
| 7146 | 3211 | 3 | 2017-04-06 14:49:51 |
| 7147 | 3188 | 3 | 2017-04-06 14:51:32 |
| 7148 | 3234 | 3 | 2017-04-06 14:51:34 |
| 7149 | 3222 | 3 | 2017-04-06 14:56:01 |
| 7150 | 3203 | 3 | 2017-04-06 14:57:00 |
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;