Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 3,701–3,725 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 3701 | 1694 | 2 | 2016-03-18 13:49:26 |
| 3702 | 1726 | 2 | 2016-03-18 13:49:45 |
| 3703 | 1700 | 2 | 2016-03-18 13:49:49 |
| 3704 | 1704 | 2 | 2016-03-18 13:49:56 |
| 3705 | 1720 | 2 | 2016-03-18 13:50:15 |
| 3706 | 1697 | 2 | 2016-03-18 13:56:19 |
| 3707 | 1709 | 2 | 2016-03-18 13:57:00 |
| 3708 | 1707 | 2 | 2016-03-18 13:57:43 |
| 3709 | 1727 | 2 | 2016-03-18 14:04:02 |
| 3710 | 1710 | 2 | 2016-03-18 14:07:25 |
| 3711 | 1712 | 2 | 2016-03-18 14:09:21 |
| 3712 | 1706 | 3 | 2016-03-18 14:10:17 |
| 3713 | 1716 | 2 | 2016-03-18 14:10:55 |
| 3714 | 1711 | 3 | 2016-03-18 14:12:42 |
| 3715 | 1717 | 2 | 2016-03-18 14:13:01 |
| 3716 | 1702 | 2 | 2016-03-18 14:15:03 |
| 3717 | 1690 | 3 | 2016-03-18 14:15:25 |
| 3718 | 1695 | 2 | 2016-03-18 14:15:46 |
| 3719 | 1724 | 2 | 2016-03-18 14:17:52 |
| 3720 | 1703 | 3 | 2016-03-18 14:18:20 |
| 3721 | 1692 | 2 | 2016-03-18 14:19:16 |
| 3722 | 1726 | 3 | 2016-03-18 14:20:52 |
| 3723 | 1714 | 2 | 2016-03-18 14:21:48 |
| 3724 | 1713 | 2 | 2016-03-18 14:23:12 |
| 3725 | 1723 | 2 | 2016-03-18 14:23:25 |
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;