Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 17,676–17,700 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 17676 | 9015 | 2 | 2019-09-15 12:35:52 |
| 17677 | 8948 | 2 | 2019-09-15 13:10:41 |
| 17678 | 8948 | 3 | 2019-09-15 13:40:28 |
| 17679 | 9084 | 2 | 2019-09-17 12:05:14 |
| 17680 | 8886 | 2 | 2019-09-18 16:14:08 |
| 17681 | 8887 | 2 | 2019-09-18 16:21:33 |
| 17682 | 8885 | 2 | 2019-09-18 16:24:50 |
| 17683 | 8887 | 1 | 2019-09-18 17:31:24 |
| 17684 | 8885 | 1 | 2019-09-18 17:32:55 |
| 17685 | 8886 | 1 | 2019-09-18 17:38:42 |
| 17686 | 8894 | 2 | 2019-09-21 14:38:20 |
| 17687 | 8892 | 3 | 2019-09-21 14:39:32 |
| 17688 | 8893 | 3 | 2019-09-21 14:43:50 |
| 17689 | 8891 | 3 | 2019-09-21 14:44:36 |
| 17690 | 8894 | 3 | 2019-09-21 15:16:13 |
| 17691 | 8894 | 1 | 2019-09-21 15:56:01 |
| 17692 | 9101 | 2 | 2019-09-22 11:52:19 |
| 17693 | 9102 | 2 | 2019-09-22 11:58:19 |
| 17694 | 9100 | 2 | 2019-09-22 12:02:19 |
| 17695 | 9103 | 2 | 2019-09-22 12:02:36 |
| 17696 | 9100 | 3 | 2019-09-22 12:31:07 |
| 17697 | 9097 | 3 | 2019-09-22 12:42:36 |
| 17698 | 9099 | 2 | 2019-09-22 12:46:42 |
| 17699 | 9103 | 3 | 2019-09-22 12:46:46 |
| 17700 | 9098 | 3 | 2019-09-22 12:53:02 |
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;