Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 16,676–16,700 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 16676 | 8497 | 2 | 2019-07-06 15:16:25 |
| 16677 | 8500 | 3 | 2019-07-06 15:30:31 |
| 16678 | 8501 | 1 | 2019-07-06 15:37:13 |
| 16679 | 8501 | 3 | 2019-07-06 16:21:19 |
| 16680 | 8504 | 1 | 2019-07-07 10:23:11 |
| 16681 | 8436 | 3 | 2019-07-07 10:25:10 |
| 16682 | 8503 | 2 | 2019-07-07 10:35:28 |
| 16683 | 8436 | 2 | 2019-07-07 11:21:05 |
| 16684 | 8504 | 2 | 2019-07-07 11:30:50 |
| 16685 | 8505 | 2 | 2019-07-07 13:21:45 |
| 16686 | 8505 | 1 | 2019-07-07 14:56:02 |
| 16687 | 8505 | 3 | 2019-07-07 16:03:04 |
| 16688 | 8505 | 1 | 2019-07-07 16:33:28 |
| 16689 | 8505 | 3 | 2019-07-07 17:42:08 |
| 16690 | 8506 | 3 | 2019-07-08 09:14:23 |
| 16691 | 8457 | 2 | 2019-07-08 09:41:24 |
| 16692 | 8459 | 2 | 2019-07-08 09:44:19 |
| 16693 | 8506 | 1 | 2019-07-08 09:45:25 |
| 16694 | 8458 | 2 | 2019-07-08 09:45:48 |
| 16695 | 8456 | 2 | 2019-07-08 09:55:19 |
| 16696 | 8457 | 3 | 2019-07-08 10:27:38 |
| 16697 | 8456 | 3 | 2019-07-08 10:54:49 |
| 16698 | 8458 | 3 | 2019-07-08 11:19:57 |
| 16699 | 8509 | 1 | 2019-07-08 11:28:59 |
| 16700 | 8457 | 1 | 2019-07-08 11:32:47 |
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;