Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 4,476–4,500 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 4476 | 2378 | 2 | 2016-06-16 13:16:34 |
| 4477 | 2377 | 2 | 2016-06-16 13:16:41 |
| 4478 | 2377 | 1 | 2016-06-16 13:47:38 |
| 4479 | 2378 | 1 | 2016-06-16 13:57:05 |
| 4480 | 2378 | 3 | 2016-06-16 14:44:18 |
| 4481 | 2377 | 3 | 2016-06-16 15:15:43 |
| 4482 | 2381 | 2 | 2016-06-16 16:44:12 |
| 4483 | 2380 | 2 | 2016-06-16 16:47:03 |
| 4484 | 2379 | 2 | 2016-06-16 16:50:31 |
| 4485 | 2384 | 1 | 2016-06-17 10:28:25 |
| 4486 | 2383 | 1 | 2016-06-17 10:29:01 |
| 4487 | 2385 | 1 | 2016-06-17 10:34:32 |
| 4488 | 2382 | 1 | 2016-06-17 10:37:03 |
| 4489 | 2383 | 2 | 2016-06-17 11:31:12 |
| 4490 | 2385 | 2 | 2016-06-17 11:36:34 |
| 4491 | 2382 | 2 | 2016-06-17 11:49:05 |
| 4492 | 2384 | 2 | 2016-06-17 12:03:24 |
| 4493 | 2383 | 3 | 2016-06-17 12:38:22 |
| 4494 | 2385 | 3 | 2016-06-17 12:44:28 |
| 4495 | 2382 | 3 | 2016-06-17 13:10:36 |
| 4496 | 2384 | 3 | 2016-06-17 13:16:43 |
| 4497 | 2389 | 2 | 2016-06-18 12:03:40 |
| 4498 | 2387 | 2 | 2016-06-18 12:03:59 |
| 4499 | 2388 | 2 | 2016-06-18 12:15:21 |
| 4500 | 2389 | 3 | 2016-06-18 13:01:09 |
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;