Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 4,776–4,800 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 4776 | 1897 | 3 | 2016-07-01 15:55:50 |
| 4777 | 1918 | 3 | 2016-07-01 15:56:04 |
| 4778 | 1934 | 3 | 2016-07-01 15:57:34 |
| 4779 | 2397 | 1 | 2016-07-01 15:59:45 |
| 4780 | 1912 | 3 | 2016-07-01 15:59:47 |
| 4781 | 1913 | 3 | 2016-07-01 16:00:53 |
| 4782 | 1923 | 3 | 2016-07-01 16:02:22 |
| 4783 | 1894 | 3 | 2016-07-01 16:03:25 |
| 4784 | 1944 | 3 | 2016-07-01 16:08:35 |
| 4785 | 1924 | 3 | 2016-07-01 16:08:45 |
| 4786 | 1899 | 3 | 2016-07-01 16:09:37 |
| 4787 | 1948 | 3 | 2016-07-01 16:13:45 |
| 4788 | 1943 | 3 | 2016-07-01 16:15:15 |
| 4789 | 1938 | 3 | 2016-07-01 16:16:07 |
| 4790 | 1903 | 3 | 2016-07-01 16:19:38 |
| 4791 | 1933 | 3 | 2016-07-01 16:20:35 |
| 4792 | 1939 | 3 | 2016-07-01 16:20:48 |
| 4793 | 1906 | 3 | 2016-07-01 16:24:49 |
| 4794 | 1905 | 3 | 2016-07-01 16:25:10 |
| 4795 | 1901 | 3 | 2016-07-01 16:28:08 |
| 4796 | 1904 | 3 | 2016-07-01 16:29:38 |
| 4797 | 1946 | 3 | 2016-07-01 16:33:05 |
| 4798 | 1919 | 3 | 2016-07-01 16:33:07 |
| 4799 | 1930 | 3 | 2016-07-01 16:39:23 |
| 4800 | 1921 | 3 | 2016-07-01 16:42:24 |
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;