Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 8,776–8,800 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 8776 | 4537 | 2 | 2017-09-11 11:34:55 |
| 8777 | 4538 | 2 | 2017-09-11 11:51:17 |
| 8778 | 4539 | 1 | 2017-09-11 12:16:29 |
| 8779 | 4567 | 1 | 2017-09-11 12:34:31 |
| 8780 | 4538 | 1 | 2017-09-11 12:57:14 |
| 8781 | 4537 | 1 | 2017-09-11 12:58:50 |
| 8782 | 4539 | 3 | 2017-09-11 13:00:30 |
| 8783 | 4537 | 2 | 2017-09-11 13:55:56 |
| 8784 | 4538 | 2 | 2017-09-11 13:57:18 |
| 8785 | 4539 | 2 | 2017-09-11 14:22:29 |
| 8786 | 4538 | 1 | 2017-09-11 14:33:03 |
| 8787 | 4537 | 1 | 2017-09-11 14:54:56 |
| 8788 | 4570 | 2 | 2017-09-11 16:28:58 |
| 8789 | 4528 | 2 | 2017-09-13 10:25:39 |
| 8790 | 4530 | 2 | 2017-09-13 10:28:55 |
| 8791 | 4529 | 2 | 2017-09-13 10:30:27 |
| 8792 | 4527 | 2 | 2017-09-13 10:34:14 |
| 8793 | 4584 | 2 | 2017-09-13 10:45:21 |
| 8794 | 4585 | 2 | 2017-09-13 10:48:15 |
| 8795 | 4583 | 2 | 2017-09-13 10:48:45 |
| 8796 | 4581 | 3 | 2017-09-13 10:50:34 |
| 8797 | 4582 | 2 | 2017-09-13 10:52:59 |
| 8798 | 4585 | 1 | 2017-09-13 11:31:01 |
| 8799 | 4582 | 1 | 2017-09-13 11:35:13 |
| 8800 | 4583 | 1 | 2017-09-13 11:49:21 |
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;