Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 16,851–16,875 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 16851 | 7942 | 1 | 2019-07-14 12:46:36 |
| 16852 | 8547 | 2 | 2019-07-14 12:48:00 |
| 16853 | 7937 | 1 | 2019-07-14 12:49:11 |
| 16854 | 7947 | 1 | 2019-07-14 12:49:50 |
| 16855 | 7953 | 1 | 2019-07-14 12:49:57 |
| 16856 | 7934 | 3 | 2019-07-14 12:50:19 |
| 16857 | 7960 | 1 | 2019-07-14 12:50:26 |
| 16858 | 7938 | 3 | 2019-07-14 12:51:53 |
| 16859 | 7961 | 3 | 2019-07-14 12:53:16 |
| 16860 | 8555 | 1 | 2019-07-14 12:53:58 |
| 16861 | 7951 | 1 | 2019-07-14 12:54:44 |
| 16862 | 7949 | 1 | 2019-07-14 12:55:44 |
| 16863 | 7959 | 3 | 2019-07-14 12:56:35 |
| 16864 | 7935 | 1 | 2019-07-14 12:59:27 |
| 16865 | 7956 | 3 | 2019-07-14 13:00:49 |
| 16866 | 7963 | 3 | 2019-07-14 13:05:59 |
| 16867 | 7944 | 3 | 2019-07-14 13:08:55 |
| 16868 | 7969 | 3 | 2019-07-14 13:09:22 |
| 16869 | 7972 | 3 | 2019-07-14 13:10:53 |
| 16870 | 7958 | 3 | 2019-07-14 13:11:37 |
| 16871 | 7966 | 3 | 2019-07-14 13:12:03 |
| 16872 | 7948 | 3 | 2019-07-14 13:14:39 |
| 16873 | 7946 | 3 | 2019-07-14 13:15:20 |
| 16874 | 7971 | 3 | 2019-07-14 13:15:33 |
| 16875 | 7953 | 3 | 2019-07-14 13:16:29 |
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;