Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 1,276–1,300 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 1276 | 755 | 3 | 2015-07-06 09:55:29 |
| 1277 | 756 | 3 | 2015-07-06 10:18:31 |
| 1278 | 755 | 1 | 2015-07-06 10:24:54 |
| 1279 | 742 | 2 | 2015-07-06 10:44:00 |
| 1280 | 741 | 2 | 2015-07-06 10:47:25 |
| 1281 | 757 | 1 | 2015-07-06 11:32:00 |
| 1282 | 741 | 3 | 2015-07-06 11:39:01 |
| 1283 | 742 | 3 | 2015-07-06 11:41:29 |
| 1284 | 756 | 1 | 2015-07-06 11:44:56 |
| 1285 | 741 | 1 | 2015-07-06 12:20:11 |
| 1286 | 742 | 1 | 2015-07-06 12:22:25 |
| 1287 | 757 | 2 | 2015-07-06 12:33:49 |
| 1288 | 757 | 1 | 2015-07-06 13:42:15 |
| 1289 | 757 | 3 | 2015-07-06 14:49:20 |
| 1290 | 743 | 2 | 2015-07-06 16:55:28 |
| 1291 | 744 | 2 | 2015-07-06 17:00:11 |
| 1292 | 743 | 1 | 2015-07-06 17:20:59 |
| 1293 | 744 | 1 | 2015-07-06 17:26:10 |
| 1294 | 758 | 2 | 2015-07-07 12:48:40 |
| 1295 | 758 | 3 | 2015-07-07 14:09:08 |
| 1296 | 758 | 2 | 2015-07-07 15:18:57 |
| 1297 | 732 | 2 | 2015-07-07 16:09:11 |
| 1298 | 732 | 3 | 2015-07-07 17:13:26 |
| 1299 | 760 | 2 | 2015-07-08 12:56:32 |
| 1300 | 759 | 2 | 2015-07-08 12:59:33 |
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;