Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 9,951–9,975 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 9951 | 5011 | 2 | 2018-01-19 14:01:18 |
| 9952 | 5030 | 2 | 2018-01-19 14:02:22 |
| 9953 | 5001 | 2 | 2018-01-19 14:02:53 |
| 9954 | 5008 | 2 | 2018-01-19 14:03:13 |
| 9955 | 5016 | 2 | 2018-01-19 14:06:33 |
| 9956 | 5012 | 2 | 2018-01-19 14:06:48 |
| 9957 | 5003 | 2 | 2018-01-19 14:07:20 |
| 9958 | 5020 | 2 | 2018-01-19 14:08:27 |
| 9959 | 5005 | 2 | 2018-01-19 14:09:15 |
| 9960 | 4993 | 2 | 2018-01-19 14:10:40 |
| 9961 | 5028 | 2 | 2018-01-19 14:12:10 |
| 9962 | 5021 | 2 | 2018-01-19 14:12:17 |
| 9963 | 5000 | 2 | 2018-01-19 14:12:30 |
| 9964 | 5004 | 2 | 2018-01-19 14:14:18 |
| 9965 | 5027 | 2 | 2018-01-19 14:19:19 |
| 9966 | 5014 | 2 | 2018-01-19 14:23:38 |
| 9967 | 4998 | 2 | 2018-01-19 14:24:17 |
| 9968 | 5026 | 2 | 2018-01-19 14:25:18 |
| 9969 | 5010 | 3 | 2018-01-19 14:25:41 |
| 9970 | 5006 | 2 | 2018-01-19 14:27:22 |
| 9971 | 4999 | 2 | 2018-01-19 14:33:57 |
| 9972 | 5017 | 2 | 2018-01-19 14:35:34 |
| 9973 | 5005 | 3 | 2018-01-19 14:36:30 |
| 9974 | 4997 | 2 | 2018-01-19 14:38:46 |
| 9975 | 5013 | 2 | 2018-01-19 14:39:14 |
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;