Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 15,801–15,825 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 15801 | 8080 | 2 | 2019-04-24 13:39:56 |
| 15802 | 8079 | 1 | 2019-04-24 14:22:32 |
| 15803 | 8078 | 1 | 2019-04-24 14:47:20 |
| 15804 | 8097 | 3 | 2019-04-25 09:45:21 |
| 15805 | 8098 | 1 | 2019-04-25 09:50:08 |
| 15806 | 8093 | 2 | 2019-04-25 10:06:43 |
| 15807 | 8094 | 2 | 2019-04-25 10:07:56 |
| 15808 | 8098 | 3 | 2019-04-25 10:18:46 |
| 15809 | 8097 | 2 | 2019-04-25 10:27:41 |
| 15810 | 8094 | 1 | 2019-04-25 10:40:11 |
| 15811 | 8098 | 2 | 2019-04-25 10:58:46 |
| 15812 | 8093 | 1 | 2019-04-25 11:30:04 |
| 15813 | 8097 | 3 | 2019-04-25 11:30:09 |
| 15814 | 8103 | 2 | 2019-04-25 12:39:00 |
| 15815 | 8102 | 2 | 2019-04-25 12:40:36 |
| 15816 | 8124 | 2 | 2019-04-26 10:29:58 |
| 15817 | 8127 | 2 | 2019-04-26 10:32:55 |
| 15818 | 8133 | 2 | 2019-04-26 10:35:21 |
| 15819 | 8126 | 2 | 2019-04-26 10:35:22 |
| 15820 | 8125 | 2 | 2019-04-26 10:36:07 |
| 15821 | 8127 | 3 | 2019-04-26 11:05:56 |
| 15822 | 8125 | 3 | 2019-04-26 11:06:15 |
| 15823 | 8126 | 3 | 2019-04-26 11:33:01 |
| 15824 | 8127 | 1 | 2019-04-26 11:49:14 |
| 15825 | 8124 | 3 | 2019-04-26 11:58:44 |
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;