Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 8,726–8,750 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 8726 | 4540 | 3 | 2017-09-06 15:49:06 |
| 8727 | 4551 | 1 | 2017-09-06 15:50:10 |
| 8728 | 4550 | 1 | 2017-09-06 15:58:55 |
| 8729 | 4547 | 2 | 2017-09-06 16:05:35 |
| 8730 | 4541 | 3 | 2017-09-06 16:21:07 |
| 8731 | 4546 | 2 | 2017-09-06 16:29:32 |
| 8732 | 4551 | 2 | 2017-09-06 16:32:52 |
| 8733 | 4548 | 2 | 2017-09-06 16:39:48 |
| 8734 | 4552 | 2 | 2017-09-06 16:59:58 |
| 8735 | 4550 | 2 | 2017-09-06 17:04:53 |
| 8736 | 4545 | 2 | 2017-09-06 17:05:39 |
| 8737 | 4540 | 1 | 2017-09-06 17:10:41 |
| 8738 | 4546 | 3 | 2017-09-06 17:11:12 |
| 8739 | 4547 | 3 | 2017-09-06 17:18:40 |
| 8740 | 4540 | 2 | 2017-09-06 17:43:04 |
| 8741 | 4541 | 2 | 2017-09-06 17:43:15 |
| 8742 | 4366 | 3 | 2017-09-07 13:18:05 |
| 8743 | 4365 | 3 | 2017-09-07 13:28:45 |
| 8744 | 4365 | 1 | 2017-09-07 14:29:31 |
| 8745 | 4366 | 1 | 2017-09-07 14:49:46 |
| 8746 | 4365 | 2 | 2017-09-07 14:56:38 |
| 8747 | 4366 | 2 | 2017-09-07 15:28:35 |
| 8748 | 4561 | 2 | 2017-09-07 16:27:02 |
| 8749 | 4559 | 2 | 2017-09-07 16:35:08 |
| 8750 | 4560 | 2 | 2017-09-07 16:38:42 |
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;