Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 2,526–2,550 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 2526 | 1140 | 1 | 2015-11-10 11:58:26 |
| 2527 | 1134 | 1 | 2015-11-10 11:58:56 |
| 2528 | 1142 | 1 | 2015-11-10 11:59:12 |
| 2529 | 1146 | 1 | 2015-11-10 12:01:28 |
| 2530 | 1152 | 1 | 2015-11-10 12:03:44 |
| 2531 | 1157 | 1 | 2015-11-10 12:04:53 |
| 2532 | 1161 | 1 | 2015-11-10 12:05:23 |
| 2533 | 1163 | 1 | 2015-11-10 12:05:32 |
| 2534 | 1149 | 1 | 2015-11-10 12:06:45 |
| 2535 | 1169 | 1 | 2015-11-10 12:09:25 |
| 2536 | 1173 | 1 | 2015-11-10 12:10:00 |
| 2537 | 1156 | 1 | 2015-11-10 12:10:24 |
| 2538 | 1141 | 1 | 2015-11-10 12:13:52 |
| 2539 | 1155 | 1 | 2015-11-10 12:14:31 |
| 2540 | 1165 | 3 | 2015-11-10 12:14:36 |
| 2541 | 1153 | 3 | 2015-11-10 12:15:18 |
| 2542 | 1162 | 1 | 2015-11-10 12:17:44 |
| 2543 | 1151 | 1 | 2015-11-10 12:20:09 |
| 2544 | 1166 | 3 | 2015-11-10 12:21:29 |
| 2545 | 1171 | 3 | 2015-11-10 12:21:39 |
| 2546 | 1148 | 3 | 2015-11-10 12:28:07 |
| 2547 | 1143 | 1 | 2015-11-10 12:28:45 |
| 2548 | 1167 | 1 | 2015-11-10 12:29:22 |
| 2549 | 1170 | 1 | 2015-11-10 12:31:46 |
| 2550 | 1136 | 1 | 2015-11-10 12:34:28 |
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;