Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 4,626–4,650 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 4626 | 1913 | 2 | 2016-07-01 13:56:04 |
| 4627 | 1937 | 2 | 2016-07-01 13:56:35 |
| 4628 | 1906 | 2 | 2016-07-01 13:57:04 |
| 4629 | 1910 | 2 | 2016-07-01 13:57:15 |
| 4630 | 1894 | 2 | 2016-07-01 13:57:30 |
| 4631 | 1896 | 2 | 2016-07-01 13:57:45 |
| 4632 | 1936 | 2 | 2016-07-01 13:58:01 |
| 4633 | 1908 | 2 | 2016-07-01 13:58:28 |
| 4634 | 1903 | 2 | 2016-07-01 13:58:54 |
| 4635 | 1925 | 2 | 2016-07-01 13:59:07 |
| 4636 | 1895 | 2 | 2016-07-01 14:00:36 |
| 4637 | 1930 | 2 | 2016-07-01 14:01:24 |
| 4638 | 1911 | 2 | 2016-07-01 14:01:31 |
| 4639 | 1924 | 2 | 2016-07-01 14:01:31 |
| 4640 | 1918 | 2 | 2016-07-01 14:01:38 |
| 4641 | 1942 | 2 | 2016-07-01 14:01:50 |
| 4642 | 1921 | 2 | 2016-07-01 14:02:23 |
| 4643 | 1940 | 2 | 2016-07-01 14:02:27 |
| 4644 | 1934 | 2 | 2016-07-01 14:02:29 |
| 4645 | 1939 | 2 | 2016-07-01 14:03:06 |
| 4646 | 1892 | 2 | 2016-07-01 14:03:10 |
| 4647 | 1929 | 2 | 2016-07-01 14:03:13 |
| 4648 | 1901 | 2 | 2016-07-01 14:03:26 |
| 4649 | 1912 | 2 | 2016-07-01 14:04:28 |
| 4650 | 1926 | 2 | 2016-07-01 14:04: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;