Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 3,401–3,425 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 3401 | 1772 | 1 | 2016-02-04 12:39:55 |
| 3402 | 1771 | 2 | 2016-02-04 12:41:42 |
| 3403 | 1771 | 3 | 2016-02-04 13:27:48 |
| 3404 | 1772 | 2 | 2016-02-04 14:05:30 |
| 3405 | 1771 | 1 | 2016-02-04 14:25:40 |
| 3406 | 1772 | 3 | 2016-02-04 14:35:15 |
| 3407 | 1771 | 3 | 2016-02-04 14:53:52 |
| 3408 | 1779 | 3 | 2016-02-07 11:20:47 |
| 3409 | 1780 | 2 | 2016-02-07 11:33:09 |
| 3410 | 1781 | 3 | 2016-02-07 13:39:32 |
| 3411 | 1783 | 2 | 2016-02-09 12:41:26 |
| 3412 | 1784 | 2 | 2016-02-09 12:41:37 |
| 3413 | 1782 | 2 | 2016-02-09 12:47:06 |
| 3414 | 1783 | 1 | 2016-02-09 13:20:33 |
| 3415 | 1784 | 1 | 2016-02-09 13:23:44 |
| 3416 | 1782 | 1 | 2016-02-09 13:31:20 |
| 3417 | 1785 | 3 | 2016-02-09 13:47:51 |
| 3418 | 1786 | 3 | 2016-02-09 13:55:35 |
| 3419 | 1786 | 1 | 2016-02-09 15:14:59 |
| 3420 | 1785 | 1 | 2016-02-09 15:22:20 |
| 3421 | 1787 | 2 | 2016-02-11 12:34:20 |
| 3422 | 1787 | 1 | 2016-02-11 13:47:39 |
| 3423 | 1787 | 3 | 2016-02-11 14:17:06 |
| 3424 | 1788 | 2 | 2016-02-13 11:16:33 |
| 3425 | 1789 | 2 | 2016-02-13 11:21:44 |
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;