Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 8,901–8,925 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 8901 | 4201 | 2 | 2017-09-20 13:29:18 |
| 8902 | 4222 | 2 | 2017-09-20 13:29:26 |
| 8903 | 4236 | 2 | 2017-09-20 13:31:59 |
| 8904 | 4208 | 2 | 2017-09-20 13:36:50 |
| 8905 | 4206 | 2 | 2017-09-20 13:40:02 |
| 8906 | 4232 | 2 | 2017-09-20 13:41:02 |
| 8907 | 4207 | 2 | 2017-09-20 13:41:24 |
| 8908 | 4203 | 2 | 2017-09-20 13:41:38 |
| 8909 | 4228 | 2 | 2017-09-20 13:43:42 |
| 8910 | 4227 | 2 | 2017-09-20 13:44:04 |
| 8911 | 4230 | 2 | 2017-09-20 13:45:35 |
| 8912 | 4225 | 2 | 2017-09-20 13:46:10 |
| 8913 | 4238 | 2 | 2017-09-20 13:46:13 |
| 8914 | 4214 | 2 | 2017-09-20 13:47:48 |
| 8915 | 4198 | 2 | 2017-09-20 13:48:02 |
| 8916 | 4220 | 2 | 2017-09-20 13:48:27 |
| 8917 | 4211 | 2 | 2017-09-20 13:50:02 |
| 8918 | 4221 | 2 | 2017-09-20 13:51:12 |
| 8919 | 4210 | 2 | 2017-09-20 13:56:41 |
| 8920 | 4235 | 2 | 2017-09-20 13:58:24 |
| 8921 | 4219 | 2 | 2017-09-20 13:58:25 |
| 8922 | 4205 | 2 | 2017-09-20 13:58:50 |
| 8923 | 4229 | 2 | 2017-09-20 13:58:59 |
| 8924 | 4212 | 2 | 2017-09-20 14:00:00 |
| 8925 | 4215 | 2 | 2017-09-20 14:01: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;