Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 14,076–14,100 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 14076 | 6965 | 3 | 2018-12-04 15:44:06 |
| 14077 | 6966 | 3 | 2018-12-04 15:44:51 |
| 14078 | 6949 | 3 | 2018-12-04 15:51:26 |
| 14079 | 6997 | 3 | 2018-12-04 15:51:45 |
| 14080 | 6986 | 3 | 2018-12-04 15:53:40 |
| 14081 | 6992 | 3 | 2018-12-04 15:55:08 |
| 14082 | 7231 | 2 | 2018-12-05 10:49:37 |
| 14083 | 7232 | 2 | 2018-12-05 10:57:48 |
| 14084 | 7231 | 3 | 2018-12-05 11:23:20 |
| 14085 | 7215 | 2 | 2018-12-05 11:53:40 |
| 14086 | 7216 | 2 | 2018-12-05 12:02:55 |
| 14087 | 7232 | 3 | 2018-12-05 12:08:26 |
| 14088 | 7215 | 3 | 2018-12-05 13:16:03 |
| 14089 | 7215 | 2 | 2018-12-05 14:40:52 |
| 14090 | 7235 | 2 | 2018-12-06 11:09:06 |
| 14091 | 7233 | 2 | 2018-12-06 11:10:32 |
| 14092 | 7234 | 2 | 2018-12-06 11:10:32 |
| 14093 | 7236 | 2 | 2018-12-06 11:14:09 |
| 14094 | 7235 | 1 | 2018-12-06 11:52:50 |
| 14095 | 7234 | 1 | 2018-12-06 12:13:23 |
| 14096 | 7233 | 1 | 2018-12-06 12:33:28 |
| 14097 | 7236 | 1 | 2018-12-06 12:42:02 |
| 14098 | 7242 | 3 | 2018-12-07 09:25:58 |
| 14099 | 7241 | 2 | 2018-12-07 09:32:09 |
| 14100 | 7245 | 1 | 2018-12-07 09:45:30 |
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;