Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 3,376–3,400 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 3376 | 1767 | 3 | 2016-01-30 13:01:55 |
| 3377 | 1768 | 2 | 2016-01-30 13:08:07 |
| 3378 | 1768 | 3 | 2016-01-30 13:34:23 |
| 3379 | 1769 | 1 | 2016-01-30 13:38:22 |
| 3380 | 1768 | 2 | 2016-01-30 14:23:07 |
| 3381 | 1767 | 1 | 2016-01-30 14:26:08 |
| 3382 | 1768 | 3 | 2016-01-30 15:23:51 |
| 3383 | 1768 | 1 | 2016-01-30 16:41:26 |
| 3384 | 1770 | 1 | 2016-01-30 17:02:21 |
| 3385 | 1770 | 3 | 2016-01-30 17:30:20 |
| 3386 | 1743 | 3 | 2016-01-31 10:17:35 |
| 3387 | 1743 | 1 | 2016-01-31 11:44:34 |
| 3388 | 1743 | 3 | 2016-01-31 12:51:51 |
| 3389 | 1542 | 2 | 2016-01-31 15:36:53 |
| 3390 | 1541 | 2 | 2016-01-31 15:44:07 |
| 3391 | 1541 | 3 | 2016-01-31 16:17:17 |
| 3392 | 1542 | 3 | 2016-01-31 16:21:32 |
| 3393 | 1775 | 2 | 2016-02-02 09:54:24 |
| 3394 | 1775 | 3 | 2016-02-02 10:39:20 |
| 3395 | 1777 | 2 | 2016-02-03 11:16:23 |
| 3396 | 1776 | 2 | 2016-02-03 11:18:24 |
| 3397 | 1776 | 1 | 2016-02-03 11:58:34 |
| 3398 | 1777 | 3 | 2016-02-03 12:49:28 |
| 3399 | 1776 | 3 | 2016-02-03 13:05:00 |
| 3400 | 1776 | 2 | 2016-02-03 14:00:08 |
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;