Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 1,876–1,900 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 1876 | 1043 | 3 | 2015-08-30 14:22:29 |
| 1877 | 988 | 3 | 2015-08-30 14:23:19 |
| 1878 | 1029 | 2 | 2015-08-30 14:53:32 |
| 1879 | 1043 | 1 | 2015-08-30 15:46:42 |
| 1880 | 1043 | 2 | 2015-08-30 16:32:02 |
| 1881 | 1055 | 2 | 2015-08-31 10:08:31 |
| 1882 | 1057 | 2 | 2015-08-31 10:19:48 |
| 1883 | 1056 | 2 | 2015-08-31 10:36:29 |
| 1884 | 1057 | 3 | 2015-08-31 10:51:58 |
| 1885 | 1055 | 3 | 2015-08-31 11:02:12 |
| 1886 | 1057 | 1 | 2015-08-31 11:30:45 |
| 1887 | 1061 | 3 | 2015-08-31 11:38:58 |
| 1888 | 1060 | 3 | 2015-08-31 11:40:27 |
| 1889 | 1058 | 3 | 2015-08-31 11:45:30 |
| 1890 | 1059 | 3 | 2015-08-31 11:46:45 |
| 1891 | 1056 | 3 | 2015-08-31 11:57:43 |
| 1892 | 1059 | 2 | 2015-08-31 12:19:35 |
| 1893 | 1058 | 2 | 2015-08-31 12:20:28 |
| 1894 | 1061 | 2 | 2015-08-31 12:42:08 |
| 1895 | 1059 | 1 | 2015-08-31 13:02:32 |
| 1896 | 1056 | 1 | 2015-08-31 13:06:53 |
| 1897 | 1060 | 2 | 2015-08-31 13:08:54 |
| 1898 | 1061 | 1 | 2015-08-31 13:25:12 |
| 1899 | 1058 | 1 | 2015-08-31 13:33:11 |
| 1900 | 1059 | 3 | 2015-08-31 14:15:06 |
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;