Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 4,051–4,075 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 4051 | 2115 | 2 | 2016-05-01 09:50:57 |
| 4052 | 2114 | 2 | 2016-05-01 09:52:26 |
| 4053 | 2113 | 2 | 2016-05-01 09:57:27 |
| 4054 | 2116 | 1 | 2016-05-01 09:58:10 |
| 4055 | 2113 | 3 | 2016-05-01 10:37:59 |
| 4056 | 2116 | 3 | 2016-05-01 10:49:07 |
| 4057 | 2115 | 3 | 2016-05-01 11:20:53 |
| 4058 | 2114 | 3 | 2016-05-01 11:27:49 |
| 4059 | 2118 | 3 | 2016-05-01 11:43:34 |
| 4060 | 2117 | 3 | 2016-05-01 11:49:23 |
| 4061 | 2116 | 2 | 2016-05-01 11:55:51 |
| 4062 | 2118 | 2 | 2016-05-01 12:42:27 |
| 4063 | 2116 | 1 | 2016-05-01 12:52:33 |
| 4064 | 2117 | 2 | 2016-05-01 13:08:51 |
| 4065 | 2090 | 3 | 2016-05-01 13:10:33 |
| 4066 | 2092 | 2 | 2016-05-01 13:14:52 |
| 4067 | 2091 | 2 | 2016-05-01 13:19:17 |
| 4068 | 2092 | 3 | 2016-05-01 13:45:20 |
| 4069 | 2092 | 2 | 2016-05-01 14:32:02 |
| 4070 | 2091 | 3 | 2016-05-01 14:34:31 |
| 4071 | 2090 | 1 | 2016-05-01 14:41:25 |
| 4072 | 2091 | 2 | 2016-05-01 15:26:04 |
| 4073 | 2120 | 3 | 2016-05-01 17:20:55 |
| 4074 | 2121 | 3 | 2016-05-01 17:21:20 |
| 4075 | 2120 | 1 | 2016-05-01 17:47:12 |
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;