Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 6,501–6,525 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 6501 | 3506 | 2 | 2017-02-05 14:41:40 |
| 6502 | 3513 | 3 | 2017-02-06 09:25:50 |
| 6503 | 3513 | 2 | 2017-02-06 10:50:57 |
| 6504 | 3480 | 2 | 2017-02-06 11:41:40 |
| 6505 | 3481 | 2 | 2017-02-06 11:47:59 |
| 6506 | 3495 | 2 | 2017-02-07 10:35:33 |
| 6507 | 3496 | 2 | 2017-02-07 10:39:08 |
| 6508 | 3495 | 3 | 2017-02-07 11:37:59 |
| 6509 | 3496 | 3 | 2017-02-07 11:42:25 |
| 6510 | 3496 | 2 | 2017-02-07 12:37:23 |
| 6511 | 3495 | 2 | 2017-02-07 12:47:07 |
| 6512 | 3496 | 1 | 2017-02-07 13:09:06 |
| 6513 | 3495 | 1 | 2017-02-07 14:01:57 |
| 6514 | 3482 | 2 | 2017-02-08 10:51:08 |
| 6515 | 3482 | 3 | 2017-02-08 11:34:20 |
| 6516 | 3521 | 1 | 2017-02-11 11:52:16 |
| 6517 | 3522 | 1 | 2017-02-11 11:56:40 |
| 6518 | 3521 | 3 | 2017-02-11 12:52:40 |
| 6519 | 3522 | 3 | 2017-02-11 13:25:53 |
| 6520 | 3521 | 1 | 2017-02-11 13:43:34 |
| 6521 | 3524 | 1 | 2017-02-11 13:58:14 |
| 6522 | 3522 | 1 | 2017-02-11 14:04:00 |
| 6523 | 3523 | 1 | 2017-02-11 14:14:41 |
| 6524 | 3522 | 2 | 2017-02-11 14:31:58 |
| 6525 | 3523 | 2 | 2017-02-11 14:41: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;