Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 1,826–1,850 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 1826 | 1039 | 1 | 2015-08-28 12:51:36 |
| 1827 | 1037 | 1 | 2015-08-28 12:52:53 |
| 1828 | 1041 | 2 | 2015-08-28 13:06:40 |
| 1829 | 1040 | 2 | 2015-08-28 13:10:22 |
| 1830 | 1040 | 3 | 2015-08-28 14:12:38 |
| 1831 | 1040 | 1 | 2015-08-28 15:09:34 |
| 1832 | 1040 | 3 | 2015-08-28 16:05:31 |
| 1833 | 1046 | 2 | 2015-08-29 11:49:24 |
| 1834 | 1047 | 3 | 2015-08-29 11:52:10 |
| 1835 | 1045 | 2 | 2015-08-29 11:52:11 |
| 1836 | 931 | 1 | 2015-08-29 12:32:52 |
| 1837 | 1047 | 2 | 2015-08-29 12:34:32 |
| 1838 | 929 | 3 | 2015-08-29 12:34:45 |
| 1839 | 930 | 2 | 2015-08-29 12:41:34 |
| 1840 | 997 | 2 | 2015-08-29 12:43:55 |
| 1841 | 1046 | 3 | 2015-08-29 12:47:05 |
| 1842 | 996 | 1 | 2015-08-29 12:48:19 |
| 1843 | 998 | 2 | 2015-08-29 12:50:49 |
| 1844 | 1048 | 2 | 2015-08-29 13:18:45 |
| 1845 | 930 | 1 | 2015-08-29 13:19:50 |
| 1846 | 1045 | 3 | 2015-08-29 13:22:00 |
| 1847 | 929 | 1 | 2015-08-29 13:48:09 |
| 1848 | 997 | 1 | 2015-08-29 14:13:49 |
| 1849 | 998 | 1 | 2015-08-29 14:17:37 |
| 1850 | 996 | 2 | 2015-08-29 14:21:47 |
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;