Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 6,176–6,200 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 6176 | 3154 | 2 | 2016-12-25 13:37:57 |
| 6177 | 3307 | 2 | 2016-12-25 13:42:36 |
| 6178 | 3304 | 2 | 2016-12-25 13:45:52 |
| 6179 | 3155 | 2 | 2016-12-25 13:46:36 |
| 6180 | 3152 | 3 | 2016-12-25 13:48:53 |
| 6181 | 3305 | 2 | 2016-12-25 13:57:09 |
| 6182 | 3154 | 3 | 2016-12-25 14:10:49 |
| 6183 | 3306 | 2 | 2016-12-25 14:19:04 |
| 6184 | 3307 | 3 | 2016-12-25 14:45:54 |
| 6185 | 3304 | 3 | 2016-12-25 14:49:53 |
| 6186 | 3306 | 3 | 2016-12-25 15:02:59 |
| 6187 | 3152 | 2 | 2016-12-25 15:03:34 |
| 6188 | 3305 | 3 | 2016-12-25 15:04:15 |
| 6189 | 3155 | 3 | 2016-12-25 15:10:24 |
| 6190 | 3153 | 2 | 2016-12-25 15:11:19 |
| 6191 | 3305 | 1 | 2016-12-25 15:45:02 |
| 6192 | 3307 | 1 | 2016-12-25 15:45:22 |
| 6193 | 3306 | 1 | 2016-12-25 15:54:43 |
| 6194 | 3304 | 1 | 2016-12-25 16:11:11 |
| 6195 | 3152 | 3 | 2016-12-25 16:27:54 |
| 6196 | 2955 | 1 | 2016-12-26 09:49:02 |
| 6197 | 2954 | 1 | 2016-12-26 09:49:41 |
| 6198 | 2962 | 1 | 2016-12-26 09:50:09 |
| 6199 | 2967 | 1 | 2016-12-26 09:52:34 |
| 6200 | 2956 | 1 | 2016-12-26 09:52:48 |
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;