Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 12,701–12,725 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 12701 | 5931 | 2 | 2018-08-27 12:09:11 |
| 12702 | 5907 | 2 | 2018-08-27 12:09:39 |
| 12703 | 5914 | 2 | 2018-08-27 12:09:51 |
| 12704 | 5916 | 2 | 2018-08-27 12:10:55 |
| 12705 | 5915 | 2 | 2018-08-27 12:11:15 |
| 12706 | 5729 | 3 | 2018-08-27 12:11:24 |
| 12707 | 5713 | 3 | 2018-08-27 12:11:54 |
| 12708 | 5901 | 2 | 2018-08-27 12:12:35 |
| 12709 | 5921 | 3 | 2018-08-27 12:12:54 |
| 12710 | 5902 | 2 | 2018-08-27 12:16:47 |
| 12711 | 5925 | 2 | 2018-08-27 12:19:05 |
| 12712 | 5908 | 2 | 2018-08-27 12:21:06 |
| 12713 | 5917 | 2 | 2018-08-27 12:21:15 |
| 12714 | 5919 | 2 | 2018-08-27 12:22:00 |
| 12715 | 5906 | 2 | 2018-08-27 12:22:10 |
| 12716 | 5924 | 2 | 2018-08-27 12:22:57 |
| 12717 | 5933 | 2 | 2018-08-27 12:24:20 |
| 12718 | 5927 | 3 | 2018-08-27 12:24:23 |
| 12719 | 5918 | 2 | 2018-08-27 12:24:24 |
| 12720 | 5718 | 3 | 2018-08-27 12:25:24 |
| 12721 | 5922 | 2 | 2018-08-27 12:25:51 |
| 12722 | 5903 | 2 | 2018-08-27 12:27:53 |
| 12723 | 5910 | 2 | 2018-08-27 12:29:34 |
| 12724 | 5907 | 3 | 2018-08-27 12:35:13 |
| 12725 | 5936 | 3 | 2018-08-27 12:36:24 |
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;