Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 1,301–1,325 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 1301 | 759 | 3 | 2015-07-08 14:24:52 |
| 1302 | 760 | 3 | 2015-07-08 14:30:29 |
| 1303 | 759 | 2 | 2015-07-08 15:33:26 |
| 1304 | 760 | 2 | 2015-07-08 15:38:55 |
| 1305 | 763 | 2 | 2015-07-09 11:13:09 |
| 1306 | 762 | 2 | 2015-07-09 11:14:30 |
| 1307 | 762 | 3 | 2015-07-09 11:40:41 |
| 1308 | 762 | 1 | 2015-07-09 12:17:49 |
| 1309 | 763 | 3 | 2015-07-09 12:46:59 |
| 1310 | 763 | 1 | 2015-07-09 13:20:18 |
| 1311 | 767 | 1 | 2015-07-10 10:58:31 |
| 1312 | 766 | 2 | 2015-07-10 11:09:53 |
| 1313 | 766 | 3 | 2015-07-10 11:39:05 |
| 1314 | 768 | 3 | 2015-07-10 12:03:31 |
| 1315 | 770 | 3 | 2015-07-10 12:05:27 |
| 1316 | 769 | 2 | 2015-07-10 12:14:09 |
| 1317 | 770 | 1 | 2015-07-10 12:54:00 |
| 1318 | 769 | 1 | 2015-07-10 13:17:52 |
| 1319 | 768 | 1 | 2015-07-10 13:25:58 |
| 1320 | 771 | 2 | 2015-07-11 10:07:12 |
| 1321 | 772 | 2 | 2015-07-11 10:07:24 |
| 1322 | 773 | 2 | 2015-07-11 10:31:21 |
| 1323 | 772 | 3 | 2015-07-11 11:07:26 |
| 1324 | 771 | 3 | 2015-07-11 11:09:47 |
| 1325 | 775 | 1 | 2015-07-11 11:33:26 |
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;