Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 19,051–19,075 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 19051 | 9620 | 1 | 2019-12-29 11:24:39 |
| 19052 | 9622 | 2 | 2019-12-29 11:27:08 |
| 19053 | 9590 | 2 | 2019-12-29 13:35:43 |
| 19054 | 9624 | 3 | 2019-12-30 09:12:27 |
| 19055 | 9623 | 1 | 2019-12-30 09:27:09 |
| 19056 | 9525 | 2 | 2019-12-30 09:53:35 |
| 19057 | 9524 | 2 | 2019-12-30 09:53:56 |
| 19058 | 9623 | 3 | 2019-12-30 09:57:30 |
| 19059 | 9625 | 3 | 2019-12-30 11:11:13 |
| 19060 | 9625 | 1 | 2019-12-30 11:51:40 |
| 19061 | 9581 | 2 | 2019-12-30 11:54:23 |
| 19062 | 9627 | 3 | 2019-12-30 12:06:00 |
| 19063 | 9626 | 3 | 2019-12-30 12:07:29 |
| 19064 | 9581 | 3 | 2019-12-30 13:06:02 |
| 19065 | 9626 | 1 | 2019-12-30 13:33:07 |
| 19066 | 9627 | 1 | 2019-12-30 13:34:06 |
| 19067 | 9581 | 2 | 2019-12-30 13:34:40 |
| 19068 | 9627 | 2 | 2019-12-30 14:13:31 |
| 19069 | 9626 | 2 | 2019-12-30 14:28:42 |
| 19070 | 9479 | 2 | 2019-12-31 11:42:51 |
| 19071 | 9479 | 1 | 2019-12-31 13:14:30 |
| 19072 | 9610 | 2 | 2020-01-01 10:08:59 |
| 19073 | 9609 | 2 | 2020-01-01 10:18:05 |
| 19074 | 9611 | 1 | 2020-01-01 10:18:12 |
| 19075 | 9613 | 2 | 2020-01-01 10:20: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;