Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 18,426–18,450 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 18426 | 9423 | 2 | 2019-11-24 11:57:31 |
| 18427 | 9436 | 2 | 2019-11-25 10:08:27 |
| 18428 | 9435 | 2 | 2019-11-25 10:17:31 |
| 18429 | 9436 | 1 | 2019-11-25 11:06:34 |
| 18430 | 9435 | 1 | 2019-11-25 11:18:01 |
| 18431 | 9449 | 1 | 2019-11-26 10:44:04 |
| 18432 | 9451 | 1 | 2019-11-26 10:49:32 |
| 18433 | 9452 | 1 | 2019-11-26 10:50:21 |
| 18434 | 9450 | 1 | 2019-11-26 10:53:00 |
| 18435 | 9453 | 1 | 2019-11-26 10:54:22 |
| 18436 | 9451 | 2 | 2019-11-26 11:21:48 |
| 18437 | 9450 | 2 | 2019-11-26 11:33:53 |
| 18438 | 9449 | 2 | 2019-11-26 11:45:46 |
| 18439 | 9453 | 2 | 2019-11-26 11:51:04 |
| 18440 | 9452 | 2 | 2019-11-26 11:56:26 |
| 18441 | 9482 | 2 | 2019-11-28 09:22:02 |
| 18442 | 9481 | 2 | 2019-11-28 09:26:24 |
| 18443 | 9483 | 2 | 2019-11-28 09:30:10 |
| 18444 | 9480 | 2 | 2019-11-28 09:33:02 |
| 18445 | 9376 | 2 | 2019-11-28 09:39:35 |
| 18446 | 9375 | 2 | 2019-11-28 09:40:59 |
| 18447 | 9381 | 1 | 2019-11-28 09:51:58 |
| 18448 | 9482 | 1 | 2019-11-28 10:08:02 |
| 18449 | 9381 | 2 | 2019-11-28 10:19:39 |
| 18450 | 9481 | 1 | 2019-11-28 10:30:16 |
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;