Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 1,801–1,825 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 1801 | 1028 | 2 | 2015-08-25 10:37:28 |
| 1802 | 1027 | 2 | 2015-08-25 10:39:09 |
| 1803 | 1028 | 3 | 2015-08-25 11:16:23 |
| 1804 | 1027 | 3 | 2015-08-25 11:56:45 |
| 1805 | 1028 | 1 | 2015-08-25 12:11:40 |
| 1806 | 1028 | 3 | 2015-08-25 12:41:28 |
| 1807 | 999 | 3 | 2015-08-27 11:00:32 |
| 1808 | 999 | 2 | 2015-08-27 12:01:00 |
| 1809 | 1031 | 1 | 2015-08-27 15:12:28 |
| 1810 | 1030 | 1 | 2015-08-27 15:27:21 |
| 1811 | 979 | 2 | 2015-08-27 15:57:01 |
| 1812 | 981 | 2 | 2015-08-27 15:58:20 |
| 1813 | 980 | 2 | 2015-08-27 16:02:29 |
| 1814 | 979 | 3 | 2015-08-27 16:30:54 |
| 1815 | 980 | 3 | 2015-08-27 16:34:09 |
| 1816 | 981 | 3 | 2015-08-27 16:41:45 |
| 1817 | 1017 | 2 | 2015-08-28 09:11:27 |
| 1818 | 1016 | 3 | 2015-08-28 09:12:49 |
| 1819 | 1018 | 2 | 2015-08-28 09:16:14 |
| 1820 | 1019 | 2 | 2015-08-28 09:21:05 |
| 1821 | 1018 | 3 | 2015-08-28 09:45:26 |
| 1822 | 1017 | 3 | 2015-08-28 10:23:27 |
| 1823 | 1019 | 3 | 2015-08-28 10:31:28 |
| 1824 | 1038 | 2 | 2015-08-28 12:51:10 |
| 1825 | 1036 | 1 | 2015-08-28 12:51:32 |
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;