Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 11,526–11,550 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 11526 | 6059 | 2 | 2018-06-17 12:37:08 |
| 11527 | 6057 | 2 | 2018-06-17 12:38:02 |
| 11528 | 6058 | 2 | 2018-06-17 12:39:38 |
| 11529 | 6056 | 2 | 2018-06-17 12:47:16 |
| 11530 | 6026 | 3 | 2018-06-17 13:00:28 |
| 11531 | 6059 | 3 | 2018-06-17 13:07:06 |
| 11532 | 6057 | 3 | 2018-06-17 13:25:41 |
| 11533 | 6058 | 3 | 2018-06-17 13:43:23 |
| 11534 | 6056 | 3 | 2018-06-17 14:20:09 |
| 11535 | 5866 | 2 | 2018-06-17 16:00:20 |
| 11536 | 5867 | 2 | 2018-06-17 16:04:12 |
| 11537 | 5865 | 2 | 2018-06-17 16:11:25 |
| 11538 | 6061 | 3 | 2018-06-18 16:06:46 |
| 11539 | 6060 | 3 | 2018-06-18 16:14:38 |
| 11540 | 6060 | 2 | 2018-06-18 16:51:40 |
| 11541 | 6061 | 2 | 2018-06-18 17:34:49 |
| 11542 | 6062 | 2 | 2018-06-19 10:52:26 |
| 11543 | 6063 | 2 | 2018-06-19 10:54:29 |
| 11544 | 5957 | 2 | 2018-06-20 10:53:53 |
| 11545 | 5958 | 3 | 2018-06-20 11:02:58 |
| 11546 | 5957 | 3 | 2018-06-20 12:01:07 |
| 11547 | 5958 | 1 | 2018-06-20 12:08:15 |
| 11548 | 5957 | 1 | 2018-06-20 12:55:30 |
| 11549 | 5958 | 3 | 2018-06-20 13:16:54 |
| 11550 | 6067 | 2 | 2018-06-21 09:34:02 |
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;