Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 4,076–4,100 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 4076 | 2122 | 2 | 2016-05-02 09:28:15 |
| 4077 | 2123 | 2 | 2016-05-02 09:33:56 |
| 4078 | 2097 | 1 | 2016-05-02 09:57:37 |
| 4079 | 2099 | 1 | 2016-05-02 10:03:05 |
| 4080 | 2096 | 1 | 2016-05-02 10:08:11 |
| 4081 | 2098 | 1 | 2016-05-02 10:12:30 |
| 4082 | 2127 | 2 | 2016-05-02 10:15:04 |
| 4083 | 2126 | 1 | 2016-05-02 10:23:29 |
| 4084 | 2123 | 1 | 2016-05-02 10:47:20 |
| 4085 | 2127 | 1 | 2016-05-02 10:48:33 |
| 4086 | 2098 | 3 | 2016-05-02 10:49:43 |
| 4087 | 2124 | 3 | 2016-05-02 10:54:05 |
| 4088 | 2125 | 3 | 2016-05-02 10:58:46 |
| 4089 | 2099 | 3 | 2016-05-02 11:08:58 |
| 4090 | 2123 | 3 | 2016-05-02 11:14:18 |
| 4091 | 2127 | 3 | 2016-05-02 11:19:36 |
| 4092 | 2097 | 3 | 2016-05-02 11:20:57 |
| 4093 | 2096 | 3 | 2016-05-02 11:38:36 |
| 4094 | 2126 | 2 | 2016-05-02 11:38:38 |
| 4095 | 2099 | 2 | 2016-05-02 11:47:58 |
| 4096 | 2127 | 1 | 2016-05-02 12:05:12 |
| 4097 | 2096 | 2 | 2016-05-02 12:11:55 |
| 4098 | 2098 | 2 | 2016-05-02 12:14:52 |
| 4099 | 2097 | 2 | 2016-05-02 12:28:21 |
| 4100 | 2099 | 1 | 2016-05-02 12:37:38 |
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;