Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 1,376–1,400 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 1376 | 795 | 2 | 2015-07-17 12:36:36 |
| 1377 | 797 | 2 | 2015-07-17 12:39:25 |
| 1378 | 796 | 2 | 2015-07-17 12:47:05 |
| 1379 | 754 | 3 | 2015-07-18 10:36:52 |
| 1380 | 753 | 1 | 2015-07-18 10:45:42 |
| 1381 | 804 | 3 | 2015-07-18 10:50:53 |
| 1382 | 804 | 2 | 2015-07-18 11:18:22 |
| 1383 | 807 | 2 | 2015-07-18 13:25:19 |
| 1384 | 806 | 2 | 2015-07-18 13:35:55 |
| 1385 | 808 | 1 | 2015-07-19 11:22:04 |
| 1386 | 809 | 1 | 2015-07-19 11:23:24 |
| 1387 | 809 | 3 | 2015-07-19 12:41:07 |
| 1388 | 808 | 3 | 2015-07-19 12:54:23 |
| 1389 | 809 | 1 | 2015-07-19 13:52:25 |
| 1390 | 808 | 1 | 2015-07-19 14:18:33 |
| 1391 | 811 | 2 | 2015-07-19 14:28:05 |
| 1392 | 810 | 2 | 2015-07-19 14:29:14 |
| 1393 | 811 | 3 | 2015-07-19 15:03:17 |
| 1394 | 810 | 3 | 2015-07-19 15:43:46 |
| 1395 | 811 | 1 | 2015-07-19 15:45:10 |
| 1396 | 810 | 1 | 2015-07-19 17:17:23 |
| 1397 | 815 | 1 | 2015-07-20 14:26:23 |
| 1398 | 816 | 2 | 2015-07-20 14:31:40 |
| 1399 | 815 | 3 | 2015-07-20 15:41:18 |
| 1400 | 816 | 3 | 2015-07-20 16:06:37 |
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;