Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 14,051–14,075 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 14051 | 6956 | 3 | 2018-12-04 15:19:28 |
| 14052 | 6969 | 3 | 2018-12-04 15:21:10 |
| 14053 | 6990 | 3 | 2018-12-04 15:21:26 |
| 14054 | 6991 | 3 | 2018-12-04 15:21:31 |
| 14055 | 6955 | 3 | 2018-12-04 15:24:17 |
| 14056 | 6987 | 3 | 2018-12-04 15:26:34 |
| 14057 | 6970 | 3 | 2018-12-04 15:27:47 |
| 14058 | 6961 | 3 | 2018-12-04 15:28:41 |
| 14059 | 6963 | 3 | 2018-12-04 15:30:23 |
| 14060 | 6995 | 3 | 2018-12-04 15:31:33 |
| 14061 | 6958 | 3 | 2018-12-04 15:34:20 |
| 14062 | 6996 | 3 | 2018-12-04 15:34:35 |
| 14063 | 6980 | 3 | 2018-12-04 15:34:50 |
| 14064 | 7000 | 3 | 2018-12-04 15:35:06 |
| 14065 | 6988 | 3 | 2018-12-04 15:36:04 |
| 14066 | 6974 | 3 | 2018-12-04 15:36:08 |
| 14067 | 6953 | 3 | 2018-12-04 15:38:02 |
| 14068 | 6977 | 3 | 2018-12-04 15:38:04 |
| 14069 | 6984 | 3 | 2018-12-04 15:38:05 |
| 14070 | 6993 | 3 | 2018-12-04 15:38:59 |
| 14071 | 6999 | 3 | 2018-12-04 15:39:37 |
| 14072 | 6983 | 3 | 2018-12-04 15:40:01 |
| 14073 | 6950 | 3 | 2018-12-04 15:42:44 |
| 14074 | 6985 | 3 | 2018-12-04 15:43:10 |
| 14075 | 6959 | 3 | 2018-12-04 15:43:32 |
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;