Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 7,151–7,175 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 7151 | 3229 | 3 | 2017-04-06 14:57:21 |
| 7152 | 3199 | 3 | 2017-04-06 14:58:55 |
| 7153 | 3217 | 3 | 2017-04-06 15:02:06 |
| 7154 | 3195 | 3 | 2017-04-06 15:03:56 |
| 7155 | 3215 | 3 | 2017-04-06 15:05:36 |
| 7156 | 3220 | 3 | 2017-04-06 15:11:33 |
| 7157 | 3192 | 3 | 2017-04-06 15:12:41 |
| 7158 | 3729 | 3 | 2017-04-07 15:06:12 |
| 7159 | 3728 | 3 | 2017-04-07 15:06:17 |
| 7160 | 3728 | 2 | 2017-04-07 15:32:17 |
| 7161 | 3729 | 2 | 2017-04-07 16:03:33 |
| 7162 | 3732 | 2 | 2017-04-08 10:34:47 |
| 7163 | 3731 | 2 | 2017-04-08 10:36:53 |
| 7164 | 3731 | 3 | 2017-04-08 11:50:44 |
| 7165 | 3732 | 1 | 2017-04-08 12:10:13 |
| 7166 | 3688 | 2 | 2017-04-08 17:08:49 |
| 7167 | 3687 | 2 | 2017-04-08 17:18:23 |
| 7168 | 3730 | 2 | 2017-04-09 11:49:31 |
| 7169 | 3730 | 3 | 2017-04-09 12:24:50 |
| 7170 | 3741 | 3 | 2017-04-11 11:45:30 |
| 7171 | 3741 | 1 | 2017-04-11 12:54:36 |
| 7172 | 3741 | 3 | 2017-04-11 13:33:04 |
| 7173 | 3741 | 2 | 2017-04-11 14:42:47 |
| 7174 | 3733 | 1 | 2017-04-12 11:43:24 |
| 7175 | 3743 | 2 | 2017-04-12 12:09:18 |
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;