Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 1,751–1,775 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 1751 | 995 | 1 | 2015-08-20 15:33:35 |
| 1752 | 994 | 1 | 2015-08-20 15:40:59 |
| 1753 | 993 | 3 | 2015-08-20 16:01:50 |
| 1754 | 995 | 3 | 2015-08-20 16:08:35 |
| 1755 | 994 | 3 | 2015-08-20 17:00:34 |
| 1756 | 951 | 2 | 2015-08-21 10:40:59 |
| 1757 | 952 | 2 | 2015-08-21 10:50:08 |
| 1758 | 951 | 3 | 2015-08-21 11:32:46 |
| 1759 | 952 | 3 | 2015-08-21 11:36:06 |
| 1760 | 1000 | 2 | 2015-08-21 15:21:36 |
| 1761 | 1000 | 3 | 2015-08-21 16:07:28 |
| 1762 | 1004 | 3 | 2015-08-21 16:15:40 |
| 1763 | 1003 | 2 | 2015-08-21 16:17:52 |
| 1764 | 1001 | 2 | 2015-08-21 16:17:56 |
| 1765 | 1002 | 3 | 2015-08-21 16:22:01 |
| 1766 | 1000 | 2 | 2015-08-21 17:05:26 |
| 1767 | 1004 | 1 | 2015-08-21 17:11:48 |
| 1768 | 1002 | 1 | 2015-08-21 17:12:16 |
| 1769 | 1003 | 1 | 2015-08-21 17:23:48 |
| 1770 | 1002 | 2 | 2015-08-21 17:41:26 |
| 1771 | 987 | 2 | 2015-08-22 10:36:23 |
| 1772 | 987 | 3 | 2015-08-22 11:42:16 |
| 1773 | 987 | 1 | 2015-08-22 12:54:50 |
| 1774 | 1015 | 2 | 2015-08-23 10:03:04 |
| 1775 | 1015 | 3 | 2015-08-23 11:17:41 |
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;