Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 3,026–3,050 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 3026 | 1246 | 1 | 2015-12-08 16:30:04 |
| 3027 | 1237 | 2 | 2015-12-08 16:31:15 |
| 3028 | 1220 | 1 | 2015-12-08 16:33:42 |
| 3029 | 1218 | 1 | 2015-12-08 16:34:37 |
| 3030 | 1217 | 1 | 2015-12-08 16:35:29 |
| 3031 | 1247 | 1 | 2015-12-08 16:37:09 |
| 3032 | 1242 | 1 | 2015-12-08 16:37:21 |
| 3033 | 1204 | 2 | 2015-12-08 16:37:41 |
| 3034 | 1222 | 1 | 2015-12-08 16:38:23 |
| 3035 | 1211 | 2 | 2015-12-08 16:38:53 |
| 3036 | 1207 | 1 | 2015-12-08 16:42:14 |
| 3037 | 1234 | 1 | 2015-12-08 16:47:57 |
| 3038 | 1228 | 1 | 2015-12-08 16:48:04 |
| 3039 | 1205 | 1 | 2015-12-08 16:49:36 |
| 3040 | 1245 | 2 | 2015-12-08 16:54:23 |
| 3041 | 1227 | 2 | 2015-12-08 16:58:50 |
| 3042 | 1209 | 1 | 2015-12-08 17:02:01 |
| 3043 | 1204 | 1 | 2015-12-08 17:05:18 |
| 3044 | 1243 | 1 | 2015-12-08 17:07:19 |
| 3045 | 1224 | 1 | 2015-12-08 17:07:46 |
| 3046 | 1236 | 1 | 2015-12-08 17:17:14 |
| 3047 | 1249 | 1 | 2015-12-08 17:19:13 |
| 3048 | 1211 | 1 | 2015-12-08 17:23:23 |
| 3049 | 1213 | 1 | 2015-12-08 17:29:34 |
| 3050 | 1229 | 1 | 2015-12-08 17:32:54 |
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;