Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 3,326–3,350 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 3326 | 1758 | 1 | 2016-01-23 11:38:24 |
| 3327 | 1755 | 1 | 2016-01-23 11:50:55 |
| 3328 | 1756 | 1 | 2016-01-23 11:59:54 |
| 3329 | 1759 | 1 | 2016-01-23 12:08:31 |
| 3330 | 1760 | 3 | 2016-01-23 12:20:38 |
| 3331 | 1761 | 3 | 2016-01-23 12:20:45 |
| 3332 | 1755 | 2 | 2016-01-23 13:06:20 |
| 3333 | 1761 | 1 | 2016-01-23 13:11:18 |
| 3334 | 1756 | 2 | 2016-01-23 13:11:42 |
| 3335 | 1760 | 1 | 2016-01-23 13:43:34 |
| 3336 | 1761 | 2 | 2016-01-23 13:46:11 |
| 3337 | 1760 | 2 | 2016-01-23 14:53:39 |
| 3338 | 1761 | 3 | 2016-01-23 15:13:47 |
| 3339 | 1760 | 3 | 2016-01-23 16:20:05 |
| 3340 | 1738 | 2 | 2016-01-24 09:59:33 |
| 3341 | 1740 | 2 | 2016-01-24 10:07:55 |
| 3342 | 1739 | 2 | 2016-01-24 10:09:09 |
| 3343 | 1739 | 3 | 2016-01-24 10:42:15 |
| 3344 | 1762 | 1 | 2016-01-24 10:51:26 |
| 3345 | 1740 | 3 | 2016-01-24 11:03:48 |
| 3346 | 1738 | 3 | 2016-01-24 11:07:05 |
| 3347 | 1739 | 2 | 2016-01-24 11:22:34 |
| 3348 | 1738 | 2 | 2016-01-24 11:40:07 |
| 3349 | 1740 | 2 | 2016-01-24 12:08:28 |
| 3350 | 1762 | 2 | 2016-01-24 12:22:00 |
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;