Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 9,851–9,875 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 9851 | 5036 | 3 | 2018-01-08 14:01:58 |
| 9852 | 5035 | 3 | 2018-01-08 14:57:29 |
| 9853 | 5035 | 1 | 2018-01-08 15:51:19 |
| 9854 | 5125 | 2 | 2018-01-09 11:49:06 |
| 9855 | 5124 | 2 | 2018-01-09 11:50:10 |
| 9856 | 5126 | 2 | 2018-01-10 10:27:36 |
| 9857 | 5126 | 3 | 2018-01-10 11:10:03 |
| 9858 | 5126 | 1 | 2018-01-10 11:36:08 |
| 9859 | 5130 | 1 | 2018-01-11 10:27:03 |
| 9860 | 5131 | 1 | 2018-01-11 10:34:06 |
| 9861 | 5129 | 2 | 2018-01-11 12:09:04 |
| 9862 | 5139 | 2 | 2018-01-12 09:44:09 |
| 9863 | 5138 | 3 | 2018-01-12 09:47:15 |
| 9864 | 5138 | 1 | 2018-01-12 10:16:04 |
| 9865 | 5060 | 2 | 2018-01-12 10:35:49 |
| 9866 | 5140 | 2 | 2018-01-12 15:00:59 |
| 9867 | 5141 | 2 | 2018-01-12 15:03:43 |
| 9868 | 5140 | 3 | 2018-01-12 16:31:13 |
| 9869 | 5141 | 1 | 2018-01-12 16:36:33 |
| 9870 | 5052 | 2 | 2018-01-13 10:23:19 |
| 9871 | 5065 | 2 | 2018-01-13 13:50:15 |
| 9872 | 5065 | 1 | 2018-01-13 15:12:41 |
| 9873 | 5144 | 1 | 2018-01-15 10:28:10 |
| 9874 | 5145 | 1 | 2018-01-15 10:29:33 |
| 9875 | 5143 | 1 | 2018-01-15 10:40: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;