Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 7,076–7,100 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 7076 | 3693 | 1 | 2017-04-05 14:00:50 |
| 7077 | 3693 | 3 | 2017-04-05 15:31:54 |
| 7078 | 3681 | 1 | 2017-04-06 10:52:15 |
| 7079 | 3682 | 1 | 2017-04-06 10:53:19 |
| 7080 | 3682 | 3 | 2017-04-06 11:47:55 |
| 7081 | 3681 | 3 | 2017-04-06 12:14:05 |
| 7082 | 3725 | 2 | 2017-04-06 13:12:35 |
| 7083 | 3726 | 3 | 2017-04-06 13:14:59 |
| 7084 | 3191 | 2 | 2017-04-06 13:26:53 |
| 7085 | 3223 | 2 | 2017-04-06 13:27:50 |
| 7086 | 3224 | 2 | 2017-04-06 13:31:19 |
| 7087 | 3211 | 2 | 2017-04-06 13:31:21 |
| 7088 | 3218 | 2 | 2017-04-06 13:31:55 |
| 7089 | 3234 | 2 | 2017-04-06 13:32:12 |
| 7090 | 3212 | 2 | 2017-04-06 13:32:14 |
| 7091 | 3198 | 2 | 2017-04-06 13:32:24 |
| 7092 | 3229 | 2 | 2017-04-06 13:32:54 |
| 7093 | 3195 | 2 | 2017-04-06 13:33:03 |
| 7094 | 3186 | 2 | 2017-04-06 13:34:19 |
| 7095 | 3219 | 2 | 2017-04-06 13:34:22 |
| 7096 | 3222 | 2 | 2017-04-06 13:34:22 |
| 7097 | 3209 | 2 | 2017-04-06 13:34:28 |
| 7098 | 3217 | 2 | 2017-04-06 13:34:35 |
| 7099 | 3230 | 2 | 2017-04-06 13:34:36 |
| 7100 | 3215 | 2 | 2017-04-06 13:34:40 |
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;