Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 8,851–8,875 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 8851 | 4644 | 3 | 2017-09-19 15:21:59 |
| 8852 | 4645 | 3 | 2017-09-19 16:15:41 |
| 8853 | 4650 | 2 | 2017-09-20 10:10:46 |
| 8854 | 4649 | 2 | 2017-09-20 10:12:25 |
| 8855 | 4196 | 1 | 2017-09-20 12:46:34 |
| 8856 | 4198 | 1 | 2017-09-20 12:47:11 |
| 8857 | 4229 | 1 | 2017-09-20 12:48:13 |
| 8858 | 4211 | 1 | 2017-09-20 12:48:44 |
| 8859 | 4223 | 1 | 2017-09-20 12:49:10 |
| 8860 | 4205 | 1 | 2017-09-20 12:49:42 |
| 8861 | 4210 | 1 | 2017-09-20 12:49:51 |
| 8862 | 4218 | 1 | 2017-09-20 12:49:53 |
| 8863 | 4209 | 1 | 2017-09-20 12:51:28 |
| 8864 | 4201 | 1 | 2017-09-20 12:51:36 |
| 8865 | 4207 | 1 | 2017-09-20 12:51:44 |
| 8866 | 4213 | 1 | 2017-09-20 12:52:43 |
| 8867 | 4235 | 1 | 2017-09-20 12:52:54 |
| 8868 | 4216 | 1 | 2017-09-20 12:53:00 |
| 8869 | 4221 | 1 | 2017-09-20 12:53:19 |
| 8870 | 4220 | 1 | 2017-09-20 12:54:59 |
| 8871 | 4202 | 1 | 2017-09-20 12:55:06 |
| 8872 | 4228 | 1 | 2017-09-20 12:55:06 |
| 8873 | 4214 | 1 | 2017-09-20 12:55:14 |
| 8874 | 4225 | 1 | 2017-09-20 12:55:34 |
| 8875 | 4208 | 1 | 2017-09-20 12:56:27 |
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;