Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 7,051–7,075 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 7051 | 3704 | 2 | 2017-03-31 13:30:11 |
| 7052 | 3707 | 2 | 2017-03-31 13:32:08 |
| 7053 | 3702 | 3 | 2017-03-31 14:10:47 |
| 7054 | 3702 | 2 | 2017-03-31 15:30:32 |
| 7055 | 3711 | 3 | 2017-03-31 16:22:18 |
| 7056 | 3711 | 1 | 2017-03-31 17:25:11 |
| 7057 | 3713 | 2 | 2017-04-01 13:22:48 |
| 7058 | 3712 | 2 | 2017-04-01 13:25:50 |
| 7059 | 3712 | 1 | 2017-04-01 14:20:59 |
| 7060 | 3713 | 1 | 2017-04-01 14:28:19 |
| 7061 | 3712 | 3 | 2017-04-01 15:15:47 |
| 7062 | 3713 | 3 | 2017-04-01 15:31:07 |
| 7063 | 3696 | 2 | 2017-04-04 11:11:54 |
| 7064 | 3695 | 2 | 2017-04-04 11:16:17 |
| 7065 | 3696 | 1 | 2017-04-04 12:01:59 |
| 7066 | 3695 | 1 | 2017-04-04 12:40:08 |
| 7067 | 3709 | 2 | 2017-04-04 13:55:44 |
| 7068 | 3708 | 2 | 2017-04-04 13:56:24 |
| 7069 | 3710 | 2 | 2017-04-04 13:57:04 |
| 7070 | 3709 | 3 | 2017-04-04 14:53:42 |
| 7071 | 3710 | 3 | 2017-04-04 14:54:57 |
| 7072 | 3708 | 3 | 2017-04-04 14:59:29 |
| 7073 | 3709 | 2 | 2017-04-04 16:01:41 |
| 7074 | 3708 | 2 | 2017-04-04 16:10:34 |
| 7075 | 3710 | 2 | 2017-04-04 16:22:37 |
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;