Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 4,726–4,750 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 4726 | 1931 | 3 | 2016-07-01 15:10:09 |
| 4727 | 1903 | 1 | 2016-07-01 15:10:57 |
| 4728 | 1895 | 3 | 2016-07-01 15:11:11 |
| 4729 | 1898 | 3 | 2016-07-01 15:11:51 |
| 4730 | 1892 | 3 | 2016-07-01 15:14:21 |
| 4731 | 1927 | 3 | 2016-07-01 15:15:32 |
| 4732 | 1941 | 1 | 2016-07-01 15:15:39 |
| 4733 | 1906 | 1 | 2016-07-01 15:16:59 |
| 4734 | 1942 | 1 | 2016-07-01 15:17:03 |
| 4735 | 1940 | 3 | 2016-07-01 15:17:18 |
| 4736 | 1936 | 1 | 2016-07-01 15:18:50 |
| 4737 | 1934 | 1 | 2016-07-01 15:19:01 |
| 4738 | 2439 | 2 | 2016-07-01 15:19:03 |
| 4739 | 1933 | 1 | 2016-07-01 15:19:15 |
| 4740 | 1947 | 1 | 2016-07-01 15:20:26 |
| 4741 | 2440 | 2 | 2016-07-01 15:22:56 |
| 4742 | 1939 | 1 | 2016-07-01 15:23:19 |
| 4743 | 1946 | 1 | 2016-07-01 15:24:04 |
| 4744 | 1948 | 1 | 2016-07-01 15:25:48 |
| 4745 | 1930 | 1 | 2016-07-01 15:26:40 |
| 4746 | 1932 | 3 | 2016-07-01 15:28:03 |
| 4747 | 1910 | 3 | 2016-07-01 15:28:29 |
| 4748 | 1902 | 3 | 2016-07-01 15:31:15 |
| 4749 | 1905 | 1 | 2016-07-01 15:33:11 |
| 4750 | 1921 | 1 | 2016-07-01 15:33:27 |
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;