Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 15,551–15,575 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 15551 | 7981 | 1 | 2019-04-13 10:34:10 |
| 15552 | 7980 | 1 | 2019-04-13 10:35:07 |
| 15553 | 7981 | 3 | 2019-04-13 11:14:07 |
| 15554 | 7980 | 3 | 2019-04-13 12:07:18 |
| 15555 | 8071 | 1 | 2019-04-14 09:58:30 |
| 15556 | 8072 | 1 | 2019-04-14 10:00:21 |
| 15557 | 8072 | 2 | 2019-04-14 10:26:41 |
| 15558 | 7911 | 2 | 2019-04-14 10:35:49 |
| 15559 | 7912 | 2 | 2019-04-14 10:46:44 |
| 15560 | 8071 | 2 | 2019-04-14 11:06:28 |
| 15561 | 8072 | 3 | 2019-04-14 11:32:33 |
| 15562 | 8071 | 3 | 2019-04-14 12:10:23 |
| 15563 | 8072 | 2 | 2019-04-14 12:25:48 |
| 15564 | 8061 | 3 | 2019-04-14 12:46:17 |
| 15565 | 8062 | 3 | 2019-04-14 12:52:28 |
| 15566 | 8072 | 3 | 2019-04-14 12:53:07 |
| 15567 | 8071 | 2 | 2019-04-14 13:39:14 |
| 15568 | 8073 | 2 | 2019-04-14 13:52:33 |
| 15569 | 8061 | 2 | 2019-04-14 13:55:39 |
| 15570 | 8076 | 2 | 2019-04-14 13:55:56 |
| 15571 | 8074 | 3 | 2019-04-14 14:04:06 |
| 15572 | 8075 | 2 | 2019-04-14 14:04:32 |
| 15573 | 8062 | 2 | 2019-04-14 14:18:38 |
| 15574 | 8061 | 1 | 2019-04-14 14:35:25 |
| 15575 | 8071 | 3 | 2019-04-14 15:03:44 |
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;