Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 15,276–15,300 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 15276 | 7813 | 2 | 2019-03-19 15:02:25 |
| 15277 | 7812 | 2 | 2019-03-19 15:05:32 |
| 15278 | 7877 | 2 | 2019-03-19 15:39:39 |
| 15279 | 7813 | 3 | 2019-03-19 15:39:55 |
| 15280 | 7812 | 3 | 2019-03-19 15:50:42 |
| 15281 | 7813 | 1 | 2019-03-19 17:04:21 |
| 15282 | 7812 | 1 | 2019-03-19 17:20:55 |
| 15283 | 7804 | 2 | 2019-03-20 10:35:41 |
| 15284 | 7795 | 1 | 2019-03-20 11:40:45 |
| 15285 | 7797 | 1 | 2019-03-20 11:43:14 |
| 15286 | 7796 | 1 | 2019-03-20 11:43:33 |
| 15287 | 7875 | 2 | 2019-03-20 11:54:43 |
| 15288 | 7804 | 3 | 2019-03-20 11:55:07 |
| 15289 | 7797 | 3 | 2019-03-20 12:14:50 |
| 15290 | 7796 | 3 | 2019-03-20 12:15:20 |
| 15291 | 7795 | 3 | 2019-03-20 12:46:01 |
| 15292 | 7875 | 1 | 2019-03-20 13:23:01 |
| 15293 | 7885 | 1 | 2019-03-20 14:45:14 |
| 15294 | 7884 | 1 | 2019-03-20 14:48:08 |
| 15295 | 7885 | 3 | 2019-03-20 15:19:22 |
| 15296 | 7884 | 3 | 2019-03-20 15:43:17 |
| 15297 | 7810 | 1 | 2019-03-21 11:49:55 |
| 15298 | 7809 | 1 | 2019-03-21 11:56:32 |
| 15299 | 7881 | 2 | 2019-03-21 13:02:18 |
| 15300 | 7878 | 2 | 2019-03-21 13:02:34 |
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;