Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 1,726–1,750 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 1726 | 976 | 2 | 2015-08-17 10:10:10 |
| 1727 | 977 | 2 | 2015-08-17 10:16:07 |
| 1728 | 978 | 3 | 2015-08-17 10:53:41 |
| 1729 | 978 | 1 | 2015-08-17 12:17:15 |
| 1730 | 919 | 2 | 2015-08-18 09:45:54 |
| 1731 | 983 | 3 | 2015-08-18 10:46:02 |
| 1732 | 984 | 3 | 2015-08-18 10:59:39 |
| 1733 | 983 | 2 | 2015-08-18 11:38:41 |
| 1734 | 984 | 2 | 2015-08-18 11:55:41 |
| 1735 | 983 | 1 | 2015-08-18 12:19:45 |
| 1736 | 984 | 1 | 2015-08-18 12:25:24 |
| 1737 | 985 | 2 | 2015-08-18 14:59:33 |
| 1738 | 986 | 2 | 2015-08-18 15:13:34 |
| 1739 | 986 | 3 | 2015-08-18 15:48:05 |
| 1740 | 991 | 2 | 2015-08-20 11:17:28 |
| 1741 | 991 | 1 | 2015-08-20 12:08:31 |
| 1742 | 991 | 2 | 2015-08-20 13:21:13 |
| 1743 | 995 | 1 | 2015-08-20 13:21:58 |
| 1744 | 993 | 1 | 2015-08-20 13:22:04 |
| 1745 | 992 | 2 | 2015-08-20 13:22:47 |
| 1746 | 994 | 1 | 2015-08-20 13:29:52 |
| 1747 | 993 | 2 | 2015-08-20 13:55:50 |
| 1748 | 995 | 2 | 2015-08-20 14:18:45 |
| 1749 | 994 | 2 | 2015-08-20 14:23:19 |
| 1750 | 993 | 1 | 2015-08-20 14:53:17 |
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;