Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 1,351–1,375 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 1351 | 789 | 1 | 2015-07-13 12:20:44 |
| 1352 | 788 | 2 | 2015-07-14 10:15:53 |
| 1353 | 788 | 1 | 2015-07-14 10:57:36 |
| 1354 | 761 | 1 | 2015-07-14 11:46:55 |
| 1355 | 790 | 3 | 2015-07-14 16:57:17 |
| 1356 | 776 | 2 | 2015-07-15 13:33:42 |
| 1357 | 777 | 2 | 2015-07-15 13:42:50 |
| 1358 | 794 | 1 | 2015-07-15 14:00:04 |
| 1359 | 776 | 1 | 2015-07-15 14:10:57 |
| 1360 | 777 | 1 | 2015-07-15 14:49:16 |
| 1361 | 776 | 2 | 2015-07-15 15:13:36 |
| 1362 | 794 | 2 | 2015-07-15 15:15:04 |
| 1363 | 794 | 1 | 2015-07-15 15:43:12 |
| 1364 | 777 | 2 | 2015-07-15 15:45:59 |
| 1365 | 677 | 1 | 2015-07-16 12:05:02 |
| 1366 | 676 | 1 | 2015-07-16 12:08:06 |
| 1367 | 678 | 3 | 2015-07-16 12:11:20 |
| 1368 | 676 | 3 | 2015-07-16 12:40:38 |
| 1369 | 677 | 3 | 2015-07-16 12:44:07 |
| 1370 | 678 | 2 | 2015-07-16 12:51:10 |
| 1371 | 678 | 1 | 2015-07-16 14:26:21 |
| 1372 | 797 | 1 | 2015-07-17 11:16:23 |
| 1373 | 799 | 2 | 2015-07-17 11:24:35 |
| 1374 | 796 | 1 | 2015-07-17 11:25:11 |
| 1375 | 795 | 1 | 2015-07-17 11:26:07 |
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;