Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 11,226–11,250 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 11226 | 5777 | 2 | 2018-05-15 10:20:59 |
| 11227 | 5776 | 2 | 2018-05-15 10:24:12 |
| 11228 | 5779 | 1 | 2018-05-15 10:24:48 |
| 11229 | 5782 | 3 | 2018-05-15 10:28:18 |
| 11230 | 5781 | 1 | 2018-05-15 10:28:28 |
| 11231 | 5780 | 1 | 2018-05-15 10:29:38 |
| 11232 | 5775 | 3 | 2018-05-15 10:49:06 |
| 11233 | 5689 | 3 | 2018-05-16 10:10:48 |
| 11234 | 5689 | 2 | 2018-05-16 10:57:32 |
| 11235 | 5747 | 2 | 2018-05-16 11:15:23 |
| 11236 | 5745 | 2 | 2018-05-16 11:20:12 |
| 11237 | 5746 | 2 | 2018-05-16 11:26:25 |
| 11238 | 5786 | 2 | 2018-05-16 11:37:21 |
| 11239 | 5785 | 2 | 2018-05-16 11:47:49 |
| 11240 | 5745 | 3 | 2018-05-16 11:55:06 |
| 11241 | 5746 | 3 | 2018-05-16 12:04:38 |
| 11242 | 5689 | 3 | 2018-05-16 12:11:09 |
| 11243 | 5785 | 3 | 2018-05-16 12:26:54 |
| 11244 | 5745 | 1 | 2018-05-16 12:35:48 |
| 11245 | 5747 | 3 | 2018-05-16 12:45:16 |
| 11246 | 5786 | 3 | 2018-05-16 12:52:09 |
| 11247 | 5746 | 1 | 2018-05-16 12:58:54 |
| 11248 | 5747 | 1 | 2018-05-16 13:21:40 |
| 11249 | 5785 | 2 | 2018-05-16 14:01:13 |
| 11250 | 5786 | 2 | 2018-05-16 14:09:27 |
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;