Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 4,951–4,975 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 4951 | 2482 | 1 | 2016-07-17 10:17:14 |
| 4952 | 2510 | 3 | 2016-07-17 10:29:34 |
| 4953 | 2483 | 3 | 2016-07-17 10:32:03 |
| 4954 | 2482 | 3 | 2016-07-17 11:05:37 |
| 4955 | 2510 | 2 | 2016-07-17 11:13:12 |
| 4956 | 2514 | 1 | 2016-07-17 13:59:30 |
| 4957 | 2512 | 1 | 2016-07-17 14:01:58 |
| 4958 | 2513 | 2 | 2016-07-17 14:07:24 |
| 4959 | 2511 | 1 | 2016-07-17 14:12:42 |
| 4960 | 2515 | 1 | 2016-07-17 14:12:51 |
| 4961 | 2511 | 3 | 2016-07-17 14:40:15 |
| 4962 | 2513 | 1 | 2016-07-17 14:43:06 |
| 4963 | 2515 | 3 | 2016-07-17 15:11:50 |
| 4964 | 2514 | 3 | 2016-07-17 15:18:26 |
| 4965 | 2512 | 3 | 2016-07-17 15:19:39 |
| 4966 | 2513 | 3 | 2016-07-17 15:22:53 |
| 4967 | 2479 | 1 | 2016-07-18 12:52:01 |
| 4968 | 2476 | 1 | 2016-07-18 12:54:10 |
| 4969 | 2477 | 1 | 2016-07-18 12:57:32 |
| 4970 | 2478 | 1 | 2016-07-18 13:04:24 |
| 4971 | 2476 | 3 | 2016-07-18 13:49:52 |
| 4972 | 2479 | 3 | 2016-07-18 13:52:58 |
| 4973 | 2478 | 3 | 2016-07-18 14:05:41 |
| 4974 | 2477 | 3 | 2016-07-18 14:17:13 |
| 4975 | 2476 | 1 | 2016-07-18 14:17:42 |
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;