Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 4,751–4,775 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 4751 | 1919 | 1 | 2016-07-01 15:33:30 |
| 4752 | 1893 | 3 | 2016-07-01 15:33:48 |
| 4753 | 1907 | 1 | 2016-07-01 15:36:23 |
| 4754 | 1928 | 3 | 2016-07-01 15:36:48 |
| 4755 | 1922 | 3 | 2016-07-01 15:37:36 |
| 4756 | 1917 | 1 | 2016-07-01 15:37:56 |
| 4757 | 1914 | 3 | 2016-07-01 15:38:23 |
| 4758 | 1935 | 1 | 2016-07-01 15:38:44 |
| 4759 | 1929 | 1 | 2016-07-01 15:38:45 |
| 4760 | 1908 | 3 | 2016-07-01 15:38:56 |
| 4761 | 1938 | 1 | 2016-07-01 15:39:04 |
| 4762 | 1916 | 1 | 2016-07-01 15:40:47 |
| 4763 | 1926 | 3 | 2016-07-01 15:41:02 |
| 4764 | 1941 | 3 | 2016-07-01 15:42:21 |
| 4765 | 1949 | 3 | 2016-07-01 15:42:52 |
| 4766 | 1909 | 3 | 2016-07-01 15:43:31 |
| 4767 | 1911 | 3 | 2016-07-01 15:43:49 |
| 4768 | 1904 | 1 | 2016-07-01 15:44:10 |
| 4769 | 1915 | 3 | 2016-07-01 15:44:38 |
| 4770 | 1900 | 3 | 2016-07-01 15:45:02 |
| 4771 | 1937 | 3 | 2016-07-01 15:45:18 |
| 4772 | 1920 | 3 | 2016-07-01 15:46:51 |
| 4773 | 1925 | 3 | 2016-07-01 15:47:53 |
| 4774 | 1942 | 3 | 2016-07-01 15:48:01 |
| 4775 | 1896 | 3 | 2016-07-01 15:48:35 |
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;